Getting Line Items on Invoice in from SuiteCRM

:bullseye: What is your goal?

I’m trying to pull line items from an Invoice record in SuiteCRM into Make.com.
The Watch Objects trigger returns the invoice header (billing info, totals, etc.) but the line_items field is always blank.
My goal is to retrieve the actual line-item rows associated with the invoice.

:thinking: What is the problem & what have you tried?

When I use the SuiteCRM Watch Objects trigger, the bundle only includes high-level invoice fields and no line item details. The line_items field is empty even though the invoice has multiple products/services added in SuiteCRM.

From what I understand, SuiteCRM stores invoice line items in related modules such as AOS_Products_Quotes, but the Make module doesn’t automatically expand or return related items.

I tried:

Watching different modules (Invoices, Quotes)

Checking all output fields, none contain line items

Confirming the invoice does have line items in SuiteCRM UI

Searching through the Make SuiteCRM modules for one that returns line items

Looking for relationship info in the bundle, but none shows up

I’m not sure if I need to:

Make a second API call to the related module,

Use a different SuiteCRM module entirely, or

Trigger a custom webhook from SuiteCRM.

I’d like guidance on the correct way to fetch invoice line items through Make.

:clipboard: Error messages or input/output bundles

Here is a sample bundle returned from the Watch Objects trigger (line_items is empty even though the invoice has multiple items):

“line_items”: “”

Full bundle attached in screenshot above.

:camera_with_flash: Screenshots (scenario flow, module settings, errors)

This is a common occurence with some of the Make Modules that are build, you hit the limitations of them. The solution is to use the http request module in Make and directly access the SuiteCRM API

2 Likes

Thanks @dreamsuite_mike