Returns

Retrieves a list of returns for the order.

Table-Specific Information

Select

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

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

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

OrdersId

The following pseudo-column 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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御したり、INSERT ステートメントのパラメータとして使用したりすることができます。