Code c# client to retrieve transactions with Revolut API into DB
$10-30 USD
Paid on delivery
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.
Constraints :
1. DB : MSSQL server 2012>=. with Integrated authentication /Windows for connection
2. [login to view URL] 4.5
3. C#
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.
Deliverables:
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.
Project ID: #17950041
About the project
6 freelancers are bidding on average $102 for this job
HI, i have read the prog desc. Regarding your inquiry we will create the following table : ID varchar 40 type varchar 10 request_id varchar 30 created_at datetime updated_at datetime completed_at datetim More
Hi, I'm .Net Developer Contact me for Quality Work. Relevant Skills I have: ASP.NET / MVC / Linq / .NET Core / SQL HTML/CSS/Bootstrap, JS/Jquery, Git, TFS Thank you and I look forward to the opportunity to w More
Hi there , a software engineer with experience of 5 years at your service, i am a hardcore C# developer with experience in json/xml and database your job is simple as a cake, let me do it for you real quick, Send m More
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