Connect Microsoft SQL Server 2014 to API

Closed Posted 6 years ago Paid on delivery
Closed

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.

Microsoft SQL Server RESTful

Project ID: #14743465

About the project

37 proposals Remote project Active 6 years ago

37 freelancers are bidding on average $36/hour for this job

NallakumarKC

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

$31 AUD / hour
(55 Reviews)
7.0
atisch

Hello. I represent a small but well balanced team of two experienced SW developers. We have been involved with REST web services on both service and consuming sides in many projects. One of the latest apparently most More

$40 AUD / hour
(9 Reviews)
6.8
feninsoftech

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

$33 AUD / hour
(24 Reviews)
6.2
riskypathak

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

$40 AUD / hour
(17 Reviews)
6.4
aanvikm

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

$35 AUD / hour
(8 Reviews)
5.4
BitSDestiny

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

$25 AUD / hour
(28 Reviews)
5.0
IMExpertEngineer

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

$41 AUD / hour
(6 Reviews)
4.6
sopholos

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.

$105 AUD / hour
(9 Reviews)
4.4
bmartynvw

Hi, My name is Benjamin. I'm an expert with over 14 years of experience. I have worked on several custom Stored Procedures for integrating RESTful services. As an expert, I can ensure the use of industry best pra More

$41 AUD / hour
(1 Review)
3.9
dat2na

Greetings, I'm professional database expert with 9+ years experience. Currently I'm working as DBA and DB developer in one of the leader company. As you can see in my profile, I have deep experience of same jobs like More

$55 AUD / hour
(2 Reviews)
2.8
sahumk2000

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

$41 AUD / hour
(4 Reviews)
2.1
joemarecaro

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

$41 AUD / hour
(2 Reviews)
2.8
freelancernewtec

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

$27 AUD / hour
(1 Review)
1.8
Webiots

hello sir, we can easily integrate restful api and mssql 2014 we have done similar many projects we have 3+ years experience in this lets discuss more about your project and start working on it Regards, More

$27 AUD / hour
(0 Reviews)
0.0
sumitgupta16

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

$25 AUD / hour
(0 Reviews)
0.0
SoftoMozo

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.

$41 AUD / hour
(0 Reviews)
0.0
Shopify

Hi, I (Myself a senior PHP Developer) have a team having experience of more than 10 years in developing web and mobile applications. I have a team of expert programmers who write robust and bug-free codes at the ve More

$25 AUD / hour
(0 Reviews)
0.0
monillo

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

$27 AUD / hour
(0 Reviews)
0.0
cuyosoft

I have experience in administration and programming with t-sql in sql server 2014. stored procedures, functions and views. I have experience in administration and programming with mysql. stored procedures, functions a More

$41 AUD / hour
(0 Reviews)
0.0
dgmdave

I have written for Apple apps using my own written web server , sql and vb. I also have programmed many other applications.

$50 AUD / hour
(0 Reviews)
0.0