Themes
Create, read, update or delete themes
Table-Specific Information
Select
The driver processes all filters client-side within the driver. The following queries are the only ones processed server side:
SELECT * FROM Themes
SELECT * FROM Themes WHERE Id='123'
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.
Insert
You must specify name to create a Theme.
INSERT INTO Themes(name) VALUES ('NewTheme')
Update
You must specify the id to update a Theme. For example:
UPDATE Themes SET name='NewTheme' WHERE Id = '77171130'
Delete
You must specify the Id of the Theme to delete it.
DELETE FROM Themes WHERE Id = '555695'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | Long | True |
A unique numeric identifier for the theme. | |
AdminGraphqlApiId | String | True |
Displays the Admin Graphql API id. | |
CreatedAt | Datetime | True |
The date and time (ISO 8601 format) when the theme was created. | |
Name | String | False |
The name of the theme. | |
Previewable | Boolean | True |
Whether the theme can currently be previewed. | |
Processing | Boolean | True |
Whether files are still being copied into place for this theme. | |
Role | String | False |
Specifies how the theme is being used within the shop. The allowed values are main, published, demo. | |
ThemeStoreId | Long | True |
A unique identifier applied to Shopify-made themes that are installed from the Shopify Theme Store Theme Store. | |
UpdatedAt | Datetime | True |
The date and time ( ISO 8601 format) when the theme was last updated. |