All Collections
Connectors
Salesforce
The Salesforce IDs in the report export don't match the IDs in Salesforce
The Salesforce IDs in the report export don't match the IDs in Salesforce
Updated over a week ago

If you experience a situation where you've exported records from SigParser and the CRM Contact or Account IDs don't match this article will help you.

What's wrong

Salesforce's API exposes all the IDs with 18 characters but the Export from the Salesforce app generates IDs that are only 15 characters.

How to resolve this

You can create a Formula field on the Contact or Account using the function CASESAFEID(id) to convert the 15 character ID into an 18 character ID that can be compared to the value coming out of SigParser's export.

In Salesforce Setup section:

  • Go to your Object

  • New Field. Name is "Full ID" or whatever you wish

  • Type = Formula

  • Output = Text

  • Type CASESAFEID(Id) as the entire formula. Save.

  • Go to your Report and use your new field!

Did this answer your question?