# 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:** 15
**Page:** 1
### Author:  [@DarrenHumphries](https://community.glideapps.com/u/DarrenHumphries)
#### Post date: [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/1 "2024-02-15T21:15:45Z")
I wanted to show how you can use our new JSON columns to allow you use Call API into the Glide API. This allows you to create multiple rows in a different table and related them to the main table.
Marco created a great [video](https://www.youtube.com/watch?v=b7_k3_brusQ&t=6s) showing how this was done with an older method (before we had all the great new JSON columns) that used a combination of template fields but you can do this all with just a JSON Object column now.
Here is a [Loom video](https://www.loom.com/share/041b3cf99dec42c1a4d25af8c7aee38f) to explain. If I missed explaining anything feel free to ask questions. Hope it’s helpful for your Glide projects!
Link: [Loom | Free Screen & Video Recording Software | Loom](https://www.loom.com/share/041b3cf99dec42c1a4d25af8c7aee38f)
---
### Author:  [@GrumpyRick](https://community.glideapps.com/u/GrumpyRick)
#### Post date: [February 15, 2024, 11:46pm UTC](https://community.glideapps.com/t/using-call-api-and-glide-api-to-add-rows-to-related-tables-also-json-object/70860/2 "2024-02-15T23:46:04Z")
Excellent. Thank you.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [February 15, 2024, 11:49pm UTC](https://community.glideapps.com/t/using-call-api-and-glide-api-to-add-rows-to-related-tables-also-json-object/70860/3 "2024-02-15T23:49:43Z")
Quick question here. You have the $ sign on Name but not on projectID but it still works. Is it intended behaviour or a bug?
---
### Author:  [@DarrenHumphries](https://community.glideapps.com/u/DarrenHumphries)
#### Post date: [February 16, 2024, 12:05am UTC](https://community.glideapps.com/t/using-call-api-and-glide-api-to-add-rows-to-related-tables-also-json-object/70860/4 "2024-02-16T00:05:33Z")
Oh, good point! I should have included the $. I don’t know if it’s intented that it works but I do know that this column is more intelligent than a regular template column. I’ll try changing it and see if there is any difference. Thanks for catching that.
---
### Author:  [@DarrenHumphries](https://community.glideapps.com/u/DarrenHumphries)
#### Post date: [February 16, 2024, 12:09am UTC](https://community.glideapps.com/t/using-call-api-and-glide-api-to-add-rows-to-related-tables-also-json-object/70860/5 "2024-02-16T00:09:53Z")
I think the column was correcting my mistake here. I added the $ and it actually works faster now. 🙂
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [February 16, 2024, 12:10am UTC](https://community.glideapps.com/t/using-call-api-and-glide-api-to-add-rows-to-related-tables-also-json-object/70860/6 "2024-02-16T00:10:36Z")
Good insight. Thank you!
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [February 16, 2024, 9:52am UTC](https://community.glideapps.com/t/using-call-api-and-glide-api-to-add-rows-to-related-tables-also-json-object/70860/7 "2024-02-16T09:52:53Z")
Very nice, Darren 👍
> [@DarrenHumphries](#):
>
> Marcus created a great [video](https://www.youtube.com/watch?v=b7_k3_brusQ&t=6s)
That would be Marco 😉
The Template column in your Predefined Tasks table isn’t actually required. You could refer directly to the value in your User Profile row from the JSON Template column.
One other comment I’d make is that whilst Call API is perfectly fine for sending a small number of mutations (say up to about a dozen), it isn’t suitable for large numbers of mutations because of the delay it introduces whilst the Glide API processes them. I’ve found that you get a much better (read “snappier”) user experience if you use Trigger Webhook → Make → Glide API instead. The delay is still there, but it’s removed from the user experience as it’s handled in the backgound by Make.
---
### Author:  [@DarrenHumphries](https://community.glideapps.com/u/DarrenHumphries)
#### Post date: [February 16, 2024, 12:16pm UTC](https://community.glideapps.com/t/using-call-api-and-glide-api-to-add-rows-to-related-tables-also-json-object/70860/8 "2024-02-16T12:16:50Z")
Oh man, I knew it was Marco, no idea how I typed that. 😄
Thanks for the tip about using the template from the user profile. I’ll give that a go.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [February 16, 2024, 12:21pm UTC](https://community.glideapps.com/t/using-call-api-and-glide-api-to-add-rows-to-related-tables-also-json-object/70860/9 "2024-02-16T12:21:55Z")
> [@DarrenHumphries](#):
>
> Oh man, I knew it was Marco, no idea how I typed that
Hey Derek, don’t worry. It’s an easy mistake to make! 😂
---
### Author:  [@DarrenHumphries](https://community.glideapps.com/u/DarrenHumphries)
#### Post date: [February 16, 2024, 1:15pm UTC](https://community.glideapps.com/t/using-call-api-and-glide-api-to-add-rows-to-related-tables-also-json-object/70860/10 "2024-02-16T13:15:45Z")
Thanks, Darryl!
---
### Author:  [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)
#### Post date: [September 3, 2024, 10:23am UTC](https://community.glideapps.com/t/using-call-api-and-glide-api-to-add-rows-to-related-tables-also-json-object/70860/11 "2024-09-03T10:23:42Z")
Hi @DarrenHumphries ,
Thank you for this video.
This does not work on Glide big tables right?
Imagine my Tasks are in Glide big tables
And In the second table I will be using Lookup, where I would need to fetch the data from Tasks —Glide big tables.
It would throw up a warning As I have more than 100 rows in my big table.
Regards,
Dilip
---
### Author:  [@DarrenHumphries](https://community.glideapps.com/u/DarrenHumphries)
#### Post date: [September 4, 2024, 12:36pm UTC](https://community.glideapps.com/t/using-call-api-and-glide-api-to-add-rows-to-related-tables-also-json-object/70860/12 "2024-09-04T12:36:04Z")
It’ll work for those 100. The warning is just that it is limited to that many.
---
### Author:  [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)
#### Post date: [September 4, 2024, 1:21pm UTC](https://community.glideapps.com/t/using-call-api-and-glide-api-to-add-rows-to-related-tables-also-json-object/70860/13 "2024-09-04T13:21:22Z")
Thank you for replying @DarrenHumphries ,
Then it wont work for my case as I will have more than 100 rows.
Currently in search of Javascrupt that can help me generate JSON.
Is there any other method you would recommend?
Regards,
Dilip
---
### Author:  [@DarrenHumphries](https://community.glideapps.com/u/DarrenHumphries)
#### Post date: [September 4, 2024, 1:54pm UTC](https://community.glideapps.com/t/using-call-api-and-glide-api-to-add-rows-to-related-tables-also-json-object/70860/14 "2024-09-04T13:54:45Z")
Sorry, but I’m not sure of another way to do this. Perhaps someone else here will have an idea.
---
### Author:  [@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")
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