Forum Academy Marketplace Showcase Pricing Features

How do I parse returned json individually to a database array of new things? (Tried repeating group too)

I have this info from this call to twitch.
So I created a repeating group that displays that name and ID (yay)
but I can’t for the life of me figure out how to parse this into a database.
I tried grabbing the api call making the new thing, but it puts all the games together separated by comma.

So I figured, well, I’ll just tell it to create a new thing on page load, every time a new repeating group field is udpated! Viola! And of course, you CANT make an action that doesn’t start with a click on the repeating group? Well that’s dumb.

So I’m stuck. How so I get it to not look like this and have one entry per field:

Fortnite, League of Legends, Just Chatting, Grand Theft Auto V, Apex Legends, Counter-Strike: Global Offensive, World of Warcraft, Destiny 2, etc

https://api.twitch.tv/helix/games/top?first=10

{
“data”: [
{
“id”: “33214”,
“name”: “Fortnite”,
“box_art_url”: “https://static-cdn.jtvnw.net/ttv-boxart/Fortnite-{width}x{height}.jpg
},
{
“id”: “21779”,
“name”: “League of Legends”,
“box_art_url”: “https://static-cdn.jtvnw.net/ttv-boxart/League%20of%20Legends-{width}x{height}.jpg
},
{
“id”: “509658”,
“name”: “Just Chatting”,
“box_art_url”: “https://static-cdn.jtvnw.net/ttv-boxart/Just%20Chatting-{width}x{height}.jpg
},
{
“id”: “32982”,
“name”: “Grand Theft Auto V”,
“box_art_url”: “https://static-cdn.jtvnw.net/ttv-boxart/Grand%20Theft%20Auto%20V-{width}x{height}.jpg
},
{
“id”: “511224”,
“name”: “Apex Legends”,
“box_art_url”: “https://static-cdn.jtvnw.net/ttv-boxart/Apex%20Legends-{width}x{height}.jpg
},
{
“id”: “32399”,
“name”: “Counter-Strike: Global Offensive”,
“box_art_url”: “https://static-cdn.jtvnw.net/ttv-boxart/./Counter-Strike:%20Global%20Offensive-{width}x{height}.jpg
},
{
“id”: “18122”,
“name”: “World of Warcraft”,
“box_art_url”: “https://static-cdn.jtvnw.net/ttv-boxart/World%20of%20Warcraft-{width}x{height}.jpg
},
{
“id”: “138585”,
“name”: “Hearthstone”,
“box_art_url”: “https://static-cdn.jtvnw.net/ttv-boxart/Hearthstone-{width}x{height}.jpg
},
{
“id”: “497057”,
“name”: “Destiny 2”,
“box_art_url”: “https://static-cdn.jtvnw.net/ttv-boxart/Destiny%202-{width}x{height}.jpg
},
{
“id”: “29595”,
“name”: “Dota 2”,
“box_art_url”: “https://static-cdn.jtvnw.net/ttv-boxart/Dota%202-{width}x{height}.jpg
}
],
“pagination”: {
“cursor”: “eyJiIjpudWxsLCJhIjp7Ik9mZnNldCI6MTB9fQ”
}
}

You need to use an API workflow for this which is only available in paid plans starting from Personal.

This API workflow should trigger for each item (object) in the JSON response array. Within each trigger you define a “create thing” or “make changes to a list” event based and map the key:value pairs with your destination model.

Ugh. Is there any no-code app that would allow me to parse the data without spending 25 bucks? I could have this little thing built for 50 on fivver, or spend a weekend and learn the rest myself. But I would prefer to just use something like this for the time being.

Did you succeded to activate twitch tv on 1st attempt? I can’t do twitch.tv/activate. Can anyone tell me what should I do?

this may help

what if I can’t save data in my database because it’s sensitive data?