# API Calls as a solution to the Filter/Search problem of Big Tables? - Price Issue **URL:** \ **Category:** Ask for Help\ **Created:** [October 11, 2023, 7:18am UTC](https://community.glideapps.com/t/api-calls-as-a-solution-to-the-filter-search-problem-of-big-tables-price-issue/66895 "2023-10-11T07:18:36Z")\ **Posts on this page:** 6\ **Page:** 2
**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 6, 2024, 5:31am UTC](https://community.glideapps.com/t/api-calls-as-a-solution-to-the-filter-search-problem-of-big-tables-price-issue/66895/21 "2024-09-06T05:31:09Z")
Hi @Darren_Murphy , > [@Darren\_Murphy](#): > > A joined list of RowIDs, and then a separate joined list for each parameter that you want to add/edit. The JavaScript column only accepts 3 parameters, so you’ll probably end up having to create a joined list of joined lists, and then do a double split in the code. One possible issue I can see is, My tables rows are not defined. it can keep increasing over period of time. So we cannot add it dynamically right? I mean ill have to keep creating joined list as rows increase? Please correct me if I am wrong? Is there no way a JS can give me the combined array of all rows? 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 6, 2024, 5:32am UTC](https://community.glideapps.com/t/api-calls-as-a-solution-to-the-filter-search-problem-of-big-tables-price-issue/66895/22 "2024-09-06T05:32:52Z")
> [@Dilip\_Adiga](#): > > I mean ill have to keep creating joined list as rows increase? Why would you need to do that? A Joined List is a computed column, it will operate on all rows that are present. ---
**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 6, 2024, 5:34am UTC](https://community.glideapps.com/t/api-calls-as-a-solution-to-the-filter-search-problem-of-big-tables-price-issue/66895/23 "2024-09-06T05:34:48Z")
Hi @Darren_Murphy I understanding creating a Joined List of all Row-ID. I could do it where it gives me dynamically list of all Row-ID’s present in the table. ![Screenshot 2024-09-06 at 11.05.24 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/1/6178142d9de58d7a872f1448dfb32824dda6bf01.png) **How can I get the Values inside them? Is there a way I can apply Java script on this Row-ID’s to get it?** I cannot do a joined List of my API mutation column which is a template column. Again it will lead me to warning saying only 100 rows can be used. Trying to create a Joined List of my template column or JS out put column gives me this error ![Screenshot 2024-09-06 at 11.11.29 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/3/83b8a62bdc2a9648ebb8458e149e588c71243c09.png) it says computed column not supported 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 6, 2024, 5:51am UTC](https://community.glideapps.com/t/api-calls-as-a-solution-to-the-filter-search-problem-of-big-tables-price-issue/66895/24 "2024-09-06T05:51:32Z")
@Darren_Murphy , I think I get what you are saying. Create a joined list for each of the values I need to send and combine them such that it comes well within 3 parameters to be sent to JS. Is this an approach I can take? Wont it create latency ? **Main reason for using big table** Is to get filtered list of people to be sent via API. Do you think I can instead keep two tables one Big table and one normal glide table. ? Which approach would you suggest? 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 6, 2024, 6:37am UTC](https://community.glideapps.com/t/api-calls-as-a-solution-to-the-filter-search-problem-of-big-tables-price-issue/66895/25 "2024-09-06T06:37:51Z")
> [@Darren\_Murphy](#): > > The JavaScript column only accepts 3 parameters, so you’ll probably end up having to create a joined list of joined lists, and then do a double split in the code. How can I do this @Darren_Murphy ? 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 6, 2024, 9:15am UTC](https://community.glideapps.com/t/api-calls-as-a-solution-to-the-filter-search-problem-of-big-tables-price-issue/66895/26 "2024-09-06T09:15:47Z")
Create multiple Joined List columns, and then combine them using a template column with a different separator. I usually use a double-pipe `||`, as it’s pretty rare that you would have that in your data. You’ll then have a Joined List of Joined Lists, with the outer list separated by double-pipe, and the inner lists separated by commas. [Previous page](https://community.glideapps.com/t/api-calls-as-a-solution-to-the-filter-search-problem-of-big-tables-price-issue/66895.md?page=1)