.NET6 API GET POST WITH MYSQL & MSSQL

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

Logging:

- 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

О проекте