JourneyHistory
Gives the history of a journey. Record access cannot exceed 10,000th item
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. | |
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 |