How to Extract Quoted Line Items Data

I would like to utilize the REST API to extract QLI data. I need the related Quote to be exposed as well as the individual QLIs. 

I have a working Webhook where Quote header data is pushed to on external system using a specific trigger in Sugar. That data creates a sales order in our ERP. 

I require the QLI data to accompany that Quote data when pushing to the ERP. 

How do I go about doing that?



  • Once you have a quote bean id you can retrieve the related products using the link name and the related module api:

    GET /<module>/:record/link/:link_name

    Quoted Line Items is a little tricky because the name of the module is actually "Products".

    The link name for quoted line items is "products"


    /Quotes/<the quote bean id>/link/products 

    will get you all the products on the Quote.

    For example: 


    will get all products related to the quote with that id.


    When I need to find the name of a relationship (link) I generally go to the cache of the module

    So I went to 


    I searched for the module name "Products" and found the definition of the one-to-many relationship:

        'quote_products' =>
        array (
          'lhs_module' => 'Quotes',
          'lhs_table' => 'quotes',
          'lhs_key' => 'id',
          'rhs_module' => 'Products',
          'rhs_table' => 'products',
          'rhs_key' => 'quote_id',
          'relationship_type' => 'one-to-many',

    From the relationship name "quote_products" I found the definition of type = link for products and hence the link name.

        'products' =>
        array (
          'name' => 'products',
          'type' => 'link',
          'relationship' => 'quote_products',
          'vname' => 'LBL_PRODUCTS',
          'source' => 'non-db',


  • Good day Francesca, 

    Thank you for your reply. I will give this a shot and let you know how it goes. 





Reply Children
No Data