JourneyHistory
Retrieves the history of a journey. Record access cannot exceed 1 GB of file size data.
Table Specific Information
Select
Retrieves information about a specific contact, journey, or journey version:
SELECT * FROM JourneyHistory
Retrieves information about a specific contact, journey, or journey version within the specified date range.:
SELECT * FROM JourneyHistory where StartDate='2022-09-01T10:29:22.438Z' and EndDate = '2022-09-30T11:29:22.438Z'
NOTE: A maximum of 10k records can be retrieved using JourneyHistory. If only StartDate is mentioned, it will retrieve a maximum of 10k records from the StartDate. If both StartDate and EndDate are mentioned, it will fetch the first 10k records.
Columns
| Name | Type | References | Description |
| Id | String | A unique identifier for this journey history that is generated and assigned by the journey API when the journey is in running state. | |
| ActivityId | String | A unique identifier for this activity that is generated and assigned by the journey API when the activity is created. | |
| ActivityName | String | The activity name. | |
| ActivityType | String | The type of activity. | |
| ClientStatus | String | The client status. | |
| ContactKey | String | The customer key (also a unique identifier within the MID) for this journey. | |
| CreatedDate | Datetime | The datetime when the journey was created. | |
| DefinitionId | String | The definition Id. | |
| DefinitionInstanceId | String | The definition instance Id. | |
| DefinitionName | String | The definition name. | |
| EndDate | Datetime | The end datetime value. | |
| EntrySource | String | The entry source. | |
| EpochTimeInMilliseconds | Long | The epoch time in milliseconds. | |
| EventId | String | The event Id. | |
| EventName | String | The event name. | |
| LongId | String | The long Id. | |
| Mid | String | The Marketing Cloud member Id (MID). | |
| Message | String | The message. | |
| OutcomeActivityId | String | The outcome activity Id. | |
| ResultMessages | String | The result messages. | |
| ResultOutcomes | String | The result outcomes. | |
| ResultStatus | String | The result status. | |
| ResultTags | String | The result tags. | |
| SourceType | String | The source type. | |
| StartDate | Datetime | The start datetime value. | |
| Status | String | The status of the journey history. | |
| TransactionTime | Datetime | The transaction datetime. |