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

  • 18Views
  • Last Post 3 weeks ago
David Rose posted this 3 weeks ago


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 3 weeks ago

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.