I’m hoping to get the latest and greatest solution to a common challenge: Turning a JSON array into rows in a separate table. Here’s one of the simplest looking solutions I found. Wondering if there are any others? I want to get a list of services for a client from a data source and then add the…

A not-very-cost-effective way imo is sending them to a webhook workflow, loop through the JSON, parse each field out using query JSON and finally add a row. A better way but more complex is using either JSONata or JavaScript to turn your JSON into something that fits with the Glide API, and then se…

So: Get JSON and store in column Transform JSON (into ?? format) Use Glide API to add each record in the array to rows in a glide table I specify If that is correct, are you able to elaborate on steps 2, 3 please?

If your JSON is already valid, step 2 would require JSONata or JavaScript (I usually do JavaScript) to turn each element in your JSON array to a format that’s fitting for adding a row in Glide. Sample mutation in Glide: { "kind": "add-row-to-table", "tableName": "your table's name here…

Getting around to this! Where am I adding this code? In Glide?

The stuff above is just a sample of how your output would look like. You have to construct a JavaScript function to produce the JSON string that looks like this: { "appID": "appID here", "mutations": [ { "kind": "add-row-to-table", "tableName": "your table's name here", "c…

K. I do that in a JavaScript column in same sheet as my original JSON right?

Yes that’s correct. Let me know if I can help you with any other stuff here. Make sure you use a return function at the end to get the output as a JSON string.

Workflow and production Glide API will costs the same: each row - one update. Use api V2 instead. 1.add rows to stash. 2. Add rows to table from stash. This way you will have economy

Isn’t workflow consuming more because you need to query out the fields, or does it work differently when you pass in a JSON (i.e it automatically paráes the fields out)? For API v2, isn’t it only for Glide Big Tables at the moment?

Does query consumes updates? I remember no, so why workflow must consuming more? Yes, API V2 is for BIG Tables only, for now. ”Costs the same” in my mind is updates costs only. Yes, for Glide Tables, crafting an API body is the best option if API Call is available.

Turn JSON array into rows in separate table

Ask for Help

Darren_Murphy August 10, 2025, 7:51am 13

Correct.

Topic		Replies	Views
Items in Array to separate row in another table Ask for Help	17	223	March 17, 2025
Add rows in a table based on json coming from a api call Ask for Help	8	1196	November 4, 2023
Is it possible to split Individual elements of JSON query into separate rows in different table? Ask for Help	3	165	March 18, 2025
Parse JSON from API Call (without JavaScript) Ask for Help	5	122	January 17, 2025
Using Call API and Glide API to add rows to related tables. Also...JSON Object! Project Showcase tutorial	14	1064	September 5, 2024

Turn JSON array into rows in separate table

Related topics