WageSettings
(Beta) Retrieve and update the wage setting for a Square team member. Requires filtering by TeamMemberId.
Table Specific Information
Select
The add-in 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 add-in.
- 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. |