I need some help about Api Call + Database

Hello there;

I miss something about calling the API or saving it to the database. I watched videos of etsy listing, api call and similar help, I read the forum but I could not find a solution. (my english is a little weak, I’m sorry for that, I’m trying to improve)

I get the data in xml and save them in the database, but how do they match each other? When you click on the get button in the video, the id, description, and title come separately but relate. But when I save the data, it records all id’s in one field, all product names in one field, all categories in one field and per product. In short, he repeats the same thing over and over again.

How can I find a solution?






I hope that I have been able to tell you … Thank you very much already.

I have the same issue. I think some how we need to use index# with an incremental count so it puts the API data into separate rows in the database not all in the same row. If I figure it out I will let you know

Simon

if your API contains an array and you wish to save item as a separate record then take a peak at https://buildingonbubble.com/block/save-an-apis-results-1472017471956x981892223072469000 kindly provided by @NigelG

2 Likes

Perfect sorted - thanks Bubbleboy I figured out what I was doing wrong. I needed to take the input from the array it creates rather than the repeating group.

Thanks everyone

1 Like