Query the available list of TeamMember for a business in Square.

Table Specific Information

Select

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

Retrieve a specific team member:

SELECT * FROM Teams WHERE Id = '1ccaibDk3FapStf997Qi'

Retrieve the team member for a specific location:

SELECT * FROM Teams WHERE LocationId = ' 92BYHNBR6W77E'

Retrieve list of team members for specified locations:

SELECT * FROM Teams WHERE LocationId IN ('92BYHNBR6W77E', '92BYHNBR6W77EABCD', '92BYHNBR6W77EABCDEFGH')

Retrieve list of Active team members:

SELECT * FROM Teams WHERE Status = 'ACTIVE'

Retrieve list of Active team members in a given location:

SELECT * FROM Teams WHERE LocationId = '92BYHNBR6W77E' AND Status = 'ACTIVE'

Insert

To create a Team, you will need to specify IdempotencyKey and FirstName or LastName.

INSERT INTO Teams (IdempotencyKey, FirstName) VALUES ('b741f5a5-c041-4bd6-9e79-dfefcf69c4b7','testing')

UPDATE

A Team can be updated by providing the Id.

UPDATE teams set FirstName='testteams' where id='TMiAkBLr8BOrtOCr'

BULKUPDATE

A Team can be Bulk updated by providing the Id.

INSERT INTO Teams#TEMP (FirstName,LastName,Id) VALUES ('UpdatedFirstName1','UpdatedLastName1','TMD64VkEfI47Vm3G')

INSERT INTO Teams#TEMP (FirstName,LastName,Id) VALUES ('UpdatedFirstName2','UpdatedLastName2','TMHxLjeRSHhwzx3T')

UPDATE Teams (FirstName,LastName,Id) SELECT FirstName, LastName,Id FROM Teams#TEMP

Columns

Name	Type	ReadOnly	Description
Id [KEY]	String	False	The Id of the team member.
FirstName	String	False	The first name of the team member.
LastName	String	False	The last name of the team member.
Email	String	False	The email address of the team member.
Status	String	False	Whether the team member is ACTIVE or INACTIVE. The allowed values are ACTIVE, INACTIVE.
CreatedAt	Datetime	False	The time when the team member entity was created.
UpdatedAt	Datetime	False	The time when the team member entity was last updated.
PhoneNumber	String	False	The phone number of the team member.
ReferenceId	String	False	A second ID used to associate the team member with an entity in another system.
IsOwner	Boolean	False	Whether the team member is the owner of the Square account.
AssignmentType	String	False	The current assignment type of the team member.
LocationId	String	False	The locations that the team member is assigned to.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
IdempotencyKey	String	A unique string that identifies this CreatePayment request. Keys can be any valid string but must be unique for every CreatePayment request.