Закрыт Опубликован 10 мес. назад Оплачивается при доставке
Закрыт Оплачивается при доставке

Need some one to read some data from a GET endpoint of a API URL

and insert into sql & mysql tables with about ~35 fields

most of them varchar and a few datetime fields. Basically this is syncing data from an api endpoint into our tables back and forth.

Frameworks involved: Restsharp, Entity Framework, Logging

- Create a .Net 6 REST API app and expose 2 endpoints Contact (Get & POST)

- Create the tables ListData with same structure in both Sql server and Mysql. Table name can be Contact_From_List

- Create one more table to hold new data (same structure). Table name New_Contact_Data_Holder in both Sql Server and MySql

- Create the necessary entity framework classes for both sql server and mysql

- setup the End point with Mockoon. Json data will be given for Get & Post

- Endpoint names can be like /Contacts (GET & POST)

Get from API & Insert into SQL Server & My Sql Tables:

- Use restsharp to read the data from api endpoint

- Check if the Email Address already exists.

- Insert the data into the Sql Server and My Sql Tables if not found.

- If the record is already existing update the record and log both the old record and new record

Post API from New_Contact_Data_Holder

- Insert some dummy data into New_Contact_Data_Holder

- Read from this New_Contact_Data_Holder and post to Mockoon

- Make sure the data is inserted into api


- Need debug level logging for all operations

- If a read/post succeeded, add a Info level log

- If a read/post has failed, add a warning log

- Failed records should be fully logged with data

Code should not break if one row of data update fails. It should continue with the remaining records.

Our endpoints can be like http://localhost:port/api/contact (get & post

let me give you the table columns

Table Fields:

[Email_Address] [varchar](75) NULL,

[First_Name] [varchar](40) NULL,

[Middle_Name] [varchar](40) NULL,

[Last_Name] [varchar](15) NULL,

[Email_Preference] [varchar](40) NULL,

[Address] [varchar](40) NULL,

[City] [varchar](30) NULL,

[State] [varchar](20) NULL,

[Zip] [varchar](10) NULL,

[Country] [varchar](20) NULL,

[Phone] [varchar](25) NULL,

[Fax] [varchar](25) NULL,

[Cell_Phone] [varchar](25) NULL,

[Company_Name] [varchar](40) NULL,

[Job_Title] [varchar](35) NULL,

[Business_Phone] [varchar](25) NULL,

[Business_Fax] [varchar](25) NULL,

[Business_Address] [varchar](40) NULL,

[Business_City] [varchar](30) NULL,

[Business_State] [varchar](20) NULL,

[Business_Zip] [varchar](10) NULL,

[Business_Country] [varchar](20) NULL,

[Notes] [text] NULL,

[Date_1] [datetime] NULL,

[Date_2] [datetime] NULL,

[Extra_3] [varchar](100) NULL,

[Extra_4] [varchar](100) NULL,

[Extra_5] [varchar](100) NULL,

[Extra_6] [varchar](100) NULL,

[Date_Created] [datetime] NULL,

[Date_Modified] [datetime] NULL,

[Optin_IP] [varchar](100) NULL

There will be a JSON which matches most of the fields above which will be received a bit later.

Please confirm if you are able to do this in a day

so your confusion will be less

One function to pull data from API

one function to write into sql server

another function to write into mysql

and another function to read from sql + one for my sql

and another function to post to the API

that way it will be less confusing

and we can then make it api project in .net 6

There is one more thing. I think there are only a few fields which match the API with tables

so the API Model may have only fewer fields (you will need a API model too)

ok, same for POST too

let me give the Post API and fields too now

API: /Contact/{{ListID}}/ContactDetails

Post JSON Body:

{"Data":{"Email":"muthu[AT][login to view URL]","FirstName":"Muthu","LastName":"Kumar","EmailPerm":"1"}}

the above is POST

do not ask where is apis : download Mockoon software

You will add these endpoints to Mockoon and do the work

Fake API

no need to create apis

you just open mockoon

add a url and response

and it will do the rest

No coding there for creating api

Do you think this makes sense?

mention .NET6 in top of your bid.

.NET .NET Core Программирование на C# .NET 5.0/6 .NET Core Web API

ID проекта: #35723339

О проекте

12 заявок(-ки) Удаленный проект Последняя активность 9 мес. назад

12 фрилансеров(-а) готовы выполнить эту работу в среднем за $51


.NET 6 Hi, I am a Full stack developer in Microsoft technologies.  I have vast experience on working on projects that suits your requirement exactly. You can check the reviews in my profile regarding the same. My ar Больше

$100 CAD за 2 дней(-я)
(28 отзывов(-а))

85 cad me kr deta

$85 CAD за 2 дней(-я)
(39 отзывов(-а))

.NET6 Hi, Hope you are doing good. I am experience .NET developer, my core expertise are in building modular, scalable application/services(individually or in teams). I don't assume to know all but I am professional an Больше

$60 CAD за 7 дней(-я)
(8 отзывов(-а))

Good evening, my name is Michael and I live in Colombia. My experience and years of work in the software industry have made me create quality and agile work.

$40 CAD за 7 дней(-я)
(4 отзывов(-а))

Hello, I have 7+ year of experience in C#, asp.net and .net core web app and API. I read all your details so i think i can finish your notified work. Let me know if you interested to work with me. Thanks

$50 CAD за 3 дней(-я)
(1 отзыв)

Hello, I have read your description very carefully and can complete it perfectly in a short time. I am a new freelancer, But I am confident in my skills and always value client trust. So I have rich experience in thes Больше

$40 CAD за 7 дней(-я)
(1 отзыв)

Hello, I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I have more than 16 years of experience and have completed 100+ projects. I can achieve the resul Больше

$50 CAD за 5 дней(-я)
(1 отзыв)

.NET6 Hello, I'm a professional in C#NET, ASP.NET MVC, and MSQL Server, and I'm sure I can do this. I am looking forward to working with You! Thanks, Noman M.

$40 CAD за 1 день
(0 отзывов(-а))

may be i am not the most experienced but I am hardwarker and I will do your task in less than 4 days

$40 CAD за 4 дней(-я)
(0 отзывов(-а))

.NET 6 is what I frequently deal with in my current projects. So I can provide you an API or Worker that would do what you need as expected. I will start two docker containers on my laptop with mysql and mssql and show Больше

$30 CAD за 14 дней(-я)
(0 отзывов(-а))