# Copy a Query result in App1 to a table in a different Glide app (App2) **URL:** \ **Category:** Ask for Help\ **Created:** [January 30, 2025, 1:46am UTC](https://community.glideapps.com/t/copy-a-query-result-in-app1-to-a-table-in-a-different-glide-app-app2/79654 "2025-01-30T01:46:57Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![MattLB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattlb/32/41284_2.png) [@MattLB](https://community.glideapps.com/u/MattLB)\ **Post date:** [January 30, 2025, 1:46am UTC](https://community.glideapps.com/t/copy-a-query-result-in-app1-to-a-table-in-a-different-glide-app-app2/79654/1 "2025-01-30T01:46:57Z")
I have two tables with the same basic columns in two different apps. I want to push the results of a query in App 1 and send it over to App 2 and populate a table with results. App1/Table1 and App2/Table1 have the same structure. Today I would manually ‘push a button’ to execute the transfer but in the future automate. I have a talker and listener Glide Apps set up for test using webhook workflows and the communication is there. What are my options for App to App data ‘copying’/sending? A shared table? Notify App2 that data is in the shared table to copy/AddRow into the final table? JSON arrays? Send a JSON basic columns with the query results and add them directly to the final table via a workflow? Is there a row/data max for a JSON array? Something else? TIA ---
**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\ **Post date:** [January 30, 2025, 2:00am UTC](https://community.glideapps.com/t/copy-a-query-result-in-app1-to-a-table-in-a-different-glide-app-app2/79654/2 "2025-01-30T02:00:52Z")
> [@MattLB](#): > > A shared table? Notify App2 that data is in the shared table to copy/AddRow into the final table? With this you would need a schedule workflow. > [@MattLB](#): > > JSON arrays? Send a JSON basic columns with the query results and add them directly to the final table via a workflow? Is there a row/data max for a JSON array? I would make a call API to the webhook workflow of the second app! Send your JSON arrays in the body! 🙂 Good idea. ---
**Author:** ![MattLB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattlb/32/41284_2.png) [@MattLB](https://community.glideapps.com/u/MattLB)\ **Post date:** [January 30, 2025, 2:36am UTC](https://community.glideapps.com/t/copy-a-query-result-in-app1-to-a-table-in-a-different-glide-app-app2/79654/3 "2025-01-30T02:36:28Z")
> [@MaximeBaker](#): > > With this you would need a schedule workflow. I thought I could use a webhook that would pass a RowID (column that identifies which rows within the Shared Rows table are part of this request) and then loop on Shared table filtering against RowID. Within the loop I would call an AddRow to insert from the Shared table to the local table. Since I am using AddRow from a Glide Table into a Glide Table, does this cost an “Update” like it says in the loop or is this free since it is data written from/to Glide tables? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 30, 2025, 3:07am UTC](https://community.glideapps.com/t/copy-a-query-result-in-app1-to-a-table-in-a-different-glide-app-app2/79654/4 "2025-01-30T03:07:02Z")
A scheduled workflow runs server side and uses server resources to run, so yes it would still cost updates and should indicate as such if updates apply. ---
**Author:** ![MattLB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattlb/32/41284_2.png) [@MattLB](https://community.glideapps.com/u/MattLB)\ **Post date:** [January 30, 2025, 4:01am UTC](https://community.glideapps.com/t/copy-a-query-result-in-app1-to-a-table-in-a-different-glide-app-app2/79654/5 "2025-01-30T04:01:58Z")
Is it one update for every time through the loop - eg 500 updates to copy 500 rows from one Glide table to another Glide table within an App? ---
**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:** [January 30, 2025, 4:09am UTC](https://community.glideapps.com/t/copy-a-query-result-in-app1-to-a-table-in-a-different-glide-app-app2/79654/6 "2025-01-30T04:09:32Z")
That would be a minimum of 500 updates, yes. Is speed an issue? A workflow loop adding 500 rows will be painfully slow. I would use the API for that. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [February 6, 2025, 4:10am UTC](https://community.glideapps.com/t/copy-a-query-result-in-app1-to-a-table-in-a-different-glide-app-app2/79654/7 "2025-02-06T04:10:12Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.