Query the available list of TeamMember for a business in Square.
Table Specific Information
The 本製品 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 本製品. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will have an unfiltered response.
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'
|Id [KEY]||String||The Id of the team member.|
|FirstName||String||The first name of the team member.|
|LastName||String||The last name of the team member.|
|String||The email address of the team member.|
|Status||String||Whether the team member is ACTIVE or INACTIVE.
|CreatedAt||Datetime||The time when the team member entity was created.|
|UpdatedAt||Datetime||The time when the team member entity was last updated.|
|PhoneNumber||String||The phone number of the team member.|
|ReferenceId||String||A second ID used to associate the team member with an entity in another system.|
|IsOwner||Boolean||Whether the team member is the owner of the Square account.|
|AssignmentType||String||The current assignment type of the team member.|
|LocationId||String||The locations that the team member is assigned to.|