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
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.
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.
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" ?
Did you find a way? Im kinda of a noob and i need my code to run daily without fail in order for it to retrieve data from rest api’s and load it to our local database. I tried uploading my code to an app function in azure but since it has a dynamic ip address I haven’t been able to make it work (permission errors). Theres always task scheduler on a local computer but i can’t always trust it’ll be on. Any ideas?
![ลักพาตัว เอาลูกเอิร์นกลับมา...!! [เอิร์นไดเม่]](http://i.ytimg.com/vi/f4NVKlZ5qkk/mqdefault.jpg)
![The Wall Song ร้องข้ามกำแพง | EP.202 | ตั้ม วราวุธ / เบสท์ คำสิงห์ | 18 ก.ค. 67 [1/5]](http://i.ytimg.com/vi/cwIoA7XHqnE/mqdefault.jpg)
Super helpful video. Thanks mahn🤗
Thanks Prince, Glad you liked it ☺
Very helpful! Thank you.
Thanks Nikhil!
Thank you, you made the process very easy!
Glad it helped
Very helpful 👍
Thanks Charan !
very useful :) thank you
Thanks Narasimha
I am trying to connect to Sql workbench but always get error, I dont know exact code for engine. Any help is appreciated.
For all 3 imports, can you please help with the error :: Import 'requests' could not be resolved by Pylance???
Excellent man
Thanks Madhusudan!
Can you please provide website or resource where can we find such free APIs
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.
Just gave a table name
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??
Hi Tejaswi, just create database , table will be created automatically with the name you provide
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.
Hi Samhudaya, In 'if_exists' parameter use 'append' as value so that it'll load only new rows to the table.
In which tool you are creating this phython code?
PyCharm
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" ?
Hi, yes boss
How we can automate the process of data fetching from a live data API and data dumping without running the code again and again?
Hi Aakash, use any job scheduler like Apache airflow, SQL server agent,...
Did you find a way? Im kinda of a noob and i need my code to run daily without fail in order for it to retrieve data from rest api’s and load it to our local database. I tried uploading my code to an app function in azure but since it has a dynamic ip address I haven’t been able to make it work (permission errors). Theres always task scheduler on a local computer but i can’t always trust it’ll be on. Any ideas?
Can you please share API link
api.coincap.io/v2/assets
sql not connect
SQL Server is connected
@@thebihub engine.connect show error
In every video there is a different way of fetching data
Its very confusing, which to remember
Hi Suman , may I know which part is confused for you so that I can clear it