Images
Query the available images on your ActOn account.
View Specific Information
The provider 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 provider.
- 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')
Columns
| Name | Type | Description |
| 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-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 |
| Type | String | Identifier for the next page of results. Do not set this value manually. |