On knack.com there is currently only support for select and insert.
Do you want to support this idea for improving Invantive software? Please register/log on first, then add a vote by clicking on the “Vote” button directly to the left of the title above or add a reply.
The Knack APIs for update and delete have been implemented across all Knack.com data types and are available starting release 20.1.267 BETA.
Please note that the Knack API enables you to nullify fields defined as required. To compensate for this, fields that seem required after still reported in SystemTableColumns@DataDictionary as nullable.
Few Knack API calls are needed to update the Knack-database especially when combined with the synchronize statement. However, with low cost plans the daily allowance of API calls can still be prohibitive. The RateLimits view in the Knack data dictionary reports actual status of your Knack API usage in relationship to your plan.