Using Call API and Glide API to add rows to related tables. Also...JSON Object!

[Dilip_Adiga]

Thank you for replying @DarrenHumphries

I actually cam across a post by @Darren_Murphy which said to use Javascript column to create a JSON array.

API Calls as a solution to the Filter/Search problem of Big Tables? - Price Issue

Yes, that’s what I understood. That wont work - as I guess you’ve discovered - because you can’t take a joined list of a computed column from a Big Table. However, there is a workaround - and this is something that I have used, so I know it will work. Start by creating a Query, matching the SupplierID of the one you want to update. Take a Joined List of RowID’s through the Query (this will work, because it’s a non-computed column) Feed the Joined List into a JavaScript column that processe…

I tried various Javascripts but could not find one which gives me JSON array of all elements present in my table.

Thank you in advance for the help.

Regards,
Dilip