Excel Add-In for Square

Build 24.0.9062

Teams

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

Table Specific Information

Select

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 本製品.

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.
Email String The email address of the team member.
Status String Whether the team member is ACTIVE or INACTIVE.

使用できる値は次のとおりです。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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062