API Request - Loop through - Insert into mySQL

💬 Workflows
1

I am trying to insert the result of an API request with to values per object to mySQL.

i do receive result from API request with keys id, name
image

now i would like to insert those 5 rows into my sql.
tried like in screen. but i do not find a way how to write one record after another?

image
image902×507 35.3 KB

thanks for your support!

2

Hi @DaKine,

If you change the query2 block to GUI mode, you should have a bulk insert option. You can insert and object, which you can point to the array of data from loopResult.data (assuming that's what the result in your screenshot above is from).

1 Like
3

thank you so much... it worked!

1 Like