Nodejs Reading API and Inserting data into SQL Server

[@JaredAkers]

thank you so much, been looking for exactly this for weeks! Although I may be using postgres, planetscale or mongodb. Although after watching this I may just try mysql.
Working on a project to fetch sales data (json) from an external api every 5 minutes (for 30 different api calls, with different bearer tokens for 30 separate retail units) and insert into a db.

[@kaismhamdi3544]

TypeError: .data.map is not a function

[@dhandrohit]

If you are getting the data.map is not a function it means that stuff is not in the form of array or undefined. Check the response on which you are applying the data.map function.

[@Swerve-s2d]

hi

[@AliKhan-ok5sb]

Do you know what this error means?
An error occurred: ConnectionError: Failed to connect to LocalSQLEXPRESS:1433 - getaddrinfo ENOTFOUND LocalSQLEXPRESS
at Connection.socketError (C:\ABC\Node JS Project
ode_modules\tedious\lib\connection.js:1395:28)
at C:\ABC\Node JS Project
ode_modules\tedious\lib\connection.js:1176:14
at process.processTicksAndRejections (node:internal/process/task_queues:77:11) {
code: 'ESOCKET',
isTransient: undefined

[@dhandrohit]

This issue looks like that you are unable to connect to SQLServer Express. Check whether you are giving the right IP Address?

[@AliKhan-ok5sb]

@@dhandrohit You are correct, It was unable to connect SQL Server, I replace LocalSQLExpress with Localhost.