# Need help : getting Error when I trying to pass the API mutation template column as joined list in BigTable **URL:** \ **Category:** Ask for Help\ **Created:** [September 3, 2024, 6:07am UTC](https://community.glideapps.com/t/need-help-getting-error-when-i-trying-to-pass-the-api-mutation-template-column-as-joined-list-in-bigtable/76083 "2024-09-03T06:07:20Z")\ **Posts on this page:** 17\ **Page:** 1
**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 3, 2024, 6:07am UTC](https://community.glideapps.com/t/need-help-getting-error-when-i-trying-to-pass-the-api-mutation-template-column-as-joined-list-in-bigtable/76083/1 "2024-09-03T06:07:20Z")
Hi Guys, I have template column in my Big query table which has all values of the show API for API mutation. I am passing it into a joined list separated by comma column in the same Big query. it is giving me this error When I am saving it. ![Screenshot 2024-09-03 at 11.34.11 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/3/c3c3b9f6a1145a7b45c7f57ca2ee018c21f258f8.png) Is it something that is not allowed? Thank you in advance for help. Regards, Dilip ---
**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 3, 2024, 6:13am UTC](https://community.glideapps.com/t/need-help-getting-error-when-i-trying-to-pass-the-api-mutation-template-column-as-joined-list-in-bigtable/76083/2 "2024-09-03T06:13:28Z")
Hi Guys, What is the workaround if I cannot pass template column in glide big table ? Regards, Dilip ---
**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 3, 2024, 6:17am UTC](https://community.glideapps.com/t/need-help-getting-error-when-i-trying-to-pass-the-api-mutation-template-column-as-joined-list-in-bigtable/76083/3 "2024-09-03T06:17:58Z")
As a workaround will I need to create two tables one normal glide table where it will work, and One more glide big table? or is there any other workaround? Regards, Dilip ---
**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 3, 2024, 7:13am UTC](https://community.glideapps.com/t/need-help-getting-error-when-i-trying-to-pass-the-api-mutation-template-column-as-joined-list-in-bigtable/76083/4 "2024-09-03T07:13:02Z")
Hi @Darren_Murphy Good day to you. You had suggested to use Glide Big tables for filtered data to be available in Api response. but as I read it there are restrictions on only 100 rows for computed columns and Getting error for Template column to be passed into a joined List. Are these restrictions on platform or is there something I am doing wrong? Regards, Dilip ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 3, 2024, 7:31am UTC](https://community.glideapps.com/t/need-help-getting-error-when-i-trying-to-pass-the-api-mutation-template-column-as-joined-list-in-bigtable/76083/5 "2024-09-03T07:31:16Z")
> [@Dilip\_Adiga](#): > > but as I read it there are restrictions on only 100 rows for computed columns and Getting error for Template column to be passed into a joined List. This is in the data editor, it has nothing to do with the API. Computed columns are not available at all via the API. ---
**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 3, 2024, 7:44am UTC](https://community.glideapps.com/t/need-help-getting-error-when-i-trying-to-pass-the-api-mutation-template-column-as-joined-list-in-bigtable/76083/6 "2024-09-03T07:44:53Z")
Thank you for your reply @Darren_Murphy . What is the error I am getting when I am trying to pass the template column value to Joined list column to separate by comma? it says Computed Column is not supported on this data source? but if I do it in normal glide table there is no issue. Thank you in advance for helping out. Regards, Dilip ---
**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 3, 2024, 7:48am UTC](https://community.glideapps.com/t/need-help-getting-error-when-i-trying-to-pass-the-api-mutation-template-column-as-joined-list-in-bigtable/76083/7 "2024-09-03T07:48:00Z")
Hi, After multiple attempts of removing/adding. now I am getting this warning. ![Screenshot 2024-09-03 at 1.17.05 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/4/d46775cdbb605ee9d62efae16502ca489ab813ea.png) **Is there something I am doing wrong?** Regards, Dilip ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 3, 2024, 7:57am UTC](https://community.glideapps.com/t/need-help-getting-error-when-i-trying-to-pass-the-api-mutation-template-column-as-joined-list-in-bigtable/76083/8 "2024-09-03T07:57:31Z")
That’s correct. Lookups and Joined List of computed columns in Big Tables are limited to 100 rows. ---
**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 3, 2024, 8:10am UTC](https://community.glideapps.com/t/need-help-getting-error-when-i-trying-to-pass-the-api-mutation-template-column-as-joined-list-in-bigtable/76083/9 "2024-09-03T08:10:02Z")
Hi @Darren_Murphy , Thank you for replying. SO if my table will have more than 100 rows then this wont work? Could you tell me what can I do as a workaround? I am pretty sure I will have more than 100 rows coming in very very soon. Regards, Dilip ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 3, 2024, 8:21am UTC](https://community.glideapps.com/t/need-help-getting-error-when-i-trying-to-pass-the-api-mutation-template-column-as-joined-list-in-bigtable/76083/10 "2024-09-03T08:21:39Z")
It’s only an issue if you expect more than 100 matching rows. If you want a Joined List of more than 100 rows, then you need to work with non-computed columns. ---
**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 3, 2024, 8:27am UTC](https://community.glideapps.com/t/need-help-getting-error-when-i-trying-to-pass-the-api-mutation-template-column-as-joined-list-in-bigtable/76083/11 "2024-09-03T08:27:43Z")
Hi @Darren_Murphy , > [@Darren\_Murphy](#): > > It’s only an issue if you expect more than 100 matching rows. Matching rows is not same as total rows? I would need that as my template column is the API mutation column which has my values I will be passing this to Joined list column. Can you please help me as to how I can use non computed column to get this same thing done? EX: ![Screenshot 2024-09-03 at 1.57.22 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/f/9f63f2780330e69902c562192a5e961951084039.png) Regards, Dilip ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 3, 2024, 8:42am UTC](https://community.glideapps.com/t/need-help-getting-error-when-i-trying-to-pass-the-api-mutation-template-column-as-joined-list-in-bigtable/76083/12 "2024-09-03T08:42:11Z")
> [@Dilip\_Adiga](#): > > Matching rows is not same as total rows? Not if the Lookup/Joined List is done through a Relation or Query. > [@Dilip\_Adiga](#): > > Can you please help me as to how I can use non computed column to get this same thing done? The only thing I can think of is to add the JSON Object into a non-computed Text column when each row is added to your Big Table. Then you wouldn’t be subject to the 100 row limitation. ---
**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 3, 2024, 8:49am UTC](https://community.glideapps.com/t/need-help-getting-error-when-i-trying-to-pass-the-api-mutation-template-column-as-joined-list-in-bigtable/76083/13 "2024-09-03T08:49:40Z")
Hi @Darren_Murphy , thank you for replying. > [@Darren\_Murphy](#): > > Not if the Lookup/Joined List is done through a Relation or Query. No my Joined list is taking template column as input. Where I am replacing the mutation values with API value. They are not Relation or Query Then I wont face any issues right ? **Do I need to use the solution you gave?** > [@Darren\_Murphy](#): > > The only thing I can think of is to add the JSON Object into a non-computed Text column when each row is added to your Big Table. Then you wouldn’t be subject to the 100 row limitation. **I created JSON Object with required Fields** Then passed it via template column. But it still generates every row values. I cant use joined list right , how can I get all names list separated by “,”? Regards, Dilip ---
**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 3, 2024, 9:26am UTC](https://community.glideapps.com/t/need-help-getting-error-when-i-trying-to-pass-the-api-mutation-template-column-as-joined-list-in-bigtable/76083/14 "2024-09-03T09:26:48Z")
@Darren_Murphy Do you mean the workaround is something similar to this? > [@Using Call API and Glide API to add rows to related tables. Also...JSON Object!](https://community.glideapps.com/t/using-call-api-and-glide-api-to-add-rows-to-related-tables-also-json-object/70860): > > 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… This would also use Lookup from Glide Big table (In My case) when it tries doing the lookup from the Previous table. As I need to fetch JSON from previous table. Still gives the warning of more than 100 rows thing. Regards, Dilip ---
**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 3, 2024, 2:54pm UTC](https://community.glideapps.com/t/need-help-getting-error-when-i-trying-to-pass-the-api-mutation-template-column-as-joined-list-in-bigtable/76083/15 "2024-09-03T14:54:00Z")
Hi Guys, I could just create JSON Object. I can pass it via template column but it still constructs only particular ROW’s JSON. But how can I get a joined List without using Joined List computed column to get all available rows JSON? Regards, Dilip ---
**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 4, 2024, 3:18am UTC](https://community.glideapps.com/t/need-help-getting-error-when-i-trying-to-pass-the-api-mutation-template-column-as-joined-list-in-bigtable/76083/16 "2024-09-04T03:18:30Z")
Hi Guys, Any advice on this.? Thank you in advance Regards, Dilip ---
**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 4, 2024, 10:46am UTC](https://community.glideapps.com/t/need-help-getting-error-when-i-trying-to-pass-the-api-mutation-template-column-as-joined-list-in-bigtable/76083/17 "2024-09-04T10:46:34Z")
Hi Guys, For now I am creating a big table which will have details required to be sent out to API. Meaning there will be two tables one normal and one big table. When I write data to normal table and submit it’ll write required information to big table for further processing. This is a wacky workaround. But couldn’t get the JS to work. is this acceptable workaround? Regards, Dilip