Query the available images on your ActOn account.
View Specific Information
The driver will use the Act-On API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the driver.
- FolderName supports the '=' and 'IN' operators.
For example, the following queries are processed server side:
SELECT * FROM Images WHERE FolderName = 'New Folder' SELECT Name, FolderName FROM Images WHERE FolderName IN ('New Folder', 'Default Folder')You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will result in unfiltered data being pushed.
|Id [KEY]||String||Id of the image.|
|FolderName||String||Name of the folder that contains the image.|
|Name||String||Name of the image.|
|CreationTime||Datetime||When the image was created.|
|LastModified||Datetime||When the image was last modified.|
|ImageUrl||String||Link to the image.|
|ThumbUrl||String||Link to the image.|
|Size||Int||Size of the image.|
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.
|Type||String||Identifier for the next page of results. Do not set this value manually.|