[login to view URL] API Integration from our Customer Care System WHMCS

Closed Posted May 4, 2011 Paid on delivery
Closed Paid on delivery

This project is to write one or more php based cron job scripts which will sync and import data from our billing system and sales-helpdesk-tickets ([url removed, login to view] and [url removed, login to view]) to our CRM solution: Salesforce.com.

I am looking for someone with specific experience with [url removed, login to view] API coding work, please explain prior experience in your bid below.

If you are familiar with [url removed, login to view] or [url removed, login to view] that is a big plus, but not required, as its data is all stored in simple MySQL format, and will just require some mysql querries to move data into salesforce.

## Deliverables

This project is to write one or more php based cron job scripts which will sync and import data from our billing system and sales-helpdesk-tickets ([url removed, login to view] and [url removed, login to view]) to our CRM solution: Salesforce.com.

I am looking for someone with specific experience with [url removed, login to view] API coding work, please explain prior experience in your bid below.

If you are familiar with [url removed, login to view] or [url removed, login to view] that is a big plus, but not required, as its data is all stored in MySQL format, and will just require importing and syncing to [url removed, login to view] via api commands.

Your code must be in PHP, and should run via cron job (command line) for a linux (Centos 5.5 Linux 32bit) based system. The PHP code will import data from MySQL databases, and have to use API calls to [url removed, login to view] to import data, and update data such as business leads, proposal status.

The import script will run hourly, scraping our MySQL database(s) for

A) new leads (sales tickets in [url removed, login to view] mysql)

B) new quotes/proposals that were sent (quotes in [url removed, login to view] stored in mysql)

C) import cancellation details to [url removed, login to view] from [url removed, login to view] mysql database

D) update quotes/proposals (sync results stored in [url removed, login to view] such as a completed sale, to salesforce after a sale is made).

The SalesForce API's will require you to create leads, with detailed information that are imported from the MySQL data noted above. The SalesForce API's will be used to put a copy of the quote into SalesForce, and update the status as well. Finally, the salesforceAPI will be used to create task alerts (timed event notifications) inside salesforce for each imported lead, or quote. All details of the SalesForceAPI are located here:

<[url removed, login to view]>

Final Product: Will be multiple php files that we can run as cron jobs.

Access: You will have access to the development area to test on the live server

You will need to make sure it runs on Centos Linux, and it should be able to run every hour and track where it left off the previous hour so it does not duplicate imports of leads or proposals. You will need to make the api calls intelligent enough to handle cases where the lead is for an existing account already in [url removed, login to view] or a brand new lead.

PHP

Project ID: #3290221

About the project

6 proposals Remote project Active May 26, 2011

6 freelancers are bidding on average $1793 for this job

offshore9006

See private message.

$836.4 USD in 14 days
(18 Reviews)
5.9
instantcodervw

See private message.

$701.25 USD in 14 days
(59 Reviews)
5.7
r2andme

See private message.

$722.5 USD in 14 days
(50 Reviews)
5.5
dmwsoftware

See private message.

$935 USD in 14 days
(5 Reviews)
0.3
Spachnanda

See private message.

$3400 USD in 14 days
(1 Review)
0.0
rajnsuvw

See private message.

$4164.15 USD in 14 days
(1 Review)
0.0