Job Configuration - Job Configuration - Alfresco - Alfresco Federation Services - Alfresco/Alfresco-Federation-Services/3.2/Alfresco-Federation-Services/Configure/Connectors/Salesforce/Job-Configuration - 3.2 - 3.2

Salesforce Repository

• Default Name Field: This field will be used to extract the document name from the columns of data. It should be formatted {type}.{field}.
  • Example: Account.Name when selection FROM Account
  • Example: ContentVersions.Title when selecting from ContentVersions
• SOQL Query: The query to run against Salesforce. All fields that you intend to extract or map should be included in this query.
  • Example:

    SELECT
                  AccountNumber,BillingCity,CreatedById,CreatedDate,Id,LastModifiedDate,Name,OwnerId
                  FROM Account

  • Test your query using the Salesforce Workbench tool.

Salesforce Output

Salesforce output is not currently supported.

TIME BASED QUERIES

In order to use the start and end time configured on the jobs, the variables [starttime] and [endtime] must be included in the query.

• The ID for the object is required and must be included in the query.

CONTENT

Currently, this connector can only retrieve Attachments and ContentVersions. In order to retrieve Content Versions you must query them directly. Here’s an example query that will retrieve the standard Federation Services metadata:

Select
        Id,ContentDocumentId,ContentUrl,Description,FileType,PathOnClient,Title,ContentModifiedById,ContentModifiedDate,CreatedDate,ContentSize
        from ContentVersion