FireDAC Components for Act-On

Build 20.0.7654

DrilldownReports

Query detailed reports about messages in ActOn.

View Specific Information

The component 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 component.

  • MessageId supports the '=' operator.
  • Drilldown supports the '=' operator.

MessageId and Drilldown are required to select from this view and will be filtered by the Act-On API.

SELECT * FROM DrilldownReports WHERE MessageId='s-0003-1803' AND Drilldown='SENT'
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
MessageId String The id of the message.
Drilldown String Type of message.

The allowed values are SENT, SUPPRESSED, OPENED, CLICKED, BOUNCED, OPT_OUT, SPAM.

Email String The receiver email.
Name String Name of the receiver.
ListId String Id of the list the receiver belongs to.
RecId String The id of the receiver.
Timestamp Datetime When the message was sent.

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