Power BI Connector for Shopify

Build 24.0.9060

DiscountApplications

Query note attributes belonging to an order or draft order.

View-Specific Information

Select

The connector uses the Shopify API to process search criteria that refer to the OrderId and OrderUpdatedAt columns. The connector processes other filters client-side within the connector. For example, the following queries are processed server-side.
SELECT * FROM DiscountApplications WHERE OrderId = '1'

SELECT * FROM DiscountApplications WHERE OrderId IN ('1', '2')

SELECT * FROM DiscountApplications WHERE OrderUpdatedAt <= '2020-07-20 08:28:03.0'

SELECT * FROM DiscountApplications WHERE OrderUpdatedAt > '2020-07-20 08:28:03.0'

Columns

Name Type References Description
OrderId Long

Orders.Id

The id of the order.
OrderUpdatedAt Datetime The date and time when the order was last modified.
Type String The name of the note attribute.
Title String The value of the note attribute.
Description String The value of the note attribute.
Value String The value of the note attribute.
ValueType String The value of the note attribute.
AllocationMethod String The value of the note attribute.
TargetSelection String The value of the note attribute.
TargetType String The value of the note attribute.

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