Segments
Query segments 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 Segments WHERE SegmentationId=1001 AND Status='draft'
SELECT * FROM Segments WHERE SegmentationId=1001
Columns
| Name | Type | Operators | Description |
| Id [KEY] | Int | Id of the segment. | |
| Status [KEY] | String | = | Status of the segment, draft or approved. |
| SegmentationId | Int | = | Id of the segmentation. |
| Name | String | Name of the segment. | |
| Description | String | Description of the segmentation. | |
| URL | String | Url of the segmentation in the Marketo UI. | |
| CreatedAt | Datetime | Datetime segment form was created. | |
| UpdatedAt | Datetime | Datetime the segment was most recently updated. |