>>> Thanks for your reply.
>>> I also use WestWind Client Tools for automated E-Mailing (have for years).
>>> Which components are you using? Are you able to synchronize Data between VFP and Salesforce?
>>
>>IIRC, all you really need is wwJSonSerializer
>>
>>Syncing data back-and-forth using Json (via update/upserts) works like a charm. There's some finicky-ness with the way it treats empty dates. I think by default wwJsonSerializer passes an empty string (e.g. "') and Salesforce expects null. (I'm not sure if that's salesforce-wide or if it's just the instance I am working with.) I modified that section of WriteDate in wwJsonSerializer.prg so that it returns [null] instead of [""].
>
>Thanks for the info Thomas - most helpful - will look into this.
Are you able to do 2-way synchronization in real-time or do you create a temporary "Update" file on both ends?

No, it's not real time because all the communication is initiated by my application (Salesforce has no way of initiating communication with my application). The architecture we settled on is basically a stand-alone process that polls my application and Salesforce at regular intervals and then communicates updates between the two.

The data pushed from my application goes directly into Salesforce. But data pulled out of Salesforce is placed in interstitial tables to ensure that my application's business rules are applied and the data is properly validated.

In practice this is close enough to "real-time" to satisfy my client.