Teams
Query the available list of TeamMember for a business in Square.
Table Specific Information
Select
The connector 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 connector.
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. |