LifecycleStages
Retrieving a collection of lifecycle stages
Table Specific Information
Select
The connector will use the Salesforce Marketing Cloud Account Engagement API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the connector.
- Id supports '=', '<', '<=', '>', '>=', 'IN'.
- IsDeleted supports '='.
- CreatedAt supports '=', '<', '<=', '>', '>='.
- UpdatedAt supports '=', '<', '<=', '>', '>='.
For example, the following queries are processed server side:
SELECT * FROM LifecycleStages WHERE Id = 50 SELECT * FROM LifecycleStages WHERE IsDeleted = 'true' SELECT * FROM LifecycleStages WHERE CreatedAt > '01/01/2022'
GetDeleted
To retrieve LifecycleStages that are in the recycle bin in Pardot the following operation is supported:
GETDELETED FROM LifecycleStages
Columns
| Name | Type | References | Description |
| Id [KEY] | Int64 | ID of the lifecycle stage. | |
| Name | String | Pardot ID of this lifecycle stage. | |
| IsDeleted | Boolean | True if the lifecycle stage is in the recycle bin in Pardot. | |
| CreatedAt | Datetime | Creation time of the lifecycle stage. | |
| UpdatedAt | Datetime | Last updated time for the lifecycle stage. | |
| IsLocked | Boolean | When true, lifecycle stage is locked. | |
| Position | Int | Lifcycle stage's position in lifecycle. | |
| MatchType | String | Match all is returned when a prospect must match all rules in order to be in this stage. Match any is returned when a prospect can match 1 or more rules |