Images
Query the available images on your Act-On account.
View Specific Information
The 本製品 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 本製品.
- FolderName supports the '=' and 'IN' operators.
- Id supports the '=' operator.
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')
SELECT * FROM Images WHERE Id = '001'
Columns
| Name | Type | Description |
| Id [KEY] | String | The Id of the image. |
| FolderName | String | The name of the folder that contains the image. |
| Name | String | The name of the image. |
| CreationTime | Datetime | The date/time the image was created. |
| LastModified | Datetime | The date/time the image was last modified. |
| ImageUrl | String | The image's URL. |
| ThumbUrl | String | The image's ThumbURL. The ThumbURL shortens a long URL and tracks clicks. |
| Size | Int | The size of the image. |
| Width | String | The width of the image. |
| Height | String | The height of the image. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Type | String | The identifier for the next page of results. Do not set this value manually. |