How to Extract Quoted Line Items Data

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

https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_11.2/Integration/Web_Services/REST_API/Endpoints/modulerecordlinklink_name_GET/

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"

therefore

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

will get you all the products on the Quote.

For example: 

/Quotes/b63eb8a0-80c2-11ea-862d-001a4a160206/link/products

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

Note:

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

So I went to 

cache/modules/Quotes/Quotevardefs.php

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',
    ),

FrancescaS

Good day Francesca, 

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

Best, 

SL

Francesca Shiekh , 

Your solution worked beautifully. Thank you for the thorough explanation. 

Cheers, 

SL