SSIS Components for Salesforce Chatter

Build 21.0.7930

Files

Retrieve File details.

Table Specific Information

Select

By default, queries to this table return a list of files that belong to the current user. The component uses the Salesforce Chatter API to process searches on the following columns: CommunityId, GroupId, UserId, FolderId, TopicId, or Id (the primary key), or a combination of two Ids. The allowed operators are = and AND.

Other filters are executed client side within the component. For example, the following queries are processed server side.

SELECT * FROM Files
SELECT * FROM Files WHERE FolderId = 'abc123'
SELECT * FROM Files WHERE UserId = '123456'

You can also use the Salesforce Chatter APIs to filter through the files:

SELECT * FROM Files WHERE SearchTerms = 'test'

Note: The use of wildcards is permitted when filtering Files:

  • * matches zero or more characters at the middle or end of your search term.
  • ? matches only one character in the middle or end of your search term.

You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria that refer to any other columns will cause an error.

Columns

Name Type Description
Id [KEY] String The unique identifier of the file.
Name String The name of the file.
SearchTerms String Query to search the files database.
Title String Title of the file.
Description String Description of the file.
FileType String Type of file, such as PDF, PowerPoint, and so on.
ContentSize Integer Size of the file in bytes.
Url String The file url.
DownloadUrl String URL to the file.
OwnerId String Id of the file owner.
OwnerDisplayName String Display name of the file owner.
OwnerPhoto String Photo URL of the file owner.
OwnerTitle String Title of the file owner.
VersionNumber String Version number of the file.
ContentModifiedDate Datetime An ISO 8601 date format '2011-02-25T18:24:31.000Z'. File-specific modified date, which is updated only for direct file operations, such as rename.
FileExtension String Extension of the file.
IsInMyFileSync Boolean true if the file is synced withSalesforce Files Sync; false otherwise.
IsMajorVersion Boolean true if the file is a major version; false if the file is a minor version. Major versions cannot be replaced.
MimeType String MIME type of the file.
ModifiedDate Datetime An ISO 8601 format date string, for example, 2011-02-25T18:24:31.000Z. Modifications to the file from within Salesforce update this date.
Origin String Specifies the file source. Valid values are: 'Chatter', 'Content', or 'FileField'.
PageCount Integer Number of pages for documents that support flash renditions, or the number of slides in a presentation.
ParentFolderId String The file's parentFolder id.
ParentFolderUrl String The file's parentFolder url.
PublishStatus String The publish status of the file. One of these values: 'PendingAccess', 'PrivateAccess', or 'PublicAccess'.
RenditionUrl String URL to the rendition resource for the file.
SharingOption String Sharing option of the file. Values are: 'Allowed' or 'Restricted'.
SharingRole String The sharing role of the file. One of these values: 'Admin', 'Collaborator', 'Owner', 'Viewer', or 'WorkspaceManaged'.
TextPreview String Text preview of the file if available; null otherwise.
CheckSum String MD5 checksum for the file.
Type String ContentDocument.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
IsMe Boolean Instead of specifying your exact Id, set this to true to retrieve your account information
FolderId String Id of the folder associated with the current file.
TopicId String Id of the topic associated with the current file.
GroupId String Id of the group associated with the current file.
UserId String Id of the user associated with the current file.
CommunityId String Id of the community associated with the current file.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930