Salesforce Audit Fields: Quick Insertion Guide
Overview
Audit fields in Salesforce (such as CreatedDate, CreatedById, LastModifiedDate, LastModifiedById) are system fields that track when and by whom a record was created or modified. By default, these fields are read-only and cannot be set during data import. Enabling the Create Audit Fields permission allows Skyvia to populate these fields during INSERT operations - useful when migrating historical data from another system.
Prerequisites
Before mapping audit fields in Skyvia, you must enable the Create Audit Fields permission in your Salesforce instance. See the Salesforce documentation on enabling audit fields for background information.
Steps to Enable the Permission
Step 1: Go to Setup → User Interface
Step 2: Enable the permission via Permission Sets
- Navigate to Administration Setup → Permission Sets.
- Search for Audit Fields.
Step 3: Assign the permission to the user
- Click Manage Assignments → Add Assignments.
- Add the user who should be granted this permission.
After completing these steps, the audit fields will become available for mapping in Skyvia.
Important Notes
- This feature is available only for connections created using the login of the user who has been granted this permission.
- Audit fields can only be mapped when performing an INSERT operation.
- To ensure the audit fields are available for mapping, clear the metadata cache in your Skyvia connection after enabling the permission.
Related Articles
Salesforce: Inactive User Error
Overview The "inactive user" error occurs at the Salesforce connection level in Skyvia. It means that the Salesforce user account used for the connection is inactive or no longer valid, so Salesforce blocks API authentication. As a result, Skyvia ...
A Quick Guide to Importing and Updating Audience Members in Mailchimp
Overview This article explains how to configure an UPSERT operation for the Mailchimp ListMembers object in Skyvia. This is the recommended approach for importing and updating Audience members without creating duplicates. How UPSERT Works for ...
Working with Mailchimp Custom Merge Fields
Overview In some scenarios, you may encounter difficulties accessing custom Mailchimp fields in Skyvia. This article explains how to configure the Merge Fields Behavior setting to make custom (merge) fields available in your integration. Steps to ...
Salesforce Report exports only 2000 records
Overview When using Salesforce Reports as a data source in Skyvia, the export is limited to the first 2,000 rows. This is not a Skyvia limitation — it is a hard restriction imposed by the Salesforce Run Report API, which Skyvia uses to retrieve ...
UPDATED: Salesforce: Expired access/refresh token
Overview If you see an "expired access/refresh token" error, your Salesforce OAuth connection is invalid. This happens when the token has expired, been revoked, or invalidated by a Salesforce security policy change. Possible Causes The OAuth token ...