Save single json objects as thing into Bubble

Need help Database
1

Hello Guys,
do you know some method to saving records into database, as Things, by and API call that return JSON?

My request return something like this:
[
{
“winery”: “Maselva”,
“wine”: “Emporda 2012”,
“rating”: {
“average”: “4.9”,
“reviews”: “88 ratings”
},
“location”: “Spain\n·\nEmpordà”,
“image”: “https://images.vivino.com/thumbs/ApnIiXjcT5Kc33OHgNb9dA_375x500.jpg”,
“id”: 1
},
{
“winery”: “Ernesto Ruffo”,
“wine”: “Amarone della Valpolicella Riserva N.V.”,
“rating”: {
“average”: “4.9”,
“reviews”: “75 ratings”
},
“location”: “Italy\n·\nAmarone della Valpolicella”,
“image”: “https://images.vivino.com/thumbs/nC9V6L2mQQSq0s-wZLcaxw_pb_x300.png”,
“id”: 2
}
]

I would like to save in single things for example wine and location field with a single call.

Is it possible?

Thanks

2

When you set the API Call in API Connector to DATA and not ACTION, this API Call will be available as a DATA type. So you can create an item with a field set to this Data type like if this was a Bubble DB. You will be able to store all informations from this call into a single field.

2 Likes
3

Thanks. But I don’t want to store in a single field. I would like store each json field into bubble db but in different records

4

In this case you need to use Backend WF and schedule on a list

5

Have you some resource per detailed tutorial for understand better? Please…

Thanks

6

Not really but there’s a lot of topics about creating Bubble DB thing from an API List.

7

Do you really need to save it? Couldn’t you call the api each time and simply save a reference instead? That might make it easier?

1 Like
8

No, I need create a sync then I want to save data in DB.

9

It’s so strange for me belive that is not possible doing a loop for saving a series of object into the database. Maybe, you know some plugins or method?

10

You can complete recursion like this both client side and server. You’ll loop through your list and save the current item to the dB each loop moving from item 1 thru to the end.

Learn more

Need to have your database located in your region! Tired of struggling with Bubble or API’s? Need a little functionality that’s not available yet thru current market plugins?

Are you ready to step-it-up or speed it along? Need some custom code or a plugin built? Contact me today to learn how to book a 1-on-1 session, get your plugin built, or yet freelance building support!

Reach me via email:
Jared@CodelessConsultant.com

11

Yes, your analysis is right. But I don’t understand how do it on Bubble.

12

Any idea? :slight_smile:

13

@gabriele.pecchioli did you ever find a solution for this?