JDBC Driver for Act-On

Build 20.0.7655

Images

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.

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.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7655