Create list of things from JSON

Hi guys I have a json which looks like this
{
“name”: “Json name”,
“url”: “example.com”,
“date_last_ran_timestamp”: 1615203090435,
“data”: [
{
“img”: “example.com/image.jpg”,
“index”: 1,
“price”: “700 €”,
“height”: “55cm”,
“title”: “Title 1”,
“type”: “Type 1”,
},
{
“img”: “example.com/anotherimage.jpg”,
“index”: 2,
“price”: “2 899 €”,
“height”: “10cm”,
“title”: “Title 2”,
“type”: “Type 1”,
}
]
}
And I don’t know how to import the data array into bubble database without importing everything into one case like this
image
To achieve the image above i tried importing like this
image
But somehow the “until #” doesn’t behave like i thought, i know i can use “item #” but i don’t want to do it 20 times and for other json too
If you have any idea on how to do this i’ll gladly try them !

Is that how your data comes in via an API connection?

If so as you set up and initialise the API call, in the pop up window it will identify that DATA is a list, and you’ll be able to then use it as such in create a list of things or an api workflow on a list

1 Like