JourneyHistory
Gives the history of a journey. Record access cannot exceed 1gb 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 TransactionTime >= '2022-09-01T10:29:22.438Z' and TransactionTime <= '2022-09-30T11:29:22.438Z'
SELECT * FROM JourneyHistory where TransactionTime > '2022-09-01T10:29:22.438Z' and TransactionTime < '2022-09-30T11:29:22.438Z'
SELECT * FROM JourneyHistory where TransactionTime = '2022-09-01T10:29:22.438Z'
NOTE: Max 10k records can be retrieved using JourneyHistory. If only greater_equals or greater TransactionTime is mentioned it will retrieve maximum 10k records starting from that TransactionTime. If both greater_equals or greater and smaller_equals or smaller is mentioned, it will fetch the first 10k records.
Columns
| Name | Type | References | Description |
| Id | String | A unique identifier for this journeyhistory 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 | Activity name. | |
| ActivityType | String | Type of Activity | |
| ClientStatus | String | 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 | Definition Id | |
| DefinitionInstanceId | String | Definition Instance Id | |
| DefinitionName | String | Definition Name | |
| EndDate | Datetime | End date time value. | |
| EntrySource | String | The entry source. | |
| EpochTimeInMilliseconds | Long | Epoch Time In Milli Seconds | |
| EventId | String | Event Id | |
| EventName | String | Event Name | |
| LongId | String | Id | |
| Mid | String | MID | |
| Message | String | Message | |
| OutcomeActivityId | String | The outcome activity Id. | |
| ResultMessages | String | Messages | |
| ResultOutcomes | String | The result outcome. | |
| ResultStatus | String | Status | |
| ResultTags | String | Tags | |
| SourceType | String | The source type. | |
| StartDate | Datetime | Start date time. | |
| Status | String | Status of Journey History | |
| TransactionTime | Datetime | Transaction Time |