Table

cm_salesforce_sources

Description

Salesforce Organizational Identity Sources

Plugin

Salesforce Source

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 OAuthRemoved v3.2.0
access_tokenvarchar(160)Current access tokenSalesforce OAuthRemoved 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
  • No labels