JDBC Driver for Shopify

Build 25.0.9434

ArticleEvents

Returns event history for articles, including publication, updates, and deletions.

View-Specific Information

Select

The driver uses the Shopify API to process WHERE clause conditions built with the following column and operators. The driver processes other filters client-side within the driver.

  • HostId supports the '=, IN' comparison operators.

For example, the following query is processed server-side:

  SELECT * FROM ArticleEvents WHERE HostId = 'Val1'

Columns

Name Type References Description
Id [KEY] String The globally unique identifier of the article event.
HostId String

Articles.Id

The globally unique identifier of the app or service that hosted the event.
AppTitle String The name of the app that generated the event.
AttributeToApp Bool Indicates whether the event was created by an app.
AttributeToUser Bool Indicates whether the event was triggered by an admin user.
CreatedAt Datetime The date and time when the event was created.
CriticalAlert Bool Indicates whether the event is flagged as critical.
Action String The type of action recorded for this event.
Message String Human-readable text describing the event.
BasicEventSubjectId String The identifier of the resource that generated the event.
BasicEventSubjectType String The type of resource that generated the event, such as an order or product.
BasicEventHasAdditionalContent Bool Indicates whether this event contains additional content.
BasicEventAdditionalContent String Additional content included for collapsible timeline events.
BasicEventAdditionalData String Supplementary event data available for consumers.
BasicEventSecondaryMessage String Secondary human-readable text that supports the main event message.
BasicEventArguments String Arguments or metadata linking the event to its related resources.
CommentEventAuthorId String The identifier of the staff member who authored the comment event.
CommentEventCanDelete Bool Indicates whether the comment event can be deleted.
CommentEventCanEdit Bool Indicates whether the comment event can be edited.
CommentEventEdited Bool Indicates whether the comment event has been edited after creation.
CommentEventRawMessage String The raw, unformatted body of the comment event.
CommentEventSubjectId String The identifier of the parent resource to which the comment event belongs.
CommentEventSubjectHasTimelineComment Bool Indicates whether the timeline subject includes an associated comment.
CommentEventEmbedCustomerId String The identifier of the customer resource embedded in the comment event.
CommentEventEmbedDraftOrderId String The identifier of the draft order resource embedded in the comment event.
CommentEventEmbedOrderId String The identifier of the order resource embedded in the comment event.
CommentEventEmbedProductId String The identifier of the product resource embedded in the comment event.
CommentEventEmbedProductVariantId String The identifier of the product variant resource embedded in the comment event.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434