Skip to main content
All CollectionsConnecting a CRMSalesforceSalesforce FAQs
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 10 months 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?