Power BI Connector for BigCommerce

Build 21.0.7930

PriceLists

Returns a collection of price records

Table Specific Information

Select

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'

Insert

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

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

Update

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

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

Delete

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

DELETE From PriceLists Where Id='4'

Columns

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