ODBC Driver for Shopify

Build 24.0.9060

CustomerEvents

Retrieves a paginated list of events associated with the host subject.

View-Specific Information

Select

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

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

For example, the following queries are processed server side:

  SELECT * FROM CustomerEvents
  SELECT * FROM CustomerEvents WHERE HostId = 'Val1'

Columns

Name Type References Description
Id [KEY] String A globally-unique ID.
HostId String

Customers.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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060