I need to setup an automated job to Upsert our Contacts in SF with their respective data records from our proprietary software. I can do this through Jitterbit Data Loader, but I want to prevent overwriting some of our clean data with possibly incorrect data coming from the corresponding entries in our software. For example, if I am matching on Email, I want to update the First and Last Name ONLY if they do not exist on the SF record. My first thought was to update some filler fields and have Process Builder handle the logic, but the dataloader throws an error when I try to create records without a Last Name.
Any ideas how I could do this?
Your help is much appreciated!
1 respuesta

You are on track with using filler fields if you want to do this declaratively but you may need to create a custom ETL solution using Jitterbit, Scribe, or custom code.
You could create an APEX service within salesforce that's built to receive the raw data, then run through all the business logic to update the fields appropriately.