# Need Help:Is there way to use workflow to get JSON array as multiple rows? (JSON Query column id not allowed in workflow) **URL:** \ **Category:** Ask for Help\ **Tags:** api, json\ **Created:** [June 2, 2025, 4:11pm UTC](https://community.glideapps.com/t/need-help-is-there-way-to-use-workflow-to-get-json-array-as-multiple-rows-json-query-column-id-not-allowed-in-workflow/82205 "2025-06-02T16:11:09Z")\ **Posts on this page:** 16\ **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:** [June 2, 2025, 4:11pm UTC](https://community.glideapps.com/t/need-help-is-there-way-to-use-workflow-to-get-json-array-as-multiple-rows-json-query-column-id-not-allowed-in-workflow/82205/1 "2025-06-02T16:11:09Z")
Hi Guys, I call an API to fetch JSON on action named Fetch Data. I am storing this JSON in Table A. This JSON has 20 elements which I need to write into another Table B, Each elements needs to be written as seperate rows. I am using a helper table which is getting this JSON response in 20 rows and I am able to get Thumbnail and POST url in the helper table as seperate rows. My problem is , I want this data from Helper table to be written to Table B as seperate rows automatically if the data is not present. how can I do it? Problem with wrokflow is I wont be able to write JSON query column output as its experimental column which wont be allowed in workflow. is there any way I can do this automatically? Or is manual button with mutations only way to do it? Thank you in advance for your help. Regards, Dilip ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 3, 2025, 12:03am UTC](https://community.glideapps.com/t/need-help-is-there-way-to-use-workflow-to-get-json-array-as-multiple-rows-json-query-column-id-not-allowed-in-workflow/82205/2 "2025-06-03T00:03:15Z")
Why don’t you just pass the full JSON directly to the workflow and query it using JSONata there? ---
**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:** [June 3, 2025, 5:17am UTC](https://community.glideapps.com/t/need-help-is-there-way-to-use-workflow-to-get-json-array-as-multiple-rows-json-query-column-id-not-allowed-in-workflow/82205/3 "2025-06-03T05:17:53Z")
Hi @ThinhDinh , Thank you for replying. I have my response stored In table A, From there I am passing it to my helper table Using single value column. This single value column output is based on user column query. I dont think that’s allowed in Workflow right? How can I pass full JSON directly to workflow? Can you explain little if it’s ok? Thank you in advance for your help Regards, Dilip ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 3, 2025, 5:26am UTC](https://community.glideapps.com/t/need-help-is-there-way-to-use-workflow-to-get-json-array-as-multiple-rows-json-query-column-id-not-allowed-in-workflow/82205/4 "2025-06-03T05:26:44Z")
> [@Dilip\_Adiga](#): > > This single value column output is based on user column query. What type of query are you doing here? If you have a webhook workflow, when you do the trigger step for the webhook, just reference the JSON there. ---
**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:** [June 3, 2025, 5:56am UTC](https://community.glideapps.com/t/need-help-is-there-way-to-use-workflow-to-get-json-array-as-multiple-rows-json-query-column-id-not-allowed-in-workflow/82205/5 "2025-06-03T05:56:40Z")
Hi @ThinhDinh , Thank you for replying. > [@ThinhDinh](#): > > What type of query are you doing here? I am using JSON query. I want to break the JSON and put each elements into separate rows in Table B. > [@ThinhDinh](#): > > If you have a webhook workflow, when you do the trigger step for the webhook, just reference the JSON there. I do have web hook workflow. so I trigger Post request on click of a button to web hook and send JSON body. Regards, Dilip ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 3, 2025, 7:33am UTC](https://community.glideapps.com/t/need-help-is-there-way-to-use-workflow-to-get-json-array-as-multiple-rows-json-query-column-id-not-allowed-in-workflow/82205/6 "2025-06-03T07:33:28Z")
> [@Dilip\_Adiga](#): > > so I trigger Post request on click of a button to web hook and send JSON body. Yeah you can do this, and then loop through the JSON in the webhook workflow to add rows as needed. Is that what you want? ---
**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:** [June 3, 2025, 7:41am UTC](https://community.glideapps.com/t/need-help-is-there-way-to-use-workflow-to-get-json-array-as-multiple-rows-json-query-column-id-not-allowed-in-workflow/82205/7 "2025-06-03T07:41:31Z")
Hi @ThinhDinh , Yeah this is exactly what I need. I am able to configure the Webook and able to get the JSON response in the web hook. Here are my doubts: 1, I am not able to understand how can I get the JSON response from that trigger into query JSOn column I can only see these options in the trigger ![Screenshot 2025-06-03 at 1.09.35 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/4/742091db913bd093f5707821b8424f19d2f25240.png) how can I add rows by looping it in this workflow? I am getting JSON response in web hook shown in logs ![Screenshot 2025-06-03 at 1.14.57 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/4/84ebe6429baeca9c818ff2e8e32658bffd3c2609.png) Thank you in advance for your help. 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:** [June 3, 2025, 7:55am UTC](https://community.glideapps.com/t/need-help-is-there-way-to-use-workflow-to-get-json-array-as-multiple-rows-json-query-column-id-not-allowed-in-workflow/82205/8 "2025-06-03T07:55:27Z")
The JSON will be in the Request Body. ---
**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:** [June 3, 2025, 8:26am UTC](https://community.glideapps.com/t/need-help-is-there-way-to-use-workflow-to-get-json-array-as-multiple-rows-json-query-column-id-not-allowed-in-workflow/82205/9 "2025-06-03T08:26:11Z")
Hi @Darren_Murphy Thank you for responding please find my JSON response body structure. ```ray 0 {24} inputUrl : https://www.instagram.com/aurm_club id : 3638749116054615239 type : Video shortCode : DJ_bwrJM7TH caption : Smart living gets a high-tech upgrade!\nPrestige Group has partnered with Aurm to integrate AI-powered smart lockers across its residential projects - bringing seamless, secure, and contactless deliveries right to your doorstep.\n\nRead more: https://www.rprealtyplus.com/allied/prestige-group-partners-with-aurm-for-ai-powered-lockers-in-housing-projects-120079.html \n\n#PrestigeGroup #Aurm #SmartLockers #PropTech #SmartLiving #FutureOfHousing #AIInRealEstate #LuxuryLiving #TechEnabledHomes #RealEstateInnovation #NextGenLiving #SecureLiving hashtags [12] url : https://www.instagram.com/p/DJ_bwrJM7TH/ commentsCount : 0 firstComment : latestComments [0] (empty array) dimensionsHeight : 2880 dimensionsWidth : 2880 displayUrl : https://scontent-vie1-1.cdninstagram.com/v/t51.75761-15/500285573_18068796122053003_4772006725122928694_n.jpg?stp=dst-jpg_e35_s750x750_sh0.08_tt6&_nc_cat=108&ig_cache_key=MzYzODc0OTExNjA1NDYxNTIzOQ%3D%3D.3-ccb1-7&ccb=1-7&_nc_sid=58cdad&efg=eyJ2ZW5jb2RlX3RhZyI6InhwaWRzLjE0NDB4MTQ0MC5zZHIifQ%3D%3D&_nc_ohc=VtmlqPZQ7r0Q7kNvwE6_C9h&_nc_oc=AdnIxguU1ZBbnn0RBZQ7s3m2T37-g-gnXNasil1xWjeVwo6pZqG-2u5otzU8MSuFjDo&_nc_ad=z-m&_nc_cid=0&_nc_zt=23&_nc_ht=scontent-vie1-1.cdninstagram.com&_nc_gid=j5OcUVgdV8FYfi0XjuEJsg&oh=00_AfJhULIJm9WI7WJ_kq1SOFQ7poSeTYeADs5aBGVtHAQBoQ&oe=68436F53 images [0] (empty array) videoUrl : https://scontent-vie1-1.cdninstagram.com/o1/v/t2/f2/m86/AQOIjZSZJy9XL4f82swkf_xJsdC2ZhjHQejQdqF_ISEA2aKTr5c6UlBEtcgoIukzVg4aY1ZtOuk8uaROOnHtPdO5KZmL488icVhhpqs.mp4?_nc_cat=109&_nc_sid=5e9851&_nc_ht=scontent-vie1-1.cdninstagram.com&_nc_ohc=BItd5-UJG6oQ7kNvwGX_WfD&efg=eyJ2ZW5jb2RlX3RhZyI6Inhwdl9wcm9ncmVzc2l2ZS5JTlNUQUdSQU0uQ0xJUFMuQzMuNzIwLmRhc2hfYmFzZWxpbmVfMV92MSIsInhwdl9hc3NldF9pZCI6OTYxMjEwNTg5MjI0OTIzOCwidmlfdXNlY2FzZV9pZCI6MTAwOTksImR1cmF0aW9uX3MiOjMwLCJ1cmxnZW5fc291cmNlIjoid3d3In0%3D&ccb=17-1&vs=f67f2e88ef37656c&_nc_vs=HBksFQIYUmlnX3hwdl9yZWVsc19wZXJtYW5lbnRfc3JfcHJvZC8xMDRBMTc0NDY2RTAxRTdBMUZCQzQ1Nzc5NzczMkE4NF92aWRlb19kYXNoaW5pdC5tcDQVAALIARIAFQIYOnBhc3N0aHJvdWdoX2V2ZXJzdG9yZS9HTnJiMmgzdm5DaGZDbjBqQU54R01WbXM3UE1JYnFfRUFBQUYVAgLIARIAKAAYABsCiAd1c2Vfb2lsATEScHJvZ3Jlc3NpdmVfcmVjaXBlATEVAAAmrPqB1JmKkyIVAigCQzMsF0A-AAAAAAAAGBJkYXNoX2Jhc2VsaW5lXzFfdjERAHX-B2XmnQEA&_nc_zt=28&oh=00_AfLsayAL6FjnDEkFLAGkagqlW9Pw341bXtO1v8_La-fvZA&oe=683F8426 likesCount : 3 timestamp : 2025-05-23T09:32:30.000Z childPosts [0] (empty array) ownerFullName : Realty+ ownerUsername : rp_realty ownerId : 31486181002 productType : clips videoDuration : 30 isSponsored : true 1 {26} inputUrl : https://www.instagram.com/aurm_club id : 3637945423253639604 type : Video shortCode : DJ8lBZ5SpG0 caption : Getting ready for an event or shoot is always a hustle and in the chaos, we often forget to style the little details.\nBut not anymore! With my @aurm_club private vault, I have an all time access to my jewels. Zero drama, just glam. ✨\n\nComment ‘Aurm’ below to know more\n\n#AurmClub #UnlockWithAURM hashtags [2] 0 : AurmClub 1 : UnlockWithAURM mentions [1] 0 : aurm_club url : https://www.instagram.com/p/DJ8lBZ5SpG0/ commentsCount : 106 firstComment : latestComments [0] (empty array) dimensionsHeight : 1920 dimensionsWidth : 1080 displayUrl : https://scontent-vie1-1.cdninstagram.com/v/t51.75761-15/500172275_18502442635021729_6180615598735542618_n.jpg?stp=dst-jpg_e35_p750x750_sh0.08_tt6&_nc_cat=100&ig_cache_key=MzYzNzk0NTQyMzI1MzYzOTYwNDE4NTAyNDQyNjI5MDIxNzI5.3-ccb1-7&ccb=1-7&_nc_sid=58cdad&efg=eyJ2ZW5jb2RlX3RhZyI6InhwaWRzLjE1OTh4Mjg0NS5zZHIifQ%3D%3D&_nc_ohc=MfeCDbBmFx8Q7kNvwHUxlEj&_nc_oc=AdlBM59lVyE4W6zv7alK9oHaRrkvyjLPV0nVRJ2wXCy3v8AqcuTz5DzsjH7E-5ElXEE&_nc_ad=z-m&_nc_cid=0&_nc_zt=23&_nc_ht=scontent-vie1-1.cdninstagram.com&_nc_gid=j5OcUVgdV8FYfi0XjuEJsg&oh=00_AfLSsPyW5SM6W6SIS0_TSXM80uxzMm_J05nNSHrjWF_pHg&oe=68437268 images [0] (empty array) videoUrl : https://scontent-vie1-1.cdninstagram.com/o1/v/t2/f2/m86/AQMpr7Xh5n3gf68RybFeLHwgn2gDxKibeHtDOehI61K8WFkbXz8z9h8Xm2146flCoL_dS0ZcKKOPtG6qwTcyHdQkPfUspHJvy0kmGjo.mp4?_nc_cat=106&_nc_sid=5e9851&_nc_ht=scontent-vie1-1.cdninstagram.com&_nc_ohc=LgFgJXdkqooQ7kNvwG5lPvu&efg=eyJ2ZW5jb2RlX3RhZyI6Inhwdl9wcm9ncmVzc2l2ZS5JTlNUQUdSQU0uQ0xJUFMuQzMuNzIwLmRhc2hfYmFzZWxpbmVfMV92MSIsInhwdl9hc3NldF9pZCI6MTQxMTkzNTU3MDAwNDc2MiwidmlfdXNlY2FzZV9pZCI6MTAwOTksImR1cmF0aW9uX3MiOjQ4LCJ1cmxnZW5fc291cmNlIjoid3d3In0%3D&ccb=17-1&vs=a780c974b722285&_nc_vs=HBksFQIYUmlnX3hwdl9yZWVsc19wZXJtYW5lbnRfc3JfcHJvZC84QjQ3NjNBQ0QzNzM4MkE4MEM4NkY3RTQ4NUNCOTE4N192aWRlb19kYXNoaW5pdC5tcDQVAALIARIAFQIYOnBhc3N0aHJvdWdoX2V2ZXJzdG9yZS9HTlB3eWgwNDlYM0FVVzhHQU5VRjJrQmFFamNoYnFfRUFBQUYVAgLIARIAKAAYABsCiAd1c2Vfb2lsATEScHJvZ3Jlc3NpdmVfcmVjaXBlATEVAAAmtKzE4buJggUVAigCQzMsF0BIAAAAAAAAGBJkYXNoX2Jhc2VsaW5lXzFfdjERAHX-B2XmnQEA&_nc_zt=28&oh=00_AfITEvhPMZuBlF7nu15dhWqc87uviEut4DrOkcKDUAi7AQ&oe=683F84C7 likesCount : 20496 timestamp : 2025-05-22T06:56:09.000Z childPosts [0] (empty array) ownerFullName : Sonia Kashyap ownerUsername : soniakashyap_ ownerId : 1790933728 productType : clips videoDuration : 48 isSponsored : true coauthorProducers [1] 0 {7} full_name : Aurm: Bank Lockers Reimagined id : 70267958397 is_private : false is_verified : false profile_pic_id : 3505305649829265777 profile_pic_url : https://scontent-vie1-1.cdninstagram.com/v/t51.2885-19/467849303_1695021084404367_8473768686473400772_n.jpg?stp=dst-jpg_e0_s150x150_tt6&_nc_ht=scontent-vie1-1.cdninstagram.com&_nc_cat=103&_nc_oc=Q6cZ2QFFByUfzB2IWixqwTgQbUnlKcY37ZWM4-a9sPXwwGA6NEY40Uhi_EcILuU6ngBng1Y&_nc_ohc=DLFN1hxMTr8Q7kNvwGoD0jE&_nc_gid=j5OcUVgdV8FYfi0XjuEJsg&edm=APGXKFABAAAA&ccb=7-5&ig_cache_key=GFfQ4huPap-ZnAUGAMRRE3K535h1bkULAAAB-ccb7-5&oh=00_AfKub_mhhj-3n8s3ulBUMDb7qd3ZGqHqkTqLmKPOBVo-aw&oe=68436951&_nc_sid=a8b8e2 username : aurm_club ``` I tried doing it with workflow like this ![Screenshot 2025-06-03 at 3.05.17 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/9/b9330d81a42fa6e3d9e94cbb28a46afdf2f45983.png) It is just writing the Post url to new table. how can I do the same to get thumbnail url, Caption and user name in the same way? If I loop the Query JSON output I can only add new row which is not what I want. how can I resolve this? Thank you in advance for your 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:** [June 3, 2025, 9:04am UTC](https://community.glideapps.com/t/need-help-is-there-way-to-use-workflow-to-get-json-array-as-multiple-rows-json-query-column-id-not-allowed-in-workflow/82205/10 "2025-06-03T09:04:38Z")
Hi Guys, Also under my results I dont see and options , Its supposed to have transform JSON option right. ![Screenshot 2025-06-03 at 2.33.54 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/8/e8e1c869e885bfde40e59999dc29cd860d90772e.png) Regards, Dilip ---
**Author:** ![Maazsaeed](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maazsaeed/32/90243_2.png) [@Maazsaeed](https://community.glideapps.com/u/Maazsaeed)\ **Post date:** [June 3, 2025, 9:59am UTC](https://community.glideapps.com/t/need-help-is-there-way-to-use-workflow-to-get-json-array-as-multiple-rows-json-query-column-id-not-allowed-in-workflow/82205/11 "2025-06-03T09:59:47Z")
You can see this, darren helped me with this. I was trying to do something similar as well but using webhooks instead of API the other process is quite same > [@How to parse CSV into a collection](https://community.glideapps.com/t/how-to-parse-csv-into-a-collection/82198/20): > > Woah! That’s some awesome logic I could have never thought of this. Hands off to you man – Hope you will be successful in your life. I am really grateful to you for helping me ---
**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:** [June 3, 2025, 10:14am UTC](https://community.glideapps.com/t/need-help-is-there-way-to-use-workflow-to-get-json-array-as-multiple-rows-json-query-column-id-not-allowed-in-workflow/82205/12 "2025-06-03T10:14:01Z")
Hi @Maazsaeed , thank you for replying. This is using helper table. I was wondering if we could do it without using helper table as suggested by @ThinhDinh Regards, Dilip ---
**Author:** ![Maazsaeed](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maazsaeed/32/90243_2.png) [@Maazsaeed](https://community.glideapps.com/u/Maazsaeed)\ **Post date:** [June 3, 2025, 12:45pm UTC](https://community.glideapps.com/t/need-help-is-there-way-to-use-workflow-to-get-json-array-as-multiple-rows-json-query-column-id-not-allowed-in-workflow/82205/13 "2025-06-03T12:45:21Z")
Why are you not leveraging the helper tables, they are quite good now with Big Glide Tables that’s even more awesome ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 3, 2025, 11:49pm UTC](https://community.glideapps.com/t/need-help-is-there-way-to-use-workflow-to-get-json-array-as-multiple-rows-json-query-column-id-not-allowed-in-workflow/82205/14 "2025-06-03T23:49:07Z")
Can you paste your JSON again here? What you have in the comment is invalid JSON. When you have queried the JSON from the body that you sent to your webhook, you should be able to loop through the items of that JSON, assuming it’s a JSON array. Then, in each loop, you query out the fields you need, and add it to a new row. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 3, 2025, 11:55pm UTC](https://community.glideapps.com/t/need-help-is-there-way-to-use-workflow-to-get-json-array-as-multiple-rows-json-query-column-id-not-allowed-in-workflow/82205/15 "2025-06-03T23:55:46Z")
> [@Maazsaeed](#): > > Why are you not leveraging the helper tables, they are quite good now with Big Glide Tables that’s even more awesome If the helper table bases on something that relates to the signed-in user, you can’t really leverage it I think. The reason is workflows run server-side and can’t “imitate” the signed-in user. There can be workarounds, but I want something straightforward here for OP. ---
**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:** [June 4, 2025, 4:04am UTC](https://community.glideapps.com/t/need-help-is-there-way-to-use-workflow-to-get-json-array-as-multiple-rows-json-query-column-id-not-allowed-in-workflow/82205/16 "2025-06-04T04:04:11Z")
Hi @ThinhDinh , Thank you for your reply. I was advised my @Eric_Penn a small change, I realised my body was converted to string which I had to make a proper JSON before I could move ahead with sending it for processing. Now it’s working well. Thank you for your help. @Maazsaeed , Yes @ThinhDinh is right. I helper table I would have to get JSON using user columns or other means which is not allowed in workflow. There is other workaround of using whole row → single value combination, But that becomes like an extra step, SO his suggestion of doing it using query looked simpler. Regards, Dilip