Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

 

Column

Format

Description

Definition

Comments

id

integer, primary key

Row identifier

autoincrement

 


org_identity_source_id

integer, foreign key

Organizational Identity Source ID

cm_org_identity_sources:id


server_idinteger, foreign keyServer IDcm_servers:idAdded v3.2.0

serverurl

varchar(256)

Salesforce instance (may be production or sandbox)

 


eg: https://cs123.salesforce.com

Removed v3.2.0

clientid

varchar(120)

Client ID, for registered (connected) app

 


 Removed v3.2.0

client_secret

varchar(80)

Client secret, for registered (connected) app

 


This column should be encrypted

Removed v3.2.0

search_contactsbooleanWhether to query Salesforce Contact objects
  • true: Query Contacts
  • false: Do not query Contacts
Unintuitively, if neither search_contacts nor search_users is true, then all objects will be searched
search_usersbooleanWhether to query Salesforce User objects
  • true: Query Users
  • false: Do not query Users
 

custom_objectsvarchar(256)Comma separated list of objects to query for additional attributes  

refresh_tokenvarchar(160)Current refresh tokenSalesforce OAuth Removed v3.2.0
access_tokenvarchar(160)Current access tokenSalesforce OAuth Removed v3.2.0
instance_urlvarchar(256)Current Salesforce instanceSalesforce OAuth 
groupable_attrsblobCached list of attributes available for CO Group mapping 
Internal format based on response from Salesforce API