Deletes data based on a filter and then updates existing row or inserts new row in data set specified by ID.
|ID of the data set to modify data in. You can find the ID in the response to ||123|
One data row in JSON format with following definition:
Filter used to delete data.
Prefix (PT) can be used when join contains columns with the same names.
See the complete list of Filter operation types.
conditionType (optional) is used to define condition operator between conditions. Available values:
Searching part of String: use '%' wildcard to search selected String in data set values. E.g. "value": "%al%"
Sample Request / Response
When data has been deleted and new rows added successfully, the response has the HTTP status code 200 and the content "OK".