Hi,
I have developed a simple C# program to extract Quotes from Sugar using the example
sugarondemand.com/rest/v11/Quotes/{0}
However this returns the header data only.
Question is:
What do I use to return the Quote Line Items?
Thank you
Hi,
I have developed a simple C# program to extract Quotes from Sugar using the example
sugarondemand.com/rest/v11/Quotes/{0}
However this returns the header data only.
Question is:
What do I use to return the Quote Line Items?
Thank you
If you get the quotes data there should be a 'bundles' property in the json returned.
Hi Jeroen,
Thank you for reply. I have been testing in postman and can view the header, but there are no bundles property in my json response.
{
"id": "0bd9effa-2569-11eb-bcbb-02dad32f8720",
"name": "test",
"date_entered": "2020-11-13T15:31:06+11:00",
"date_modified": "2020-12-04T11:12:19+11:00",
"modified_user_id": "5a86deca-2539-821d-832c-57b3ef40b586",
"modified_by_name": "Admin",
"modified_user_link": {
"full_name": "Admin",
"id": "5a86deca-2539-821d-832c-57b3ef40b586",
"_acl": {
"fields": {
"pwd_last_changed": {
"write": "no",
"create": "no"
},
"last_login": {
"write": "no",
"create": "no"
}
},
"_hash": "6d408abe17083243re7afd72eaecf780699c2"
}
},
"created_by": "dXfe43ef0-75e7-sqds11e9-aa84-06dc56813a60",
"created_by_name": "User Name",
"created_by_link": {
"full_name": "User Name",
"id": "dfe43ef0-75e7-11e9-aa84-06dc5681313a60",
"_acl": {
"fields": [],
"_hash": "654d337e0e2912edaa00dbb0fb3dc3c17"
}
},
"description": "",
"deleted": false,
"shipper_id": "",
"shipper_name": "",
"shippers": {
"name": "",
"id": "",
"_acl": {
"fields": [],
"_hash": "654d33w7e0e912edaa0034dbb0fb3dc3c17"
}
},
"taxrate_id": "61762173-85323a-1375-6a4c-56d54137925b1",
"taxrate_name": "GST",
"taxrates": {
"name": "GST",
"id": "617632173-85323a-1375-6a4c-56d5137925b1",
"_acl": {
"fields": [],
"_hash": "654d337e033e912edaa00dbb0fb3d32c3c17"
}
},
"taxrate_value": "10.000000",
"show_line_nums": true,
"quote_type": "Quotes",
"date_quote_expected_closed": "2020-12-31",
"original_po_date": "",
"payment_terms": "",
"date_quote_closed": "",
"date_order_shipped": "",
"order_stage": "Pending",
"quote_stage": "Draft",
"purchase_order_num": "",
"quote_num": 11729,
"subtotal": "1465.000000",
"subtotal_usdollar": "1465.000000",
"shipping": "0.000000",
"shipping_usdollar": "0.000000",
"discount": "0.000000",
"deal_tot": "0.00",
"deal_tot_discount_percentage": 0,
"deal_tot_usdollar": "0.00",
"new_sub": "1465.000000",
"new_sub_usdollar": "1465.000000",
"taxable_subtotal": "1465.000000",
"tax": "146.500000",
"tax_usdollar": "146.500000",
"total": "1611.500000",
"total_usdollar": "1611.500000",
"billing_address_street": "",
"billing_address_city": "",
"billing_address_state": "Victoria",
"billing_address_postalcode": "",
"billing_address_country": "",
"shipping_address_street": "",
"shipping_address_city": "",
"shipping_address_state": "Vic",
"shipping_address_postalcode": "",
"shipping_address_country": "",
"shipping_account_name": "Test Practice",
"shipping_accounts": {
"name": "Test Practice",
"id": "9918dd4c-4653-c0fa-c9fe-572ac94d4e17",
"_acl": {
"fields": [],
"_hash": "654d337e0e912edaa00dbb0fb3dc3c17"
}
},
"shipping_account_id": "9918dd4c-4653-c0fa-c9fe-572ac94d4e17",
"shipping_contact_name": "",
"shipping_contacts": {
"full_name": "",
"id": "",
"_acl": {
"fields": [],
"_hash": "654d337e0e912edaa00dbb0fb3dc3c17"
}
},
"shipping_contact_id": "",
"account_name": "Test Practice",
"billing_accounts": {
"name": "Test Practice",
"id": "9918dd4c-4653-c0fa-c9fe-572ac94d4e17",
"_acl": {
"fields": [],
"_hash": "654d337e0e912edaa00dbb0fb3dc3c17"
}
},
"account_id": "9918dd4c-4653-c0fa-c9fe-572ac94d4e17",
"billing_account_name": "Test Practice",
"billing_account_id": "9918dd4c-4653-c0fa-c9fe-572ac94d4e17",
"billing_contact_name": "",
"billing_contacts": {
"full_name": "",
"id": "",
"_acl": {
"fields": [],
"_hash": "654d337e0e912edaa00dbb0fb3dc3c17"
}
},
"billing_contact_id": "",
"opportunity_name": "",
"opportunities": {
"name": "",
"id": "0bd9effa-2569-11eb-bcbb-02dad32f8720",
"_acl": {
"fields": [],
"_hash": "654d337e0e912edaa00dbb0fb3dc3c17"
}
},
"opportunity_id": "",
"following": "",
"my_favorite": false,
"tag": [],
"sync_key": "",
"assigned_user_id": "dfe4sdfs3ef0-75e7-11e9-aa84-06dc56813a60",
"assigned_user_name": "Test User",
"assigned_user_link": {
"full_name": "Test User",
"id": "dfedswd43ef0-75e7-11e9-aa84-06dc56813a60",
"_acl": {
"fields": [],
"_hash": "654dsadsw337e0e912edaa00dbb0fb3dc3c17"
}
},
"team_count": "",
"team_count_link": {
"team_count": "",
"id": "1",
"_acl": {
"fields": [],
"_hash": "654d337e0e91dwdqd2edaa00dbb0fb3dc3c17"
}
},
"team_name": [
{
"id": "1",
"name": "Global",
"name_2": "",
"primary": true
}
],
"currency_id": "-99",
"base_rate": "1.000000",
"currency_name": "",
"currencies": {
"name": "",
"id": "-99",
"_acl": {
"fields": [],
"_hash": "65asd4d337e0sdcseve912edaa00dbc34b0fb3dc3c17"
},
"symbol": ""
},
"currency_symbol": "",
"incl_gst_c": "2130.000000",
"gst_mgt_c": "Grand Total inc GST",
"closed_accepted_total_c": "0.000000",
"new_sub_shipping_c": "1465.000000",
"gst_c": "665.000000",
"show_total_incl_gst_c": false,
"monthly_subcription_c": false,
"product_count_c": 5,
"product_count_monthly_sub_c": 0,
"product_count_non_sub_c": 5,
"product_count_bundle_c": 1,
"payment_terms_c": "",
"special_price_quote_c": true,
"second_year_c": "yes",
"customerreferencenumber_c": "",
"customer_reference_number_c": null,
"sap_order_c": 0,
"_acl": {
"fields": {}
},
"_module": "Quotes"
}
Do you by chance have an
Regards
Brendan
Hi Jeroen,
Thank you for reply. I have been testing in postman and can view the header, but there are no bundles property in my json response.
{
"id": "0bd9effa-2569-11eb-bcbb-02dad32f8720",
"name": "test",
"date_entered": "2020-11-13T15:31:06+11:00",
"date_modified": "2020-12-04T11:12:19+11:00",
"modified_user_id": "5a86deca-2539-821d-832c-57b3ef40b586",
"modified_by_name": "Admin",
"modified_user_link": {
"full_name": "Admin",
"id": "5a86deca-2539-821d-832c-57b3ef40b586",
"_acl": {
"fields": {
"pwd_last_changed": {
"write": "no",
"create": "no"
},
"last_login": {
"write": "no",
"create": "no"
}
},
"_hash": "6d408abe17083243re7afd72eaecf780699c2"
}
},
"created_by": "dXfe43ef0-75e7-sqds11e9-aa84-06dc56813a60",
"created_by_name": "User Name",
"created_by_link": {
"full_name": "User Name",
"id": "dfe43ef0-75e7-11e9-aa84-06dc5681313a60",
"_acl": {
"fields": [],
"_hash": "654d337e0e2912edaa00dbb0fb3dc3c17"
}
},
"description": "",
"deleted": false,
"shipper_id": "",
"shipper_name": "",
"shippers": {
"name": "",
"id": "",
"_acl": {
"fields": [],
"_hash": "654d33w7e0e912edaa0034dbb0fb3dc3c17"
}
},
"taxrate_id": "61762173-85323a-1375-6a4c-56d54137925b1",
"taxrate_name": "GST",
"taxrates": {
"name": "GST",
"id": "617632173-85323a-1375-6a4c-56d5137925b1",
"_acl": {
"fields": [],
"_hash": "654d337e033e912edaa00dbb0fb3d32c3c17"
}
},
"taxrate_value": "10.000000",
"show_line_nums": true,
"quote_type": "Quotes",
"date_quote_expected_closed": "2020-12-31",
"original_po_date": "",
"payment_terms": "",
"date_quote_closed": "",
"date_order_shipped": "",
"order_stage": "Pending",
"quote_stage": "Draft",
"purchase_order_num": "",
"quote_num": 11729,
"subtotal": "1465.000000",
"subtotal_usdollar": "1465.000000",
"shipping": "0.000000",
"shipping_usdollar": "0.000000",
"discount": "0.000000",
"deal_tot": "0.00",
"deal_tot_discount_percentage": 0,
"deal_tot_usdollar": "0.00",
"new_sub": "1465.000000",
"new_sub_usdollar": "1465.000000",
"taxable_subtotal": "1465.000000",
"tax": "146.500000",
"tax_usdollar": "146.500000",
"total": "1611.500000",
"total_usdollar": "1611.500000",
"billing_address_street": "",
"billing_address_city": "",
"billing_address_state": "Victoria",
"billing_address_postalcode": "",
"billing_address_country": "",
"shipping_address_street": "",
"shipping_address_city": "",
"shipping_address_state": "Vic",
"shipping_address_postalcode": "",
"shipping_address_country": "",
"shipping_account_name": "Test Practice",
"shipping_accounts": {
"name": "Test Practice",
"id": "9918dd4c-4653-c0fa-c9fe-572ac94d4e17",
"_acl": {
"fields": [],
"_hash": "654d337e0e912edaa00dbb0fb3dc3c17"
}
},
"shipping_account_id": "9918dd4c-4653-c0fa-c9fe-572ac94d4e17",
"shipping_contact_name": "",
"shipping_contacts": {
"full_name": "",
"id": "",
"_acl": {
"fields": [],
"_hash": "654d337e0e912edaa00dbb0fb3dc3c17"
}
},
"shipping_contact_id": "",
"account_name": "Test Practice",
"billing_accounts": {
"name": "Test Practice",
"id": "9918dd4c-4653-c0fa-c9fe-572ac94d4e17",
"_acl": {
"fields": [],
"_hash": "654d337e0e912edaa00dbb0fb3dc3c17"
}
},
"account_id": "9918dd4c-4653-c0fa-c9fe-572ac94d4e17",
"billing_account_name": "Test Practice",
"billing_account_id": "9918dd4c-4653-c0fa-c9fe-572ac94d4e17",
"billing_contact_name": "",
"billing_contacts": {
"full_name": "",
"id": "",
"_acl": {
"fields": [],
"_hash": "654d337e0e912edaa00dbb0fb3dc3c17"
}
},
"billing_contact_id": "",
"opportunity_name": "",
"opportunities": {
"name": "",
"id": "0bd9effa-2569-11eb-bcbb-02dad32f8720",
"_acl": {
"fields": [],
"_hash": "654d337e0e912edaa00dbb0fb3dc3c17"
}
},
"opportunity_id": "",
"following": "",
"my_favorite": false,
"tag": [],
"sync_key": "",
"assigned_user_id": "dfe4sdfs3ef0-75e7-11e9-aa84-06dc56813a60",
"assigned_user_name": "Test User",
"assigned_user_link": {
"full_name": "Test User",
"id": "dfedswd43ef0-75e7-11e9-aa84-06dc56813a60",
"_acl": {
"fields": [],
"_hash": "654dsadsw337e0e912edaa00dbb0fb3dc3c17"
}
},
"team_count": "",
"team_count_link": {
"team_count": "",
"id": "1",
"_acl": {
"fields": [],
"_hash": "654d337e0e91dwdqd2edaa00dbb0fb3dc3c17"
}
},
"team_name": [
{
"id": "1",
"name": "Global",
"name_2": "",
"primary": true
}
],
"currency_id": "-99",
"base_rate": "1.000000",
"currency_name": "",
"currencies": {
"name": "",
"id": "-99",
"_acl": {
"fields": [],
"_hash": "65asd4d337e0sdcseve912edaa00dbc34b0fb3dc3c17"
},
"symbol": ""
},
"currency_symbol": "",
"incl_gst_c": "2130.000000",
"gst_mgt_c": "Grand Total inc GST",
"closed_accepted_total_c": "0.000000",
"new_sub_shipping_c": "1465.000000",
"gst_c": "665.000000",
"show_total_incl_gst_c": false,
"monthly_subcription_c": false,
"product_count_c": 5,
"product_count_monthly_sub_c": 0,
"product_count_non_sub_c": 5,
"product_count_bundle_c": 1,
"payment_terms_c": "",
"special_price_quote_c": true,
"second_year_c": "yes",
"customerreferencenumber_c": "",
"customer_reference_number_c": null,
"sap_order_c": 0,
"_acl": {
"fields": {}
},
"_module": "Quotes"
}
Do you by chance have an
Regards
Brendan
Can you check in sugar if there are actual quote line items connected to the quote?
which version of sugar are we talking about?