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…

jbudd 9 January 2025 09:02 2

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

Topic		Replies	Views
Execute SQL Query from an array object General node-red-contrib-mssql-plus	4	39	9 January 2025
Sending JSON data to a table General	9	428	3 January 2023
Show data on ui-table coming from SQL database General	7	2638	8 May 2022
How to get value from Payload array and send by SQL? General	0	406	18 December 2019
Node jsonSQL Issues General	8	487	15 September 2020

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

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

Related topics