JDBC Driver for Act-On

Build 22.0.8462


Query the available campaigns ActOn.

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.

  • Id supports the '=' and 'IN' operators.

For example, the following queries are processed server side:

SELECT * FROM Campaigns WHERE Id = 0001
SELECT * FROM Campaigns WHERE Id IN (0001, 0002)
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.


Name Type Description
Id [KEY] String The Id of the campaign.
Name String The name of the campaign.
Created Datetime When the campaign was created.
AssetIds String Asset ids of the campaigns.
Description String Description of the campaign.
Modified Datetime When the campaign was last modified.
Urls String Urls related to the campaign.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462