LastModifiedDate instead of SystemModstamp

VKailash
Level 2

LastModifiedDate instead of SystemModstamp

Salesforce support is recommending that integrations for sync to be done using LastModifiedDate instead of SystemModstamp. Is there a way in Marketo you could do it?

 

Every quarter salesforce rotates its encryption keys & then the  system mod stamp triggers & in Marketo it  sync  all records. Is there a way to to avoid this?. We want to look at last modified date instead.

3 REPLIES 3
Phillip_Wild
Level 10 - Community Advisor

Re: LastModifiedDate instead of SystemModstamp

Hmmm, might be a good question for your customer success manager. I haven't heard of this done, but perhaps it is possible.

VKailash
Level 2

Re: LastModifiedDate instead of SystemModstamp

Hi Phillip. I have created a case with support & below is their response.  

 

"there isn't a way to change what field the integration is using to look for updates. Lastmodifieddate is only looking at changes made by a user whereas systemmodstamp is updates from users as well as automated workflows and background processes: https://help.salesforce.com/s/articleView?id=000336532&type=1 - Some Salesforce internal backend processes will also update 'SystemModstamp,' as 'SystemModstamp' is used internally to signal that a record, or related data, may have changed - and that internal processes may need to synchronize themselves to the new record data. Marketo is using the Systemmodstamp field because its the exact use case needed when it comes to keeping changes up to date."

Phillip_Wild
Level 10 - Community Advisor

Re: LastModifiedDate instead of SystemModstamp

Seems logical. So if you go off LastModifiedDate, you will miss any changes not made by a user, which would likely be important.

 

A shame about the encryption keys. How large is your database? Would it take a long time to sync everything back in?