CustomerGroups

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

Table Specific Information

Select

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

Retrieve all CustomerGroups.

SELECT * from CustomerGroups

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

SELECT * from CustomerGroups where id = '6Q87X9N44ACHCSX1NJSEQMAVAJ'

Insert

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

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

Update

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

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

DELETE from CustomerGroups where id = '2T3JZYXKYBV2YN48JSNXPKFAQF'

Columns


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.