Returns a list of Customer Attribute.

Table Specific Information

Select

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

• Name supports the = and LIKE comparisons.
• Type supports the = comparison.
• DateCreated supports the =, <, and > comparisons.
• DateModified supports the =, <, and > comparisons.

Id does not support server-side filtering for Select, but the = and IN comparisons can be used with Id in a DELETE statement.

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

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

SELECT * FROM CustomerAttributes WHERE Type = 'number'

SELECT * FROM CustomerAttributes WHERE Name LIKE '%Age%'

Insert

To insert a customer attribute, specify the Name and Type columns. Note: The Type cannot be changed after the attribute is created.

INSERT INTO CustomerAttributes (Name, Type) VALUES ('Age', 'number')

Update

UPDATE CustomerAttributes SET Name = 'CustomerAge' WHERE Id = 1

Delete

DELETE FROM CustomerAttributes WHERE Id = 1
DELETE FROM CustomerAttributes WHERE Id IN (4,3)

Columns