Lists the shop's themes with role and preview data.

Table-Specific Information

Select

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

• Id supports the '=, IN' comparison operators.
• Name supports the '=, IN' comparison operators.
• Role supports the '=, IN' comparison operators.

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

  SELECT * FROM Themes WHERE Id = 'Val1'
  SELECT * FROM Themes WHERE Name = 'Val1'
  SELECT * FROM Themes WHERE Role = 'Val1'

Insert

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

Name, Role

The following pseudo-column can be used to create a new record:

Source

Update

The following column can be updated:

Name

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 theme.
ThemeStoreId	Int	True		The Id of the theme in the Shopify Theme Store.
Name	String	False		The name of the theme, set by the merchant.
Prefix	String	True		The prefix assigned to the theme.
Processing	Bool	True		Indicates whether the theme is currently processing.
ProcessingFailed	Bool	True		Indicates whether the theme processing failed.
Role	String	True		The role of the theme (for example, main, unpublished, or demo).
UpdatedAt	Datetime	True		The date and time when the theme was last updated.
CreatedAt	Datetime	True		The date and time when the theme was created.

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
Source	String	An external URL or staged upload URL for importing the theme.