WageSettings
(Beta) Retrieve and update the wage setting for a Square team member. Requires filtering by TeamMemberId.
Table Specific Information
Select
The connector uses the Square API to filter the results by the following columns and operators while the rest of the filter is executed client-side within the connector.
- TeamMemberId supports the following operator: =.
Retrieve the wage setting for a specific team member:
SELECT * FROM WageSettings WHERE TeamMemberId = 'TMpveKF7plf5H7eZ'
Update
Modify the wage settings for a team member by providing the TeamMemberId:
UPDATE WageSettings SET IsOvertimeExempt = true, JobAssignments = '[{"job_title": "Manager", "pay_type": "SALARY", "annual_rate": {"amount": 60000, "currency": "USD"}}]' WHERE TeamMemberId = 'TMpveKF7plf5H7eZ'
Columns
| Name | Type | ReadOnly | Description |
| TeamMemberId [KEY] | String | True |
The ID of the team member for which to retrieve or update the wage setting. |
| JobAssignments | String | False |
The team member job assignments. Each JobAssignment contains job_title, pay_type (required), hourly_rate, annual_rate, weekly_hours, and job_id (Beta). |
| IsOvertimeExempt | Boolean | False |
Indicates whether the team member is exempt from overtime. |
| Version | Integer | False |
The current version of the WageSetting. Used for optimistic concurrency control. The request fails if the version does not match the server version. |
| CreatedAt | Datetime | True |
The timestamp when the wage setting was created, in RFC 3339 format. |
| UpdatedAt | Datetime | True |
The timestamp when the wage setting was last updated, in RFC 3339 format. |