Pages

Returns pages, including content, metadata, and visibility details.

Table-Specific Information

The connector uses the BigCommerce API to process WHERE clause conditions built with the Id column, which supports the = operator.

The rest of the filter is executed client-side within the connector.

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

SELECT * FROM Pages WHERE Id = 1

To insert a page, specify at least the following column: Type.

INSERT INTO Pages (Type, Name, MetaTitle) VALUES ('page', 'demo page 1', 'test title')

The following is an example of how to update the Pages table:

UPDATE Pages SET Name = 'Updated -> test from demo', IsVisible = True, IsHomePage = True, MetaDescription = 'test_MetaDescription' WHERE Id = 283

The following is an example of how to delete from the Pages table:

DELETE FROM Pages WHERE Id = 284


Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	The unique identifier of the page.
ChannelId	Integer	False	The Id of the channel associated with the page.
Name	String	False	The name of the page.
Email	String	False	The email address associated with the page.
MetaTitle	String	False	The meta title of the page, used for SEO purposes.
Body	String	False	The HTML body content of the page.
IsVisible	Boolean	False	Indicates whether the page is visible on the storefront.
ParentId	Integer	False	The Id of the parent page.
SortOrder	Integer	False	The position of the page in the sort order.
MetaKeywords	String	False	The meta keywords associated with the page for SEO purposes.
Type	String	False	The type of the page.
MetaDescription	String	False	The meta description of the page, used for SEO purposes.
IsHomepage	Boolean	False	Indicates whether the page is set as the homepage.
IsCustomersOnly	Boolean	False	Indicates whether the page is visible only to logged-in customers.
SearchKeywords	String	False	The search keywords associated with the page.
Url	String	False	The URL of the page.