JDBC Driver for BigCommerce

Build 22.0.8462

Pages

Lists all pages.

Table Specific Information

Select

The driver will use the BigCommerce API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the driver.

  • Id supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM Pages

SELECT * FROM Pages WHERE Id = 1 

Columns

Name Type Description
Id [KEY] Integer Id of the page.
ChannelId Integer Channel Id of the page.
Name String Name of the page.
Email String Email of the page.
MetaTitle String Title of the page.
Body String Body of the page.
IsVisible Boolean Indicator if page is visible.
ParentId Integer Parent id of the page.
SortOrder Integer Sort order of the page.
MetaKeywords String Keywords of the page.
Type String Type of the page.
MetaDescription String Description of the page.
IsHomepage Boolean Indicator if the page is homepage.
LayoutFile String Layout file of the page.
IsCustomersOnly Boolean Indicator if the page is customer only.
SearchKeywords String Search keywords of the page.
HasMobileVersion Boolean Indicator if the page is mobile supported.
MobileBody String Mobile body of the page.
Url String Url of the page.
DateCreated Datetime Date when the page was created.
Feed String Feed of the page.
Link String Link of the page.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462