post https://slemma.com/api/v1/data/
Update chosen records (rows) in a dataset by passing an array of pairs (Row and NewValues) of key-value pair objects representing a record in your dataset. As a result, values in the dataset row fully matching the Row are replaced with values from NewValues object. You can update multiple records by passing multiple pairs.
The following are the examples of HTTP status codes including errors that API can generate
Response codes | Response content | Description |
---|---|---|
200 OK | { "RowsUpdated": 2 } | Everything worked correctly. |
400 Bad Request | You need to set all field values in every passed row | If you fail to specify one or more field values in the request body. |
400 Bad Request | Incorrect value '2016-1103 00:00:00.0' for field 'Start Date'. User the date format: 'yyyy-MM-dd HH:mm:ss.S' | If you specify incorrect date format. |
400 Bad Request | Field 'Example_Field' not found | The passed field is not present in the dataset. |
400 Bad Request | Body cannot be empty | The request body is empty. |
400 Bad Request | Limit exceeded upload rows = 10000 | The request body contains more than 10000 rows. |
403 Forbidden | Access denied | Access to the dataset is denied. |
404 Not Found | Object not found | Dataset not found. |
Note
Make sure that the values you are passing match the field types defined for your dataset schema. The number of fields you are passing should also completely match the number of fields in your dataset schema.
Rate Limits
Records per request
Slemma supports up to 10000 records per request.