JDBC Driver for Act-On

Build 22.0.8462


Query the available subscriptions in 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.

  • Category supports the '=' operator.

Category is required to select from this view. For example, the following query is processed server side:

SELECT * FROM SubscriptionOptOuts WHERE Category = 'test'
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
Email String The email of the subscribed user.
Timestamp Datetime The time when the user subscribed.
Category String The category of the subscription. This attribute is required for select operations.

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