Menus
Lists navigation menus used on the storefront.
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 globally unique Id for the menu. | |
| Title | String | False |
The title of the menu. | |
| Handle | String | False |
The handle of the menu. | |
| IsDefault | Bool | True |
Indicates whether the menu is a default. The handle for default menus can't be updated, and default menus can't be deleted. | |
| Items | String | False |
A list of the menu's items, sorted by position. |