Rest API Quote Line Items

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

Parents
  • 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

Reply
  • 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

Children