Rest API Quote Line Items

Hi Brendan,

It seems the generic question is  how to deal with Sugar data while having a strong technical background, admin-level knowledge Sugar  but no time to learn how to develop for Sugar

Actually, necessary data preparations could be configured in Sugar with Logic Builder configurator tool and exposed as the custom endpoint.

That is very easy for a non-developer to make it, so let me show an example on QLI retrieval case in a low-code approach:

There are 3 simple steps to achieve a result:
1) to declare a custom endpoint as Service
2) To implement Service in a Logic Builder flowchart 
3) To install the flowchart via Module Loader

I declared an endpoint with 2 parameters:


Then I drew a flowchart in Logic Builder (https://logicbuilder.integroscrm.com) to retrieve just a few necessary QLI fields for the QuoteName.
You may easily read it by following the white line.
As you can see, you may configure any logic and define the structure for selecting necessary data:


Then I've generated zip package in a click with Logic Builder and install it  to Sugar via Module Loader 

Now, if you use Postman to make an authorized request (user jim password  jim)  you will get a ready-to-use response with necessary QLIs data:

Response:

This approach works for both Sugar Cloud and on-premise, from version 7.5 and up to the modern one.

Hi Brendan,

It seems the generic question is  how to deal with Sugar data while having a strong technical background, admin-level knowledge Sugar  but no time to learn how to develop for Sugar

Actually, necessary data preparations could be configured in Sugar with Logic Builder configurator tool and exposed as the custom endpoint.

That is very easy for a non-developer to make it, so let me show an example on QLI retrieval case in a low-code approach:

There are 3 simple steps to achieve a result:
1) to declare a custom endpoint as Service
2) To implement Service in a Logic Builder flowchart 
3) To install the flowchart via Module Loader

I declared an endpoint with 2 parameters:


Then I drew a flowchart in Logic Builder (https://logicbuilder.integroscrm.com) to retrieve just a few necessary QLI fields for the QuoteName.
You may easily read it by following the white line.
As you can see, you may configure any logic and define the structure for selecting necessary data:


Then I've generated zip package in a click with Logic Builder and install it  to Sugar via Module Loader 

Now, if you use Postman to make an authorized request (user jim password  jim)  you will get a ready-to-use response with necessary QLIs data:

Response:

This approach works for both Sugar Cloud and on-premise, from version 7.5 and up to the modern one.

Hi Dmytro,

appreciate the detailed response. All im trying to do is connect to sugar and access the Quote and Quote Line Items.

As detailed above, I can call a quote and this is returning the Quote, but no array / list of items.

I would have assumed by default this function would return the items of a quote, but for some reason its not doing so.

Regards