Lists the shop's informational pages used on the storefront.

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.
• IsPublished supports the '=, !=' comparison operators.
• PublishedAt supports the '=, !=, <, >, >=, <=' comparison operators.

For example, the following queries are processed server-side:

  SELECT * FROM Pages WHERE Id = 'Val1'
  SELECT * FROM Pages WHERE IsPublished = true
  SELECT * FROM Pages WHERE PublishedAt = '2023-01-01 11:10:00'

Insert

The following columns can be used to create a new record:

Title, Body, Handle, TemplateSuffix, IsPublished, PublishedAt

The following pseudo-column can be used to create a new record:

Metafields (references Metafields)

Metafields Temporary Table Columns

Column Name	Type	Description
Id	String	The unique ID of the metafield.
Namespace	String	A container for a set of metafields. You need to define a custom namespace for your metafields to distinguish them from the metafields used by other apps.
Key	String	The name of the metafield.
Value	String	The information to be stored as metadata.
Type	String	The metafield's information type.

Update

The following columns can be updated:

Title, Body, Handle, TemplateSuffix, IsPublished, PublishedAt

The following pseudo-columns can be used to update a record:

RedirectNewHandle, Metafields (references Metafields)

Metafields Temporary Table Columns

Column Name	Type	Description
Id	String	The unique ID of the metafield.
Namespace	String	A container for a set of metafields. You need to define a custom namespace for your metafields to distinguish them from the metafields used by other apps.
Key	String	The name of the metafield.
Value	String	The information to be stored as metadata.
Type	String	The metafield's information type.

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.
Title	String	False		The title of the page.
Body	String	False		The text content of the page, including HTML markup.
BodySummary	String	True		The first 150 characters of the page body. If the page body exceeds 150 characters, additional text is truncated with ellipses.
Handle	String	False		A unique, human-friendly string for the page. In themes, the Liquid templating language refers to a page by its handle.
TemplateSuffix	String	False		The suffix of the template used to render the page.
IsPublished	Bool	False		Indicates whether the page is visible.
PublishedAt	Datetime	False		The date and time when the page became visible. Returns null when the page isn't visible.
UpdatedAt	Datetime	True		The date and time when the page was last updated.
CreatedAt	Datetime	True		The date and time when the page 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
RedirectNewHandle	Bool	Indicates whether a redirect is required after a new handle has been provided. If true, the old handle is redirected to the new one automatically.
Metafields	String	The input fields used to create or update a metafield.