Retrieves a list of customer tax data.

Table Specific Information

Select

The connector uses the BigCommerce API to process WHERE clause conditions built with the following columns and operators:

• CustomerId supports the = and IN comparisons.

The rest of the filter is executed client-side within the connector.

For example, the following queries are processed server-side:

SELECT * FROM TaxCustomers WHERE CustomerId = 157

Insert

TaxCustomers only supports an upsert-style write: inserting associates tax properties with a customer, creating the association if it does not yet exist or updating it if it does. Setting values is additive to any values already associated with the customer, overwriting values for matching keys. TaxProperties must be a JSON-formatted object of key-value pairs.

INSERT INTO TaxCustomers (CustomerId, TaxProperties) VALUES (157, '{"A-123456789":"26","B-6731789":"200"}')

Delete

DELETE FROM TaxCustomers WHERE CustomerId = 157

DELETE FROM TaxCustomers WHERE CustomerId IN (157,158)

Columns