Code c# client to retrieve transactions with Revolut API into DB

Completed Posted 5 years ago Paid on delivery
Completed 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.

.NET ASP.NET C# Programming Microsoft SQL Server SQL

Project ID: #17950041

About the project

6 proposals Remote project Active 5 years ago

Awarded to:

paskal77

Hello, I have read your request and I can help update software with the options you require. Complete integration with the Revolut API. Integration with database. Creation of a parametric table. I have experien More

$40 USD in 2 days
(84 Reviews)
6.0

6 freelancers are bidding on average $102 for this job

ehsankayani

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

$222 USD in 3 days
(158 Reviews)
7.7
Zahidtanveer

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

$30 USD in 1 day
(14 Reviews)
4.8
adeellhr786

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

$50 USD in 1 day
(11 Reviews)
4.5
RichThorneycroft

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

$50 USD in 1 day
(0 Reviews)
0.0