CData Python Connector for Shopify

Build 23.0.8839

Events

Retrieve events which have happened in your shop.

View-Specific Information

Select

The connector uses the Shopify API to process search criteria that refer to the Id, ProductId, OrderId, Verb, and CreatedAt columns. The supported SQL operators are '=' for the Id, ProductId, OrderId, and Verb columns and ">" and "<" for CreatedAt. The connector processes other filters client-side within the connector.

For example, the following queries are processed server-side:

SELECT * FROM Events WHERE Id = '123'

SELECT * FROM Events WHERE ProductId = '123'

SELECT * FROM Events WHERE OrderId = '123'

SELECT * FROM Events WHERE Verb = 'Confirmed'

SELECT * FROM Events WHERE CreatedAt > '2018-05-02' 

Columns

Name Type References Description
Id [KEY] Long The ID of the event.
Description String A human readable description of the event.
Message String A human readable description of the event. Can contain some HTML formatting.
Body String A text field containing information about the event.
Path String A relative URL to the resource the event is for, if applicable.
SubjectId Long The ID of the resource that generated the event.
SubjectType String he type of the resource that generated the event. Valid values: Article, Blog, Collection, Comment, Order, Page, Product, ApiPermission.
Verb String The type of event that occurred. Different resources generate different types of event.
Author String The author of the event.
Arguments String Refers to a certain event and its resources.
CreatedAt Datetime The date and time when the event was created.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements, to offer a more granular control over the tuples that are returned from the data source, or as parameters in INSERT statements.

Name Type Description
OrderId Long The ID of the Order to retrieve events from.
ProductId Long The ID of the Product to retrieve events from.

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