Table Specific Information
You must specify the primary key, Id, to query this table. The = operator is allowed. The adapter will use the Salesforce Chatter API; to filter the results by the Id column.
Other filters are processed client side within the adapter. For example, the following query is processed server side:
SELECT * FROM Folders WHERE Id = 'abc123'
|Id [KEY]||String||The unique identifier of the folder.|
|Name||String||The folder name.|
|Path||String||The path to the folder.|
|CreatedDate||Datetime||The date and time when the folder was created.|
|Type||String||The folder type description.|
|IsInMyFileSync||Boolean||Whether the folder is synced with Salesforce Files Sync.|
|ModifiedDate||Datetime||The date and time when the folder was last modified.|
|MySubscriptionId||String||The folder's subscription id.|
|MySubscriptionUrl||String||The folder's subscription url.|
|ParentFolderId||String||The folder's parent folder id.|
|ParentFolderUrl||String||The folder's parent folder url.|
|Url||String||The folder url.|
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.
|Filter||String||Specifies a filter for items within a folder. The value IsInMyFileSync filters out the items that are not synced in a folder.|