How to Extract and Map JSON Data to Multiple Columns in Glide?

Ask for Help
1

I have a JSON text generated by AI, which summarizes voice data into specific topics and calculates the time spent by each speaker as well as the total time for each topic. The JSON structure looks like this:

{
“topics”: {
“topic_1”: {
“Summary”: “Summary text for topic 1”,
“speaker_01”: “00:01:00”,
“speaker_02”: “00:01:06”,
“total_time”: “00:02:06”
},
“topic_2”: {
“Summary”: “Summary text for topic 2”,
“speaker_01”: “00:01:00”,
“speaker_02”: “00:01:51”,
“total_time”: “00:02:51”
}
}
}

My goal is to extract this data and display it in separate columns within a Glide Table like this:

  • topic1_summary
  • topic1_time_speaker1
  • topic1_time_speaker2
  • topic1_time_total
  • topic2_summary
  • topic2_time_speaker1
  • topic2_time_speaker2
  • topic2_time_total

What’s the best way to achieve this in Glide? I’m currently struggling with parsing the JSON and mapping these specific values to individual columns. Is there a built-in feature, a combination of computed columns, or perhaps a plugin that could help with this?

Any advice or guidance would be greatly appreciated! Thank you in advance!

2

Use the Query JSON column. For your use case, it’s basically no more than point and click :slight_smile:

1 Like
3

@Darren_Murphy It worked! Thank you for your quick response!

1 Like
4

If you don’t mind, can you tell me how you generated a structure like that? Is that through a specific third-party service or just prompting? Thank you.

5

@ThinhDinh It’s generated through just prompting.

1 Like
6

That’s awesome. Thank you. I was wondering how you can get exact timestamps for each one.

7

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.