Update records in custom dataset

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.

Language
Credentials
Click Try It! to start a request and see the response here!