Lists booking profiles for team members.

Table Specific Information

Select

The add-in uses the Square API to filter the results by the following column and operators while the rest of the filter is executed client-side within the add-in.

• TeamMemberId supports the following operators: =, IN.

Retrieve all the booking profiles for team members.

SELECT * FROM TeamMemberBookingProfiles

Retrieve a particular team member's booking profile.

SELECT * FROM TeamMemberBookingProfiles WHERE TeamMemberId = '_77Nq6SzK0cH2YRX-q9a'

Retrieve the profiles for several team members at once by supplying their Ids with IN. The add-in sends these to the Square bulk retrieve endpoint, so the list is served by a single request rather than one request per team member. The maximum BatchSize supported by TeamMemberBookingProfiles is 10, and a longer list is split across as many requests as needed. Note that = does not use this endpoint; a single-Id filter is answered by the per-team-member request instead. An Id that does not match a booking profile is omitted from the results rather than reported as an error.

SELECT TeamMemberId, DisplayName, IsBookable FROM TeamMemberBookingProfiles WHERE TeamMemberId IN ('TMaJcbiRqPIGZuS9', 'TMtdegug1fqni3wh')

Columns