Pages

Create, read, update or delete pages

Table-Specific Information

Select

The connector uses the Shopify API to process search criteria that refer to the Id, CreatedAt, Handle, PublishedAt, Title, UpdatedAt, PublishedStatus columns. The following queries are the only ones processed server-side:

SELECT * FROM Pages

SELECT * FROM Pages WHERE Id = '123'

SELECT * FROM Pages WHERE CreatedAt > '2018-05-02'

SELECT * FROM Pages WHERE Handle = 'test'

SELECT * FROM Pages WHERE PublishedAt <= '2018-05-02'

SELECT * FROM Pages WHERE Title = 'new title'

SELECT * FROM Pages WHERE UpdatedAt >= '2018-05-02'

SELECT * FROM Pages WHERE PublishedStatus >= 'published'

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	False		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.
PublishedStatus	String	False		Filter comments by their publish status. Valid values are: published, unpublished and any ; default: any.