JDBC Driver for BigCommerce

Build 22.0.8462

ChannelListings

Returns a list of all Channel Listings for a specific channel

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.

  • Listingid supports the '='.
  • ChannelId supports the '='.
  • Datecreated supports the '='.
  • Datemodified supports the '='.

ChannelId or (ChannelId and ListingId) are required for select. For example, the following queries are processed server side:

select * FROM ChannelListings WHERE ChannelId=667159 AND ListingId=882998595

Insert

To insert a new ChannelListings, you need to specify at least the following columns: Productid,State,Variants,ChannelId and Name with valid combinations

INSERT INTO ChannelListings (Productid,State,Variants,ChannelId) values(12345,'active','test',667159)

Update


UPDATE ChannelListings SET name ='Test' WHERE ChannelId=667159

Columns

Name Type ReadOnly Description
Listingid [KEY] Long True

The ID of the channel listing that has been created, returned, or updated

ChannelId Integer True

The ID of the channel associated with this channel listing

Datecreated Datetime True

Date on which the channel listing was first created

Datemodified Datetime True

Date on which the channel listing was most recently changed

Name String False

Name of the product for this channel listing specifically This is an optional field that can be used to override the product name in the catalog

Description String True

Description of the product for this channel listing specifically This is an optional field that can be used to override the product description in the catalog

Productid Integer False

The ID of the product associated with this channel listing

State String False

The state of the product assignment or channel listing

Variants String False

Varriatns

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