CData Python Connector for BigCommerce

Build 21.0.7930


Gets the messages associated with an order.

Table Specific Information


The provider 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 provider.

  • Id supports the '=, <=, <, >=, >' comparison.
  • OrderId supports the '=' comparison.
  • CustomerId supports the '=' comparison.
  • Status supports the '=' comparison.
  • IsFlagged supports the '=' comparison.
  • DateCreated supports the '=, <=, <, >=, >' comparison.

For example, the following queries are processed server side:

SELECT * FROM OrderMessages

SELECT * FROM OrderMessages WHERE Id = 1 

SELECT * FROM OrderMessages WHERE OrderId = 2

SELECT * FROM OrderMessages WHERE IsFlagged = "true"

SELECT * FROM OrderMessages WHERE DateCreated >= "2019-01-01" AND DateCreated <= "2020-01-01"


Name Type Description
Id [KEY] Integer Numeric ID of this product within this order.
OrderId Integer Numeric ID of the associated order.
StaffId Integer The staff id.
CustomerId Integer The customer id.
Type String Type of the message.
Subject String Subject of the message.
Message String Message content.
Status String Status of the message.
IsFlagged Boolean Indicator if the message is flagged.
DateCreated Datetime Datetime when the message was first created.

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