Code a C# command line application which connects to revolut using their business API, retrieve transactions and write all the details of them into an MS SQL DB (transaction header+legs) and disconnect/close.
1. DB : MSSQL server 2012>=. with Integrated authentication /Windows for connection
2. [login to view URL] 4.5
4. NO EXTERNAL LIBRARIES or Component only 100% [login to view URL] framerwork
5. NO STORED PROCEDURE
6. Table to store content retrieved from API should be designed and with appropriate data type , primary key
7. Process should refresh a specific time interval of x month each time the application is triggered. Past transactions may be updated or modified, so if an existing transaction exists it should be updated, if the transaction does not exist it should be inserted.
8. A parameter table should be Added with Following settings available :
a. connection string
b. revolut base api address
c. private key for connection
d. period of history to refresh in month
8. payment once fully working.
1. full source code in a visual studio solution should be provided.
2. script to create SQL DB.
3. Any instruction to install-deploy application
URL for API description : [login to view URL]
Private key for sandbox will be given at beg of project.
To correctly select the developper, please send in a private message with the tables and fields of them that you would create according to the api .
Only get transactions and maybe check transaction function are needed in thi project.
If it is a card transaction the card detail should be available in the db as well as part of the transaction (merchant, card detail,..).
Bid without this detail will be ignored.
6 szabadúszó tett átlagosan $102 árajánlatot erre a munkára
I am a .NET developer with over a decade of commercial experience, often working into Uk based digital agencies and direct end clients. Relevant Skills and Experience API, MS SQL, C#, API