Power BI Connector for Shopify

Build 25.0.9454

Menus

Contains navigation menu structures for the storefront, including menu items, hierarchy, and target URLs.

Table-Specific Information

Select

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

  • Id supports the '=, IN' comparison operators.
  • Title supports the '=, !=' comparison operators.

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

  SELECT * FROM Menus WHERE Id = 'Val1'
  SELECT * FROM Menus WHERE Title = 'Val1'

Insert

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

Title, Handle, Items

Update

The following columns can be updated:

Title, Handle, Items

Delete

You can delete entries by specifying the following column:

Id

Columns

Name Type ReadOnly References Description
Id [KEY] String True

A unique identifier for the menu record.

Title String False

The display title of the menu, typically shown in navigation or storefront interfaces.

Handle String False

A unique, human-readable string used to reference the menu programmatically or through the API.

IsDefault Bool True

Indicates whether the menu is a default system menu. Default menus have fixed handles and cannot be deleted or renamed.

Items String False

An ordered list of menu items, arranged according to their defined positions within the menu.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454