Power BI Connector for Marketo

Build 23.0.8839

SmartListRuleFilters

Query SmartLists rule filters

Table Specific Information

Select

Note: All filterable columns must be specified using the '=' operator. Atleast one of SmartListId, SmartCampaignId or ProgramId is required to get the Rule Filters.

Retrieve rule filters for Smart Lists by SmartListId

SELECT * FROM SmartListRuleFilters WHERE SmartListId = 1143

SELECT * FROM SmartListRuleFilters WHERE SmartListId IN (SELECT Id FROM SmartLists)

Retrieve rule filters for Smart Lists by SmartCampaignId

SELECT * FROM SmartListRuleFilters WHERE SmartCampaignId = 1682

SELECT * FROM SmartListRuleFilters WHERE SmartCampaignId IN (SELECT Id FROM SmartCampaigns)

Retrieve rule filters for Smart Lists by ProgramId

SELECT * FROM SmartListRuleFilters WHERE ProgramId = 1089

SELECT * FROM SmartListRuleFilters WHERE ProgramId IN (SELECT Id FROM SmartCampaigns)

Columns

Name Type Filterable Description
Id [KEY] Integer The Id of the smart list rule filter.
Name String The name of the smart list rule filter.
Operator String The operator used in the filter.
RuleType String The type of the rule.
RuleTypeId Integer The Id of the rule type.
Conditions String The Rule filter conditions.
FilterMatchType String The rule filter match type
FilterCustomRuleLogic String The rule filter custom logic
SmartListId Integer True The ID of the Smart List
SmartListName String The Name of the Smart List
CreatedAt Datetime The date and time the smart list was created.
UpdatedAt Datetime The date and time the smart list was last updated.
WorkSpace String The name of the workspace where the smart list is located.
Url String The url of the smart list.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
SmartCampaignId Integer The Id of the smart campaign
ProgramId Integer The Id of the Program

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