Closed

Web API Integration with Azure SQL Database

We use Team Haven to collect Field Staff data.

We have a SQL server on Azure.

Currently we have to download Data Exports from the Team Haven Website and load it manually into our SQL server.

Team Haven have a web API available with Integration Events (exposed through a Microsoft Azure Queue).

We would like you to build an Online Server Script in C# that will synchronise all our Team Haven data with our Azure SQL Database automatically.

Data Flow Steps:

1. Addition / Change made to base Team Haven data.

2. Change message exposed through Integration Event Azure Queue.

3. Script to read the Integration Event message.

4. Script to get added / changed data from the Team Haven API.

5. Script to add / update appropriate Azure SQL Database Table according to type of message exposed.

The final solution should provide the C# script and Schemas for all the SQL Database tables that need to be created to accept the API data. We would like instructions on how we can update connection strings and login details to switch the Production build into a Live build. Also instructions on how the install the final script on our server.

For Production we can supply a temporary login & password for Team Haven to allow the use of their API.

Useful Links:

Team Haven Link: [login to view URL]

API Information Link: [login to view URL]

Team Haven have some example code for the Integration Event that can be good starting point.

Team Haven Integration Event Example Link: [login to view URL]

Skills: C# Programming, Microsoft SQL Server, .NET, ASP.NET, SQL

See more: integration userplane sql database, web based form entry sql database, free online web survey asp net sql database, youtube web api integration, twitter api boolean search sql database, web api integration local sql, vba azure sql database, Web api integration, Azure SQL Database, connect excel to azure sql database, azure sql database template, azure sql database arm template, free web front end for sql database, how to create a web form to a sql database, deploy database to microsoft azure sql database, import data into azure sql database, connect azure web app to azure sql database, azure sql database rest api, azure sql database rest api query, get azure sql database rest api

About the Employer:
( 0 reviews ) Glasgow, United Kingdom

Project ID: #31938675

36 freelancers are bidding on average £559 for this job

(98 Reviews)
8.1
AwaisChaudhry

Hello there, How are you doing? Just saw your project posted. I read the brief details and I felt I could help you with it because I have good skills with SQL, C# Programming, .NET, ASP.NET and Microsoft SQL Server. Le More

£750 GBP in 19 days
(44 Reviews)
7.7
(48 Reviews)
7.3
(35 Reviews)
7.3
Proolancer

Hello Sir, I already done multiple project same as your getting data from api and store it in SQL Server database I m an expert about 10 years in C# and .Net & Rest Api and ranked in the top 2% of freelancers in this More

£700 GBP in 7 days
(74 Reviews)
6.7
(31 Reviews)
6.5
(19 Reviews)
5.8
(46 Reviews)
5.7
(28 Reviews)
5.8
(15 Reviews)
5.5
iglobalvn

Hi sir, i have read your requirement carefully. I can do Web API Integration with Azure SQL Database perfectly and exactly without any risk. If you wanna confirm me, please check my work history and portfolio kindly. More

£500 GBP in 15 days
(34 Reviews)
6.3
hsh564cf84accd96

We will do your SQL work I am writing this proposal in order to work for you in Software and Web Development. We are highly trained professional developers seeking to freelance and earn online. Having a flair in progr More

£500 GBP in 7 days
(57 Reviews)
5.7
(1 Review)
5.4
techplusintl

Hi there, ★★★ Microsoft Azure / ASP.NET / C# Expert ★★★ 8+ Years of Experience ★★★ I've read requirements and ready to integrate api with Azure SQL Database. We can build the web application on Microsoft Azure platfor More

£650 GBP in 7 days
(11 Reviews)
5.1
(9 Reviews)
5.1
harune

Hello. I am a Certified PMP (Project Management Professional) & Scrum (Agile) Professional offering services as Full Stack Developer (Frontend & BackEnd), having hands-on experience of developing small, medium and ente More

£500 GBP in 7 days
(17 Reviews)
5.3
MWaqar5246

Greetings, we can surely develop you the web API integration with Azure SQL Database as you require. We are a team of professionals having strong command over .NET, SQL, C# Programming, ASP.NET & Microsoft SQL Server. More

£500 GBP in 6 days
(5 Reviews)
4.8
chetanraj81lx

Dear Client, I am having excellent work experience in c# and sql server. Asp.net mvc, asp.net core, webapi. I will develope webapi for your current team heaven app. Please contact me for further discussion.

£550 GBP in 7 days
(7 Reviews)
4.6
aytacsankur

Hello there, I am a computer engineer who have more than 10 years of software development experience, mainly in .net technologies. I have been working for quite good companies in my country. If you choose to work wit More

£700 GBP in 21 days
(3 Reviews)
4.7
devstart1234

Hi, We are a team and have checked your requirement "Web API Integration with Azure SQL Database". We are ready to sign NDA, If required. Websites: [login to view URL] [login to view URL] ht More

£500 GBP in 10 days
(2 Reviews)
4.6