Thread Details
  • State Verified Answer
  • Replies 3 replies
  • Subscribers 354 subscribers
  • Views 1519 views
  • Users 0 members are here
Forum Actions
Related

How to Extract Quoted Line Items Data

Seth Lewis

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?

Thanks, 

SL

Parents
  • +1

    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

Reply
  • +1

    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

Children