This article outlines the steps for building an application that lets you synchronize your customer list between two systems.
Using the built-in API framework, you can build the relevant bridges so you can synchronize two databases at business-appropriate intervals.
Programming skills are required to develop such a bridge. You can use any programming language that supports web services to write your applications that communicate with this system.
You can find a sample definition for the Customer/CRM related web service here. But for production use, visit the API Integration screen. Choose Site Settings > API Integration to obtain the proper WSDL URL for the specific site you want to integrate with.
The method also required three variables:
- LastUpdateDate: The date at which you want any new or updated contact records returned.
- RecordStart: The offset of the records to be returned. Initially, it's necessary to pass in a value of 0. Each call to the method returns 100 records.
- MoreRecords: A reference variable set to true if there are more records to retrieve. If the value is true, then call the method again, but add 100 to the original offset. On the second call, the value of RecordStart is 100, and so on. Repeat this step until false is returned to get the entire list of contacts.
Similar to the import routine, you can use the External ID property to set a unique identifier value for each customer. If this value is present, then customers are matched and updated accordingly. For example, if every customer in your system has a member number, then assign that to the External ID property. If you do not use this property, then the unique identifier used is a customer's email address. If neither is provided, then contacts are added and never updated, as no unique identifier exists.