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

**URL:** <https://community.glideapps.com/t/using-call-api-and-glide-api-to-add-rows-to-related-tables-also-json-object/70860>\
**Category:** Project Showcase\
**Tags:** tutorial\
**Created:** [February 15, 2024, 9:15pm UTC](https://community.glideapps.com/t/using-call-api-and-glide-api-to-add-rows-to-related-tables-also-json-object/70860 "2024-02-15T21:15:45Z")\
**Posts on this page:** 1\
**Showing post:** 15

<div class="post-metadata">

**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\
**Post date:** [September 5, 2024, 12:43am UTC](https://community.glideapps.com/t/using-call-api-and-glide-api-to-add-rows-to-related-tables-also-json-object/70860/15 "2024-09-05T00:43:29Z")

</div>

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](https://community.glideapps.com/t/api-calls-as-a-solution-to-the-filter-search-problem-of-big-tables-price-issue/66895/5):
>
> 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

---

_[View the full topic](https://community.glideapps.com/t/using-call-api-and-glide-api-to-add-rows-to-related-tables-also-json-object/70860)._
