MSSQL sync with SOAP API

$250-750 AUD

Suoritettu

Julkaistu

yli 5 vuotta sitten

$250-750 AUD

Maksettu toimituksen yhteydessä

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

Projektin tunnus (ID): 17706119

Tietoa projektista

12 ehdotukset

Etäprojekti

Aktiivinen 6 vuotta sitten

Haluatko ansaita rahaa?

Sähköpostiosoite

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu

Saa maksu työstäsi

Kuvaile ehdotustasi

Rekisteröinti ja töihin tarjoaminen on ilmaista

Myönnetty käyttäjälle:

@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 includes C# win-forms, ASP.NET MVC, Windows Services, WCF, SSRS and SQL Server. Involve in designing databases, Indexing Strategies, table partitioning, writing Stored Procedures, Triggers, functions and views. Thanks

$555 AUD 70 päivässä

4,9

(47 arvostelua)

6,7

12 freelancerit tarjoavat keskimäärin $633 AUD tätä projektia

@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 discussion regarding the project. Thanks.

$555 AUD 10 päivässä

4,8

(28 arvostelua)

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

$1 388 AUD 30 päivässä

4,6

(2 arvostelua)

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 10 päivässä

5,0

(7 arvostelua)

3,6

@waema

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

$400 AUD 7 päivässä

5,0

(3 arvostelua)

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, Weifeng

$1 111 AUD 10 päivässä

5,0

(2 arvostelua)

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 5 päivässä

0,0

(0 arvostelua)

0,0

@sajeeshchatl

Soap/rest api programming for your mysql wuesries based

$444 AUD 5 päivässä

0,0

(0 arvostelua)

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 Joomla, Wordpress, Codeigniter, Cake PHP), .NET, Asp.NET, Vb.NET, HTML 5 etc.& mobile apps Also have very good knowledge of javascript, jQuery Json, API, Prototype Frameworks, and have developed various Parallax, Fluid responsive design. I am ready to discuss with you with best Regards

$555 AUD 10 päivässä

0,0

(0 arvostelua)

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 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. It runs as a CRON Your project reminds me of one of my previous projects called "PagSeguro payment INTEGRATION into website". The client needed the payment process to be the exact smae way as in the referenced webiste. I used the pagseguro API and did a curl requests to create a payment form on the website. I also recently created a connector between ZenCart and Dolibarr and also kanbanidze and magento using their respective APIs.I am API expert. You can check my completed API projects one of them is this - https://www.freelancer.com/jobs/project-5353216/. Your project reminds me of one of my previous projects called "LinkedIn API Connection Project". The client needed 1) Sign in with LinkedIn (it is just the image right now but you will need to make it work)

$250 AUD 10 päivässä

0,0

(0 arvostelua)

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 20 päivässä