How do I find records by their 15-character Salesforce ID?


You want to find certain records by their 15-character Salesforce ID


Heroku Connect uses 18-character Salesforce IDs (or sfids). You may occasionally encounter Salesforce IDs outside of Heroku Connect that are 15 characters long. If you need to search for the corresponding record in your database, use a wildcard search, like this:

SELECT * FROM WHERE sfid LIKE '0030P00001yr8Fq%';

Ask on Stack Overflow

Engage with a community of passionate experts to get the answers you need

Ask on Stack Overflow

Heroku Support

Create a support ticket and our support experts will get back to you

Contact Heroku Support