Need to update custom columns in a default table?
Here’s the structure you’ll want to use:
In this example, we’re updating the Variable Pay table, including a custom column (% Variable pay) by referencing its internal column ID.
{ "amount": { "value": 1234, "currency": "GBP" }, "effectiveDate": "2025-01-01", "paymentPeriod": "Annual", "variableType": "Commission", "customColumns": { "column_1667577226833": 11}}
We can confirm the correct structure by using this endpoint: List employee's variable payments
This response includes the internal ID and value, which can be used to verify your update or troubleshoot any issues:
