JourneyHistory
Gives the history of a journey
Table Specific Information
Select
Retrieves information about a specific contact, journey, or journey version.:
SELECT * FROM JourneyHistory
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A unique identifier for this journeyhistory that is generated and assigned by the journey API when the journey is in running state. | |
| ActivityBatchInstanceId | String | ActivityBatchInstanceId | |
| ActivityId | String | A unique identifier for this activity that is generated and assigned by the journey API when the activity is created. | |
| 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 | |
| EpochTimeInMilliseconds | Long | Epoch Time In Milli Seconds | |
| EventId | String | Event Id | |
| EventName | String | Event Name | |
| LongId | Integer | Id | |
| Message | String | Message | |
| Mid | Integer | MID | |
| ResultMessages | String | Messages | |
| ResultStatus | String | Status | |
| ResultTags | String | Tags | |
| Status | String | Status of Journey History | |
| TransactionTime | Datetime | Transaction Time |