...
Column | Format | Description | Definition | Comments |
|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement |
|
org_identity_source_id | integer, foreign key | Organizational Identity Source ID |
| |
serverurl | varchar(256) | Salesforce instance (may be production or sandbox) |
| eg: https://cs123.salesforce.com |
clientid | varchar(120) | Client ID, for registered (connected) app |
|
|
client_secret | varchar(80) | Client secret, for registered (connected) app |
| This column should be encrypted |
| search_contacts | boolean | Whether to query Salesforce Contact objects |
| Unintuitively, if neither search_contacts nor search_users is true, then all objects will be searched |
| search_users | boolean | Whether to query Salesforce User objects |
| |
| custom_objects | varchar(256) | Comma separated list of objects to query for additional attributes | ||
| refresh_token | varchar(160) | Current refresh token | Salesforce OAuth | |
| access_token | varchar(160) | Current access token | Salesforce OAuth | |
| instance_url | varchar(256) | Current Salesforce instance | Salesforce OAuth |