Connect Microsoft SQL Server 2014 to API
$25-50 AUD / hour
I would like to connect my Microsoft SQL Server to a RESTful API.
It is a SQL Server 2014 and needs to call this RESTful API every 5 minutes and to store the data in the SQL server (purely appending to a table)
I have several APIs I would like to pull date from, but I would like to start with this one:
[login to view URL]
OUTPUT: I can setup the database (tables, fields etc.), but I need a solution to call the API every 5 minutes using a stored procedure (?). Open to the best solution here. The SQL server sits behind a firewall and getting out is no problem.
Project ID: #14743465
About the project
37 freelancers are bidding on average $36/hour for this job
Hi, I am Nallakumar. I have more than 11 years of experience in MS SQL Server development and administration. Technically the best solution for this is SSIS package. But, we can still go for Stored Procedure and More
Hi, The best solution will be to create a C# windows service that will periodically call this API and import data in SQL Server database. The schedule will be defined in application config and error log will be crea More
Let's create a windows service which have frequency of running every 5 minutes. It will connect to Rest Service and pull out data and append it to DB table. The service can be hosted on same machine as sql server sits More
Hello Sir, I am an expert in SQL server and API and would like to work on this project. Please open chat to discuss more about this project and my approach. Thanks Aanvik
I am 9+ Years of Experienced Software Developer,confident about to complete the project. ASP .Net , C# , VB .Net , Visual Basic, Excel VBA , MS SQL Server , MYSQL , Oracle , MS Access, Crystal Report, Telerik , Boo More
HI you can create a c# console app or windows service that call SP ever 5 mins and also call api in same interval.. Please come online and I'm ready to do this task for you THanks
You could easily call any executable file through xp_cmdshell but as I understand your main problem to store info from JSON responses to DB. I could create such app for you.
Hi Greetings of the Day, I am interested in this task, I am full time freelancer carrying 13 yrs of experience in Mobile development, Web and Windows development using ASP.Net, C#, SQL server, Xamarin, WebAPI, XML, More
talk to me via chat if you habe questions, what i want to know is what doesbthe API returns? xml or json, the best way to have this done is to create a service and install it on a server, preferrably on your database s More
Hello, I would like to take this assignment. I am having 12 years of experience on web development and deployment. Below are my core technical skills 1 ASP.Net /HTML/CSS/Javascript 2 C# SOLID Design Priciples More
Hi, Although i am new here , but i can perfectly do this job for you. I have huge experience in calling API's and inserting the output data in database. It can be scheduled to run every 5 minutes easily . In back e More
Run by IITians and based in Delhi, India, we cover complete horizon of Software development and Online solutions and services. We have been delivering with utmost efficiency at affordable pricing.
Hi. I know a lot of MS SQL design and development. I work on my own. I am ready to start working with you now. Regards, Little Monkey
I have written for Apple apps using my own written web server , sql and vb. I also have programmed many other applications.