Save an API Json

Need help Database
1

I’m making a GET call (API Connector) to an external API and getting the following json as a response:
[{
“id”: 1633211087,
“photo”: “https://ksr-
“url”: “url”,
“title”: “TGIF! Friday the Squaredy Cat”,
“description”: “"Friday"is a horror parody plush to add to your collection”,
“link”: “link”,
},
{
“id”: 2142160686,
“url”: url”,
“title”: “The Big Break: A Theatrical Competition Show.”,
“description”: “Theater competition show allowing aspiring actors and talented writers to work with well know SAG professionals.”,
“link”: “link”
}]
will save that result to the Data Base. But here is how it looks like…

Captura de pantalla_2020-09-04_17-34-44
Captura de pantalla_2020-09-04_17-34-44934×265 28.4 KB

Instead having each item of the list a separate row I’m actually getting all the results in the same row.

Any ideas?

2

You probably don’t use Schedule workflow on a List.
Can you provide your workflow settings too?

3

thanks for reply. I alredy solved it

1 Like
4

@onilmaruri how did you solve this issue? I have a similar issue.

5

Why do we have to do an an action then schedule the workflow

image
image1001×516 25.2 KB

I would suggest a new Backend Workflow - Do Work

image
image1135×304 15.5 KB

That way there is no need for YAP (yet another plugin) to do something simple like Iterate on a list and store in database

Okay gripe done. Happy Bubbling.

6

Hi, @onilmaruri how did you solve it? Can you share a solution? I’ll be very thankful! :pray: