Pages
Create, read, update or delete pages
Table-Specific Information
Select
The adapter processes all filters client-side within the adapter. The following queries are the only ones processed server side:
SELECT * FROM Pages
SELECT * FROM Pages WHERE Id='123'
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. |