Change the values of a row
For this function you have to activate push to server as described in /lists/{listId}/rows.
You have only to send the fields who needs a change. Other fields will not be changed.
To select the row for the change, you have to use idValues. The keys in this object is the field id and the value is the value of this filed. In the example below, we search for the row with "Doe" as value in the fourth field. You can use multiple fields in idValues.
If there are multiple matches the query parameter multiMatchBehavior will set the behavior. TakeFirstMatch will change the first occurrence and RaiseError will raise an error without changing anything. If you don't set the multiMatchBehavior parameter, the default behavior is TakeFirstMatch. To avoid multiple matches you should have at least one field with unique values.
If there are multiple matches it will change the first occurrence. To avoid multiple matches you should have at least one field with unique values.
{
"idValues": {
"4": "Doe"
},
"data": {
"2": "Mr",
"3": "John",
"4": "Doe",
"5": "Mr John Doe Path"
}
}