MSSQL sync with SOAP API

Completed Posted 5 years ago Paid on delivery
Completed Paid on delivery

We have a need to synchronise an MSSQL query to a SOAP API.

The API documentation is here:

[login to view URL]

The scope is as follows:

1. Script takes infromation from MSSQL query

2. Script checks if the user is in the Swiftdigital platform

3. Script checks if the email associated with the user is correct (if not changes it to what the MSSQL query has returned).

4. Script checks if the user is in the correct email list (if not add or change email list association).

5. Script 'unbounces' users

6. Script removes users list associations from Swiftdigital platform who no longer appear in the MSSQL query output.

7. Script sends an email report on any changes made during sync.

8. Script runs once a day.

We would like the script to be developed in Powershell.

There are 8 MSSQL queries where the data comes from.

Please provide a quote and time estimate for this job.

Powershell Scripting SQL

Project ID: #17706119

About the project

12 proposals Remote project Active 5 years ago

Awarded to:

feninsoftech

Hi, This can be developed as a C# console application instead of PowerShell. This application then will be scheduled in windows scheduler to run daily basis. I have 10 years experience in development that include More

$555 AUD in 70 days
(47 Reviews)
6.7

12 freelancers are bidding on average $633 for this job

DebasisB

Hi, I am interested in the project. I think the best possible solution would be a windows service with customized configuration to run automated at a specific time defined. Please contact me through messenger for more More

$555 AUD in 10 days
(28 Reviews)
5.6
seemasit

Hi, I am expert with SOAP API and I will do all requirement as you mentioned in job dashboard. I am ready to start working now after details discussion. Thanks

$1388 AUD in 30 days
(2 Reviews)
4.7
hemantjhalani

Hello I ma expert in Mysql and api integration and I have more then 5 years of experience in development so feel free to contact me. Thanks Hemant

$500 AUD in 10 days
(7 Reviews)
3.6
waema

i can deliver this in a week. i have worked on many web scripts before. please lets talk more.

$400 AUD in 7 days
(3 Reviews)
2.9
softwarevamp

Hello , I can do this in a timely, accurate and professional manner, look to work with you. At your disposal for any query. > No upfront and milestone payments , pay for deliverable only! < Sincerely, Weifen More

$1111 AUD in 10 days
(2 Reviews)
2.6
Dckumawat

I am very good hand of expercie with api development using SOAP have developed sync api already for many mobile apps. Please message me for further communication. Thanks

$555 AUD in 5 days
(0 Reviews)
0.0
sajeeshchatl

Soap/rest api programming for your mysql wuesries based

$444 AUD in 5 days
(0 Reviews)
0.0
sparxsols7

Hi, Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have got Rich experience in Jooml More

$555 AUD in 10 days
(0 Reviews)
0.0
drudev

Hi, I see you are looking for web developer experienced in SOAP and web services and APIs to synchronise an MSSQL query to a SOAP API 1. Script takes infromation from MSSQL query 2. Script checks if the user is in th More

$250 AUD in 10 days
(0 Reviews)
0.0
venkkateshRao

hi, i am proficient in writing powerShell script and Sql (t- sql queries). you can reach out to me for basic ideas. this bid includes documentation. Thanks Venkat

$722 AUD in 20 days
(0 Reviews)
0.0