Segmentations
Query segmentations for a Marketo organization.
Note: This table uses the draft/approved versioning API. By default both versions are retrieved/modified. To interact with a specific version use the filter Status='draft' or Status='approved'.
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 Segmentations WHERE Status='draft'
Columns
| Name | Type | Operators | Description |
| Id [KEY] | Int | Id of the segmentation. | |
| Status [KEY] | String | = | Status of the segmentation, draft or approved. |
| Name | String | Name of the segmentation. | |
| Description | String | Description of the segmentation. | |
| URL | String | Url of the segmentation in the Marketo UI. | |
| FolderId | Int | The unique, Marketo-assigned identifier of the parent folder/program. | |
| FolderName | String | The name of the folder | |
| FolderType | String | The type of folder (Folder,Program) | |
| WorkspaceName | String | Workspace Name of the asset. | |
| CreatedAt | Datetime | Datetime the segmentation was created. | |
| UpdatedAt | Datetime | Datetime the segmentation was most recently updated. |