List of the shop's themes.

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 column can be used to create a new record:

Name

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.
ThemeStoreId	Int	True		The theme store ID.
Name	String	False		The name of the theme, set by the merchant.
Prefix	String	True		The prefix of the theme.
Processing	Bool	True		Whether the theme is processing.
ProcessingFailed	Bool	True		Whether the theme processing failed.
Role	String	True		The role of the theme.
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 a staged upload URL of the theme to import.