Power BI Connector for Shopify

Build 24.0.9060

NoteAttributes

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 supported SQL operators are '=' for OrderId and '>' and '<' for OrderUpdatedAt. The connector processes other filters client-side within the connector. For example, the following queries are processed server-side.
SELECT * FROM NoteAttributes WHERE OrderId = '123'

SELECT * FROM NoteAttributes WHERE OrderUpdatedAt > '2018-05-05'

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.
Name String The name of the note attribute.
Value String The value of the note attribute.

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