Is there a workaround to upsert CreatedDate and CreatedById fields in Salesforce in 1 single task?

  • 305Views
  • Last Post 31 July 2019
David Rose posted this 30 July 2019


I'm trying to import CreatedDate and CreatedById from SQL server to Salesforce for an object. According to Salesforce, we can only Insert, not Update/Upsert these two fields. In Salesforce, I already have some existing records. So, I have to separate the task into two: update the existing records, and upsert the new records. I'd like to know if there's a workaround for this so that I can just upsert the fields without having to manually determine which one already exists?


Dmitriy Muzurov posted this 31 July 2019

Hello David,

Thank you for submitting a ticket with us.

Skyvia works with Salesforce through their API and is limited by its rules.

Salesforce does not allow modifying audit fields. It is possible only to insert data into them.

Please check this link.

That is a limitation from Salesforce, not Skyvia.

Should you have any questions, do not hesitate to contact us back.