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.
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]
36 freelancers are bidding on average £559 for this job
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.