Error: INVALID_FIELD: SELECT census_tracking_id__c

Issue

Syncs fail with the following error:

An unknown error occurred. Please retry the job or contact the support team. Restforce::ErrorCode::InvalidField: INVALID_FIELD: SELECT census_tracking_id__c,...

Environment

• Activations
• Destination: Salesforce

Resolution

To resolve this issue:

1. In Salesforce, add a custom field called census_tracking_id__c to the object specified in the error message.
2. Confirm the authorizing user has the required permissions on all necessary fields in the Salesforce destination object.
3. Ensure your source data has a unique identifier field.
4. In Fivetran Activations, go to the relevent Activations sync page.
5. Under Set Up Salesforce Field Mappings, click Refresh Fields.
6. Click + Add Mapping and map the unique source column to the census_tracking_id__c field in the destination.
7. Click Run Test and monitor the API Inspector to track sync progress.
8. Click Next > Update.

Cause

This issue occurs when you sync data to Salesforce relationship objects that lack an external unique identifier. Activations defines its own unique identifier, census_tracking_id__c, to sync these objects without creating duplicate records.