Set up API PHP MSSQL2012 Connection to Leadsquared

Hi, We require an API set up to push our customer data to Leadsquared. ------------------------------------- Here is the Scenario: - We have Microsoft SQL Server 2012 for our customer database and the data for Leadsquared is set up in a View in this database - We have PHP and will use Leadsquared sample PHP code as a starting basis - We need to push our database data of customers to Leadsquared using their API: * Each time a customer is created in our database we need to create that customer/lead in Leadsquared using an API that runs every 2 hours * Each time a customer’s details are updated in our database we need to update those details in Leadsquared using an API that runes every 2 hours * When a customer changes their email address in our database we need it to update their email address in Leadsquared. Here is a suggestion from Leadsquared which isn't the exact solution though it is a starting point: Step 1. Use search by lead criteria API ([login to view URL]) to find the customer id of the lead on the basis of Customer ID. Step 2. If customer id is found -> Use update API ([login to view URL]) to update the email id of the lead using prospect id. Else ->Use create lead API ([login to view URL]) to create new lead. * All API calls/changes need to be saved to a log * We will provide you with Leadsquared logon details ------------------------------------- Scope of this job. We require someone to look at our scenario, look at how Leadsquared API work and then: - Advise us the best solution to automatically update leadsquared with our data on a schedule every 2 hours or on demand - Create that solution using PHP API starting with the sample code provided by Leadsquared. It will need to connect to our database view (use sample data attached) and push the data to Leadsquared automatically every 2 hours or on demand - Create the code and set it up on your server so we can test it providing a way to update the SQL data so we can see it update in Leadsquared. Once all ok supply files then we will install and test it here. Payment on completion once all tested working ok. Note: - The order that the API should search on is using the CustomerID first, then the TempID. Not all customers have a CustomerID. Here is the logic 'concept' that I foresee though if you have a better suggestion I am open to that as this concept may not work though is provided as a starting point: 1. Search for 'CustomerID' first 2. If 'CustomerID' is found update by update API all fields for that customer 3. Else if 'CustomerID' is not found search by for 'TempID' 4. If 'TempID' is found update by update API all fields for that customer 5. Else if TempID is not found use create Lead API to create new lead ------------------------------------- API Reference Info: [login to view URL] Leadsquared API PHP Code samples to start with: [login to view URL] ------------------------------------- Sample data to use is attached. Please include the ETA time completion in your bid. Thank you,