Pull data from API using Python

How to pull data from rest api and push it to sql server
JSON data to database using python
#python #data #dataanalytics #datavisualization #restapi #api #dataengineering #pipeline

[WadieGamer]

Thank you, you made the process very easy!

[aakashmittal]

How we can automate the process of data fetching from a live data API and data dumping without running the code again and again?

[abigailsarpong]

Did you already create the 'FactCrypto' table in MSSQL before connecting or you just gave a table name.
I am trying to write to SQL but I always get error.

[tejaswibhargava]

Hi, Do i need to create a DB structure in MSSQL first and then write code to fetch data? Or will it create the table automatic??

[VitaminProtein_official]

Hi, I have a key for api (trial version) of printfriendly website.. is this video meant for the purpose of "How to extract that api & use it forever for free" ?

[samhudaya]

In that suppose same data came again how it will load for example yesterday one row it's ram next day also we get same data how to it will load this Data this means duplicate data.

[Skd]

For all 3 imports, can you please help with the error :: Import 'requests' could not be resolved by Pylance???

[gnrfdlo]

I am trying to connect to Sql workbench but always get error, I dont know exact code for engine. Any help is appreciated.

[vamshiv]

Can you please provide website or resource where can we find such free APIs

[deepanshudas]

In which tool you are creating this phython code?

[Coolbitch_Su]

In every video there is a different way of fetching data
Its very confusing, which to remember