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.
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