Construct Array of Objects (from relations) to be used in an API Call

[Rupert]

Hi Glide wizzards,

I wanted to record how to use the new DocsAutomator version with Glide using “Call API”, but I can’t figure out how to construct arrays of objects without those objects becoming one big string (this is for dynamic tables / line item tables).

I have two tables: Invoices and Line items. One invoice can have multiple line items.

In the line items table, I’m building the row objects using JSON Object:

In the invoices tables, I now need to “roll up” those objects. I’m using Joined List for that:

Eventually this needs to become an array, so I’ve used Make Array. The issue is that this actually produces an array of a single string / text:

Before trying more variations of different fields, I thought I’d reach out

Thanks a lot for your help!

[Darren_Murphy]

Try using a Lookup instead of a Joined List, and pass that into a JSON Template column.

[Rupert]

Thank you, @Darren_Murphy! Absolute legend. Joined List seems to stringify, whereas Lookup preserves objects.