JDBC Driver for BigCommerce

Build 24.0.9060

Pages

Lists all pages.

Table Specific Information

Select

The driver uses the BigCommerce API to process WHERE clause conditions built with Id, which supports the '=' comparison.

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

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

SELECT * FROM Pages WHERE Id = 1 

Columns

Name Type References Description
Id [KEY] Integer Id of the page.
ChannelId Integer

Channels.Id

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.
IsCustomersOnly Boolean Indicator if the page is customer only.
SearchKeywords String Search keywords of the page.
Url String Url of the page.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060