Web API Integration with Azure SQL Database
Budget: £250 – £750 GBP
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: https://www.teamhaven.com/
API Information Link: https://github.com/teamhaven/WebAPI/wiki/Users-API
Team Haven have some example code for the Integration Event that can be good starting point.
Team Haven Integration Event Example Link: https://github.com/teamhaven/WebAPI/tree/master/Examples/Example2
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: https://www.teamhaven.com/
API Information Link: https://github.com/teamhaven/WebAPI/wiki/Users-API
Team Haven have some example code for the Integration Event that can be good starting point.
Team Haven Integration Event Example Link: https://github.com/teamhaven/WebAPI/tree/master/Examples/Example2