CustomerGroups

Retrieves, creates, updates, deletes customer groups of a business.

Table Specific Information

The 本製品 uses the Square API to process search criteria that refer to the Id column, while other filters are processed client side within the 本製品.

Retrieve all CustomerGroups.

SELECT * from CustomerGroups

Retrieve a specific customer group as identified by the Id column.

SELECT * from CustomerGroups where id = '6Q87X9N44ACHCSX1NJSEQMAVAJ'

To create a customer group, you will need to specify the name value of the group.

INSERT INTO CustomerGroups(Name) values('TestName')

Modify the details of an existing Customer group by providing the Id of the Customer group.

UPDATE CustomerGroups SET Name = 'Name@01' where id = '6Q87X9N44ACHCSX1NJSEQMAVAJ'

Delete a customer group by providing the Id of the customer group.

DELETE from CustomerGroups where id = '2T3JZYXKYBV2YN48JSNXPKFAQF'


Name	Type	ReadOnly	Description
Id [KEY]	String	True	A unique Square-generated ID for the customer group.
Name	String	False	The name of the customer group.
CreatedAt	Datetime	True	The timestamp when the customer group was created, in RFC 3339 format.
UpdatedAt	Datetime	True	The timestamp when the customer group was last updated, in RFC 3339 format.