Fields Containing Data in the Source Contain null Values in the Destination

Issue

Fields containing relevant data in the source contain null values in the destination.

Environment

Connector: Salesforce

Resolution

To resolve this issue, ensure the authorizing user has the permission required to access the applicable field and its data. See Salesforce's Permissions and Access Settings documentation for more information.

If you have only recently granted the authorizing user permission to access the field or included it in your sync, do the following:

1. In Fivetran, go to your Salesforce connector page.
2. Select the Schema tab.
3. Locate and hover over the applicable table.
4. On the right side of the screen, click Resync.
5. In the confirmation popup window, click Start re-sync.

Cause

This issue may occur for any of the following reasons:

• The authorizing user doesn't have access to the applicable field.
• The authorizing user only recently gained access to the field, resulting in null values from before access was granted.
• The field was only recently included in your sync, resulting in null values from before it was included.