ReturnExchangeLineItems

Retrieves a list of line items in the associated resource.

View-Specific Information

Select

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

ResourceId supports the '=, IN' comparison operators.

For example, the following query is processed server-side:

  SELECT * FROM ReturnExchangeLineItems WHERE ResourceId = 'Val1'

Columns


Name	Type	References	Description
Id [KEY]	String		A globally-unique ID.
ResourceId	String	Returns.Id	A globally-unique ID.
Name	String		The title of the product, optionally appended with the title of the variant (if applicable).
Title	String		The title of the product at time of order creation.
VariantTitle	String		The title of the variant at time of order creation.
VariantId	String		A globally-unique ID.
ProductId	String		A globally-unique ID.
SellingPlanSellingPlanId	String		The ID of the selling plan associated with the line item.
Quantity	Int		The number of variant units ordered.
Restockable	Bool		Whether the line item can be restocked.
Sku	String		The variant SKU number.
Taxable	Bool		Whether the variant is taxable.
Vendor	String		The name of the vendor who made the variant.
CurrentQuantity	Int		The line item's quantity, minus the removed quantity.
MerchantEditable	Bool		Whether the line item can be edited or not.
RefundableQuantity	Int		The line item's quantity, minus the removed quantity.
RequiresShipping	Bool		Whether physical shipping is required for the variant.
UnfulfilledQuantity	Int		The number of units not yet fulfilled.
NonFulfillableQuantity	Int		The total number of units that can't be fulfilled. For example, if items have been refunded, or the item is not something that can be fulfilled, like a tip. Please see the object for more fulfillment details.
IsGiftCard	Bool		Whether the line item represents the purchase of a gift card.
DiscountedTotalSetPresentmentMoneyAmount	Decimal		Decimal money amount.
DiscountedTotalSetPresentmentMoneyAmountWithCodeDiscounts	Decimal		Decimal money amount.
DiscountedTotalSetPresentmentMoneyCurrencyCode	String		Currency of the money.
DiscountedTotalSetShopMoneyAmount	Decimal		Decimal money amount.
DiscountedTotalSetShopMoneyAmountWithCodeDiscounts	Decimal		Decimal money amount.
DiscountedTotalSetShopMoneyCurrencyCode	String		Currency of the money.
DiscountedUnitPriceSetPresentmentMoneyAmount	Decimal		Decimal money amount.
DiscountedUnitPriceSetPresentmentMoneyCurrencyCode	String		Currency of the money.
DiscountedUnitPriceSetShopMoneyAmount	Decimal		Decimal money amount.
DiscountedUnitPriceSetShopMoneyCurrencyCode	String		Currency of the money.
ImageId	String		A unique ID for the image.
ImageWidth	Int		The original width of the image in pixels. Returns 'null' if the image is not hosted by Shopify.
ImageAltText	String		A word or phrase to share the nature or contents of an image.
ImageHeight	Int		The original height of the image in pixels. Returns 'null' if the image is not hosted by Shopify.
ImageUrl	String		The location of the image as a URL.
OriginalTotalSetPresentmentMoneyAmount	Decimal		Decimal money amount.
OriginalTotalSetPresentmentMoneyCurrencyCode	String		Currency of the money.
OriginalTotalSetShopMoneyAmount	Decimal		Decimal money amount.
OriginalTotalSetShopMoneyCurrencyCode	String		Currency of the money.
OriginalUnitPriceSetPresentmentMoneyAmount	Decimal		Decimal money amount.
OriginalUnitPriceSetPresentmentMoneyCurrencyCode	String		Currency of the money.
OriginalUnitPriceSetShopMoneyAmount	Decimal		Decimal money amount.
OriginalUnitPriceSetShopMoneyCurrencyCode	String		Currency of the money.
TotalDiscountSetPresentmentMoneyAmount	Decimal		Decimal money amount.
TotalDiscountSetPresentmentMoneyCurrencyCode	String		Currency of the money.
TotalDiscountSetShopMoneyAmount	Decimal		Decimal money amount.
TotalDiscountSetShopMoneyCurrencyCode	String		Currency of the money.
UnfulfilledDiscountedTotalSetPresentmentMoneyAmount	Decimal		Decimal money amount.
UnfulfilledDiscountedTotalSetPresentmentMoneyCurrencyCode	String		Currency of the money.
UnfulfilledDiscountedTotalSetShopMoneyAmount	Decimal		Decimal money amount.
UnfulfilledDiscountedTotalSetShopMoneyCurrencyCode	String		Currency of the money.
UnfulfilledOriginalTotalSetPresentmentMoneyAmount	Decimal		Decimal money amount.
UnfulfilledOriginalTotalSetPresentmentMoneyCurrencyCode	String		Currency of the money.
UnfulfilledOriginalTotalSetShopMoneyAmount	Decimal		Decimal money amount.
UnfulfilledOriginalTotalSetShopMoneyCurrencyCode	String		Currency of the money.

Pseudo-Columns

Pseudo-columns are fields that can only be used in the types of statements under which they are explicitly listed. They are not standard columns but instead provide additional functionality for specific operations.


Name	Type	Description
AppliedDiscountValueAmount	Decimal		The discount to be applied to the exchange line item. The value of the discount as a fixed amount.
AppliedDiscountValueAmountCurrencyCode	String		The discount to be applied to the exchange line item. Currency of the money.
AppliedDiscountValuePercentage	Double		The discount to be applied to the exchange line item. The value of the discount as a percentage.
AppliedDiscountDescription	String		The discount to be applied to the exchange line item. The description of the discount.
GiftCardCodes	String		The gift card codes associated with the physical gift cards.

Power BI Connector for Shopify

ReturnExchangeLineItems

View-Specific Information

Select

Columns

Pseudo-Columns