Returns a list of Customer Segments.

Table Specific Information

Select

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

• Id supports the = and IN comparisons.

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

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

SELECT * FROM CustomerSegments WHERE Id = '3fa85f64-5717-4562-b3fc-2c963f66afa6'

Insert

To insert a customer segment, specify the Name column.

INSERT INTO CustomerSegments (Name, Description) VALUES ('VIP Customers', 'High value repeat customers')

Update

UPDATE CustomerSegments SET Description = 'Updated description' WHERE Id = '3fa85f64-5717-4562-b3fc-2c963f66afa6'

Delete

DELETE FROM CustomerSegments WHERE Id = '3fa85f64-5717-4562-b3fc-2c963f66afa6'
DELETE FROM CustomerSegments WHERE Id IN ('a931d436-7bd7-48d3-82ff-6f20969de82c', '262e6bd3-e0ff-4521-8d07-8fd29dc9afd5');

Columns