FireDAC Components for Act-On

Build 20.0.7654

Reports

Query the available reports in ActOn.

View Specific Information

To query data from this view, you must specify MessageId.
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 '=' and 'IN' operators.

For example, the following queries are processed server side:

SELECT * FROM Reports WHERE MessageId = 'd-0008'
SELECT * FROM Reports WHERE MessageId IN ('d-0008','s-0004-1809')
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 [KEY] String The Id of the message.
Title String The title of the message.
Status String The status of the message.
Bounced Int The number of times the message generated a bounce.
Clicked String The number of times the message has been clicked.
Delivered Int The number of times the message has been delivered.
EffectiveOpened String .
HardBounced Int The number of times the message generated hard bounce.
LastClick Datetime The timestamp of the last click.
LastOpen Datetime The timestamp of the last opening.
NotOpened Int The number of times the message has not been opened.
NotSent String The number of times the message has not been sent.
Opened String The number of times the message was opened.
OptOut Int The number of times the receiver opted out.
RedbroadcastClick Int .
Sent Int The number of times the message has been sent.
SentTo String The ids of the people who received the email.
SoftBounced Int The number of times the message generated soft bounce.
Spam Int The number of times has been considered as spam.
Subject String The subject of the message.
SuppressedOn String .

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