Update records in a database table
where
conditions. This endpoint allows you to modify existing records in your database by specifying which records to update and what data to change.
users
, products
, or orders
.{"id": "123", "status": "inactive"}
will update only records where both the ID is “123” AND the status is “inactive”.{"status": "active", "last_login": "2025-08-01T12:00:00Z"}
will set the status field to “active” and the last_login field to the specified timestamp.true
if the update was successful, false
otherwise.Error | Cause | Solution |
---|---|---|
”Table not found” | The specified table doesn’t exist | Check your table name for typos |
”No records matched the update criteria” | Your where conditions didn’t match any records | Verify your where conditions are correct |
”Missing required field” | You didn’t provide a required parameter | Make sure you include table, where, and data fields |
”Unauthorized” | Invalid or missing API key | Check that you’re using a valid API key |