Excel Add-In for Marketo

Build 24.0.9175

SmartListFilters

Query filters of smart lists in a Marketo organization.

Select

Note: Filters provided with one of the supported operators listed in the "Operators" column are processed server-side, all the other filters are processed client-side.

	SELECT * FROM SmartListFilters WHERE SmartListId='3560'

Columns

Name Type Operators Description
Id [KEY] Int Id of the smart list filter.
SmartListId Int = Id of the smart list.
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 Int The Id of the rule type.
FilterMatchType String The rule filter match type
Conditions String JSON aggregate of smart list filter conditions.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175