OrderEvents
Retrieves a paginated list of events associated with the host subject.
View-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the HostId column, which supports the '=' comparison operator.
The connector processes other filters client-side within the connector.
For example, the following query is processed server-side:
SELECT * FROM OrderEvents WHERE HostId='VALUE'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally-unique ID. | |
| HostId | String |
Orders.Id | A globally-unique ID. |
| AppTitle | String | The name of the app that created the event. | |
| AttributeToApp | Bool | Whether the event was created by an app. | |
| AttributeToUser | Bool | Whether the event was caused by an admin user. | |
| CreatedAt | Datetime | The date and time when the event was created. | |
| CriticalAlert | Bool | Whether the event is critical. | |
| Message | String | Human readable text that describes the event. | |
| CommentEventAuthorId | String | The id of the staff member that authored the comment event. | |
| CommentEventCanDelete | Bool | Whether the comment event can be deleted. If true, then the comment event can be deleted. | |
| CommentEventCanEdit | Bool | Whether the comment event can edited. If true, then the comment event can be edited. | |
| CommentEventEdited | Bool | Whether the comment event has been edited. If true, then the comment event has been edited. | |
| CommentEventRawMessage | String | The raw body of the comment event. | |
| CommentEventSubjectId | String | The parent subject to which the comment event belongs. | |
| CommentEventEmbedCustomerId | String | The object reference associated with the comment event. | |
| CommentEventEmbedDraftOrderId | String | The object reference associated with the comment event. | |
| CommentEventEmbedOrderId | String | The object reference associated with the comment event. | |
| CommentEventEmbedProductId | String | The object reference associated with the comment event. | |
| CommentEventEmbedProductVariantId | String | The object reference associated with the comment event. |