Pages
Create, read, update or delete pages
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 Pages
SELECT * FROM Pages 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 the Title to create a Page.
INSERT INTO Pages(title) VALUES ('new Page')
Update
You must specify the id to update a Page. For example:
UPDATE Pages SET author='Harry' WHERE Id = '77171130'
Delete
You must specify the Id of the Page to delete it.
DELETE FROM Pages WHERE Id = '555695'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | Long | True |
The unique numeric identifier for the page. | |
AdminGraphqlApiId | String | True |
Displays the Admin Graphql API id. | |
Author | String | False |
The name of the person who created the page. | |
BodyHtml | String | False |
The text content of the page, complete with HTML markup. | |
CreatedAt | Datetime | True |
The date and time (ISO 8601 format) when the page was created. | |
Handle | String | False |
A unique, human-friendly string for the page, generated automatically from its title. In online store themes, the Liquid templating language refers to a page by its handle. | |
Metafields | String | True |
Additional information attached to the Page object. | |
PublishedAt | Datetime | False |
The date and time (ISO 8601 format) when the page was published. Returns null when the page is hidden. | |
ShopId | Long | True |
The ID of the shop to which the page belongs. | |
TemplateSuffix | String | False |
The suffix of the Liquid template being used. | |
Title | String | False |
The page's title. | |
UpdatedAt | Datetime | True |
The date and time (ISO 8601 format) when the page was last updated. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
published_status | String |
Filter comments by their publish status. Valid values are: published, unpublished and any ; default: any. |