Power BI Connector for Act-On

Build 23.0.8839


Query the available images on your ActOn account.

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

  • FolderName supports the '=' and 'IN' operators.

For example, the following queries are processed server side:

SELECT * FROM Images WHERE FolderName = 'New Folder'
SELECT Name, FolderName FROM Images WHERE FolderName IN ('New Folder', 'Default Folder')


Name Type Description
Id [KEY] String Id of the image.
FolderName String Name of the folder that contains the image.
Name String Name of the image.
CreationTime Datetime When the image was created.
LastModified Datetime When the image was last modified.
ImageUrl String Link to the image.
ThumbUrl String Link to the image.
Size Int Size of the image.


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

Name Type Description
Type String Identifier for the next page of results. Do not set this value manually.

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