Power BI Connector for BigCommerce

Build 21.0.7930


Returns a collection of price records

Table Specific Information


The {i 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 {i.

  • Id supports the '=' comparison.
  • DateCreated supports the '=' comparison.
  • DateModified supports the '=' comparison.
  • Name supports the '=,LIKE' comparison.

For example, the following queries are processed server side:

SELECT * FROM PriceLists

SELECT * FROM PriceLists WHERE Id = 1 

SELECT * FROM PriceLists WHERE DateCreated='2021-05-26'

SELECT * FROM PriceLists where DateModified='2021-05-26'

SELECT * FROM PriceLists where Name LIKE 'Wholesale group1'


To insert a new PriceList, you need to specify the following columns: Name and Active

INSERT INTO PriceLists (Name,Active) VALUES ('Wholesalegroup',false)


To Update the PriceList, you need to specify the following columns: Name and ID

Update PriceLists Set Name='Wholesalegroup' Where Id='4'


To Delete the PriceList, you need to specify the following columns:ID

DELETE From PriceLists Where Id='4'


Name Type ReadOnly Description
Id [KEY] Integer True

ID of the PriceList.

Active Boolean False

The status of the PriceList.

DateCreated Datetime True

The date of creation for the PriceList.

DateModified Datetime True

The last modification date of the PriceList.

Name String False

The name of the PriceList.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930