Nodejs Reading API and Inserting data into SQL Server

preview_player
Показать описание
This video is a hands on demonstration as to how we can read data from an API and then process it and save it in the SQL Server or any database. We will see the following in action:
a. How we can read the data from an API?
b. Use Knex to insert the data into SQL Server!

The following is the link to my video on detailed explanation on reading API through AXIOS call:

#nodejs #node #sqlserver #sql #axios #promise #readingapi
Рекомендации по теме
Комментарии
Автор

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.

JaredAkers
Автор

TypeError: .data.map is not a function

kaismhamdi
Автор

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
at C:\ABC\Node JS
at {
code: 'ESOCKET',
isTransient: undefined

AliKhan-oksb