OrderEvents
Logs order lifecycle events such as creation, payment, fulfillment, and cancellation.
View-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following column and operators. The connector processes other filters client-side within the connector.
- HostId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM OrderEvents WHERE HostId = 'Val1'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally unique identifier for the event record. | |
| HostId | String |
Orders.Id | A globally unique identifier for the host system or process that generated the event. |
| AppTitle | String | The name of the application responsible for creating the event. | |
| AttributeToApp | Bool | Indicates whether the event was generated by an app rather than a manual or system action. | |
| AttributeToUser | Bool | Indicates whether the event was triggered by an admin user action. | |
| CreatedAt | Datetime | The date and time when the event was created. | |
| CriticalAlert | Bool | Indicates whether the event represents a critical alert requiring attention. | |
| Action | String | The type of action or operation represented by the event. | |
| Message | String | A human-readable message describing the event. | |
| BasicEventSubjectId | String | The unique identifier of the resource that generated the event. | |
| BasicEventSubjectType | String | The type of resource that generated the event, such as an order, product, or customer. | |
| BasicEventHasAdditionalContent | Bool | Indicates whether the event includes additional content beyond its main message. | |
| BasicEventAdditionalContent | String | Supplementary content associated with the event, typically displayed in expandable or detailed timeline views. | |
| BasicEventAdditionalData | String | Structured metadata or context information used by event consumers for processing or analytics. | |
| BasicEventSecondaryMessage | String | A secondary descriptive message providing further context for the main event message. | |
| BasicEventArguments | String | References to specific event arguments or linked resources relevant to the event. | |
| CommentEventAuthorId | String | The unique identifier of the staff member who authored the comment event. | |
| CommentEventCanDelete | Bool | Indicates whether the comment event can be deleted by the author or another authorized user. | |
| CommentEventCanEdit | Bool | Indicates whether the comment event can be edited by the author or another authorized user. | |
| CommentEventEdited | Bool | Indicates whether the comment event has been modified after its original creation. | |
| CommentEventRawMessage | String | The raw, unformatted message body of the comment event. | |
| CommentEventSubjectId | String | The unique identifier of the subject or resource to which the comment event is attached. | |
| CommentEventSubjectHasTimelineComment | Bool | Indicates whether the subject associated with this event includes timeline comments. | |
| CommentEventEmbedCustomerId | String | The unique identifier of the related customer object embedded in the comment event. | |
| CommentEventEmbedDraftOrderId | String | The unique identifier of the related draft order object embedded in the comment event. | |
| CommentEventEmbedOrderId | String | The unique identifier of the related order object embedded in the comment event. | |
| CommentEventEmbedProductId | String | The unique identifier of the related product object embedded in the comment event. | |
| CommentEventEmbedProductVariantId | String | The unique identifier of the related product variant object embedded in the comment event. |