API results display in DataBase issue

olivier.bardat · 2024-07-17T17:15:16.967Z

Hello everyone,

I have set up an API call in order to collect some job offers. I have a limit of 5 results in my API call. The API call works and I have linked it with my database. The issue I have is that my results all go in one row instead of being separated. See below how it looks like.

image2959×705 187 KB

Do you know how my results can be saved in 5 rows instead of only one?

Thanks a lot in advance for your help.

joshsutheran · 2024-07-17T17:19:09.133Z

Could you screenshot the workflow actions that are saving the data to your database? Would also be good to see the response from the API when you initialized.

Baloshi69 · 2024-07-17T18:28:51.317Z

Without an screen shot we cant help, but what i think at this stage is.

the API result return a list, and you can just saving the list.

what i suggest:

Make the api call as data. and then create API workflow, which take that data as input.

then when you call the api on next step call the API workflow on list, and pass the api call. on it.

and choose this api call as input.

inside the workflow create the job.

olivier.bardat · 2024-07-17T22:26:13.175Z

Sure, please find below the requested screenshots:

The result of my API call

image1477×1632 142 KB

The raw data result of my API call:

image1375×925 101 KB

My workflow based of the API above:

image1818×1111 166 KB

Thanks a lot in advance for your help

olivier.bardat · 2024-07-18T17:09:22.931Z

Sure, please find below the requested screenshots:

The result of my API call

image1477×1632 142 KB

The raw data result of my API call:

image1375×925 101 KB

My workflow based of the API above:

image1818×1111 166 KB

Thanks a lot in advance for your help

@Baloshi69

Jici · 2024-07-18T17:44:16.563Z

You don’t seem to schedule workflow on a list?

Baloshi69 · 2024-07-19T07:45:59.469Z

You are doing it on front end right, i advice you create a backend api work who’s job is to create a new JOB. withall the parameter which each single job can have.

then on the place of step 02, call it with Schedule API workflow on a list like below:

image681×592 14.2 KB

and inside it:

image734×664 17.5 KB

choose the type of thing this is the step 01 result form you api result, its seems its API Remotive Job
Choose the list which is step 01 result.
choose the workflow which you just created
and below it you find all the parameter which this API workflow required , which you just setup while creating the API workflwo. fill all thos. i.e This Api remotive job name , **This API remotive job salary ** … somethign like these
the schedule it current date.
and also give 2s delay.

that set, it will iterate on all the job form step01 call and create them one by one.

@olivier.bardat sorry for late reply, if you still cant do it message me we will do it together. i am very poor at explaining that’s why i like helping ppl by doing together.