Teams
Query the available list of TeamMember for a business in Square.
Table Specific Information
Select
The add-in 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 add-in.
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'
Columns
| Name | Type | Description |
| 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.
The allowed values are ACTIVE, 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. |