Views
Views are similar to tables in the way that data is represented; however, views are read-only.
Queries can be executed against a view as if it were a normal table.
CData JDBC Driver for BigCommerce Views
| Name | Description |
| Blogposts | Returns all Blog Posts. |
| BlogTags | Returns a list of Blog Tags. |
| CustomerGroups | Returns a list of Customer Groups. |
| DownloadConsignments | Returns consignments and their corresponding downloads. |
| EmailConsignments | Returns consignments and their corresponding emails. |
| GiftCertificates | Lists all gift certificates. |
| OrderCoupons | Lists all order coupons. |
| OrderItemOptionValues | Returns data from OrderItems table. |
| OrderMessages | Gets the messages associated with an order. |
| OrderRefunds | Returns a list of refunds. |
| OrderRefundsItems | List of Items refunded. |
| OrderRefundsPayments | Refund payments made to payment providers. |
| OrderShippingAddresses | Returns shipping addresses and their corresponding orders. |
| OrderStatuses | Returns order statuses. |
| OrderTaxes | Gets all order taxes related to an order. |
| Pages | Lists all pages. |
| PaymentMethods | Lists all payment methods. |
| PickupConsignments | Returns consignments and their corresponding pickups. |
| PriceListAssignments | Returns an array of Price List Assignments matching a particular Customer Group and Price List and Channel. |
| ProductBulkPricingRules | Returns bulk pricing rules applied to a product. |
| ProductCustomFields | Lists all tax classes. |
| ProductRules | Returns rules that modify the properties of a product, such as weight, price, and product image. |
| ProductSkus | Returns Stock Keeping Unit identifiers associated with products or product options. |
| ProductVariantValues | Returns data from Products table. |
| ProductVideos | Returns Embedded videos displayed on product listings. |
| Redirects | Lists all redirect URLs. |
| ShipmentItems | Returns data from Items within a shipment. |
| ShippingConsignmentQuotes | Gets all shipping quotes persisted on an order for a shipping consignment. |
| ShippingConsignments | Returns consignments and their corresponding shipping orders. |
| Stores | Lists all Stores. |
| TaxClasses | Lists all tax classes. |
| Transactions | Lists all transactions. |