Power BI Connector for Act-On

Build 24.0.9062

OtherLists

Query the hardbounce, spam complaint and optout lists on ActOn. This view has been deprecated.

View Specific Information

To query data from this view, you must specify Type.
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.
  • CreatedAfter supports the '=' operator.
  • CreatedBefore supports the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM [OtherLists] WHERE Type = 'OPTOUT'
SELECT * FROM [OtherLists] WHERE Type = 'OPTOUT' AND CreatedAfter = '2018-08-28T14:37:48.923+02:00' AND CreatedBefore = '2018-08-28T14:37:48.925+02:00'
SELECT * FROM [OtherLists] WHERE Type = 'HARDBOUNCE' AND CreatedBefore = '2019-09-28T14:39:48.924+02:00'

Columns

Name Type Description
Email String Email of the user.
Timestamp Datetime When the user joined the list.
Origin String
Type String The type of list.

使用できる値は次のとおりです。HARDBOUNCE, SPAMCOMPLAINT, OPTOUT

Pseudo-Columns

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

Name Type Description
CreatedBefore String Only records created before the supplied value will be returned.
CreatedAfter String Only records created after the supplied value will be returned.

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