CData Python Connector for Shopify

Build 23.0.8839

Returns

Retrieves a list of returns for the order.

Select

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

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

For example, the following queries are processed server side:

  SELECT * FROM Returns
  SELECT * FROM Returns WHERE OrdersId = 'Val1'

Insert

Insert statements are mapped to the 'returnCreate' GraphQL mutation.

The following columns can be used to create a new record:

OrdersId

The following pseudo-columns can be used to create a new record:

ReturnLineItems

Columns

Name Type ReadOnly References Description
Id [KEY] String True

A globally-unique ID.

OrdersId String True

Orders.Id

A globally-unique ID.

Name String True

The name of the return.

Status String True

The status of the return.

TotalQuantity Int True

The sum of all line item quantities for the return.

DeclineReason String True

The reason the customer's return request was declined.

DeclineNote String True

The notification message sent to the customer about their declined return request. Maximum length: 500 characters.

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
ReturnLineItems String

The list of the line items in the return.

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