CData Python Connector for Act-On

Build 24.0.9062

Messages

Query the available messages in ActOn.

View Specific Information

The 本製品 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 本製品.

  • Type supports the '='operator.
For example, the following query is processed server side:
SELECT * FROM Messages WHERE Type = 'SENT'
Type can be one of: SENT, DRAFT, TEMPLATE, TRIGGERED, FAILED, SCHEDULED

Columns

Name Type Description
Id [KEY] String The Id of the message.
Timestamp Datetime When the message has been sent.
Title String Title of the message.
FolderName String The folder where the message is contained.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
Type String Used as a filter to retrieve different types of messages.

使用できる値は次のとおりです。SENT, DRAFT, TEMPLATE, TRIGGERED, FAILED, SCHEDULED

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062