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

**URL:** <https://discourse.nodered.org/t/get-data-from-a-paginated-api-and-load-it-into-sql-table/94469>\
**Category:** General\
**Tags:** http-request\
**Created:** [9 January 2025 06:57 UTC](https://discourse.nodered.org/t/get-data-from-a-paginated-api-and-load-it-into-sql-table/94469 "2025-01-09T06:57:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mabona745](https://avatars.discourse-cdn.com/v4/letter/m/94ad74/32.png) [@Mabona745](https://discourse.nodered.org/u/Mabona745)\
**Post date:** [9 January 2025 06:57 UTC](https://discourse.nodered.org/t/get-data-from-a-paginated-api-and-load-it-into-sql-table/94469/1 "2025-01-09T06:57:00Z")

</div>

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](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/5/1/51144a1e9c2695475edf4ec92797bd0beb168565.png)

i'm always getting the error

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/3/6/361fd9f7145907aae1330c6f7df7a3ef27b1ed04.png)

---

<div class="post-metadata">

**Author:** ![jbudd](https://avatars.discourse-cdn.com/v4/letter/j/5f8ce5/32.png) [@jbudd](https://discourse.nodered.org/u/jbudd)\
**Post date:** [9 January 2025 09:02 UTC](https://discourse.nodered.org/t/get-data-from-a-paginated-api-and-load-it-into-sql-table/94469/2 "2025-01-09T09:02:30Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![E1cid](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/e1cid/32/77971_2.png) [@E1cid](https://discourse.nodered.org/u/E1cid)\
**Post date:** [9 January 2025 10:49 UTC](https://discourse.nodered.org/t/get-data-from-a-paginated-api-and-load-it-into-sql-table/94469/3 "2025-01-09T10:49:53Z")

</div>

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