Stores static page content for the shop, such as About or FAQ pages, including titles and publication settings.

Table-Specific Information

Select

The connector uses the Shopify API to process WHERE clause conditions built with the following column and operators. The connector processes other filters client-side within the connector.

• Id supports the '=, IN' comparison operators.

For example, the following query is processed server-side:

  SELECT * FROM Pages WHERE Id = 'Val1'

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 identifier for the page record in Shopify.
Title	String	False		The title of the page as displayed in the online store and administrative interface.
Body	String	False		The full HTML-formatted content of the page, including text, links, and embedded media.
BodySummary	String	True		A text preview containing up to the first 150 characters of the page body. Longer content is truncated with an ellipsis for summary display.
Handle	String	False		A unique, human-readable identifier used to reference the page in Liquid templates and URLs.
TemplateSuffix	String	False		The optional suffix of the Liquid template file used to render this page, allowing for custom page layouts.
IsPublished	Bool	False		Indicates whether the page is currently visible to customers on the storefront.
PublishedAt	Datetime	False		The date and time when the page was or will be published to the storefront. Returns null if the page is unpublished.
UpdatedAt	Datetime	True		The timestamp of the most recent update to the page's content or metadata.
CreatedAt	Datetime	True		The timestamp of when the page was first created in Shopify.

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 Shopify should automatically redirect visitors from an old page handle to a new one after a handle change.
Metafields	String	A collection of additional metadata fields that extend the page's data model, used for custom attributes or integrations.