Get data from a Paginated Api and load it into SQL table

General
1

Hi Everyone
I'm new on Node-red, i just anyone to help me with the following problem. We want to get data from a paginated servicely Api, i can get all the data then extract all the columns i need, but the problem start when i have to load the data in sql table. can anyone show me the easier way of getting this done. below is what i have done so far

image
image1392×262 21.6 KB

i'm always getting the error

image
image560×145 3.15 KB

2

This is very similar to https://discourse.nodered.org/t/execute-sql-query-from-an-array-object/94446.
You might find answers there.

3

Please do not double post, you are getting help on this topic in your previous topic.