Insert API data into The Database

Wappler General Need Help
1

Hey there,
I am trying to get data from API enpoint
and insert it to Database maybe with a sync button :thinking: does anyone how to achieve that?
I got API connection and Database connection set up already.
Just not sure how to post data from API to database :weary: it should be either scheduled or by using sync button

Thanks for help!

2

Hi @Creative_Studio_UK
Use the repeat step in server action, and repeat your API results (i.e. select your API data element as an expression for the repeat). This will loop through the API results.
Inside the repeat step add the database insert step and select which field to be insert in which db column.

You can call this server action on click of a button on your page.