JDBC Driver for Shopify

Build 23.0.8839

ReturnLineItems

Retrieves the return line items attached to the return.

View-Specific Information

Select

The 本製品 uses the Shopify API to process WHERE clause conditions built with the Id column, which supports the '=' comparison operators.

The 本製品 processes other filters client-side within the 本製品.

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

SELECT * FROM ReturnLineItems WHERE ReturnId='VALUE'

Insert

INSERT statements are mapped to the 'priceListCreate' GraphQL mutation.

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

Quantity, ReturnReason, ReturnReasonNote, FulfillmentLineItemId

Columns

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

Returns.Id

A globally-unique ID.
Quantity Int The quantity being returned.
CustomerNote String A note from the customer that describes the item to be returned. Maximum length: 300 characters.
RefundableQuantity Int The quantity that can be refunded.
RefundedQuantity Int The quantity that was refunded.
ReturnReason String The reason for returning the item.
ReturnReasonNote String Additional information about the reason for the return. Maximum length: 255 characters.
TotalWeightUnit String The unit of measurement for `value`.
TotalWeightValue Double The weight value using the unit system specified with `unit`.
WithCodeDiscountedTotalPriceSetPresentmentMoneyAmount Decimal Decimal money amount.
WithCodeDiscountedTotalPriceSetPresentmentMoneyCurrencyCode String Currency of the money.
WithCodeDiscountedTotalPriceSetShopMoneyAmount Decimal Decimal money amount.
WithCodeDiscountedTotalPriceSetShopMoneyCurrencyCode String Currency of the money.
FulfillmentLineItemId String A globally-unique ID.

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