Help

Patch records with computed fields

Topic Labels: API
Solved
Jump to Solution
2216 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Nikolai
4 - Data Explorer
4 - Data Explorer

I have a table/records with a computed column/fields (using a lookup function) - let’s call this field/column F0.

I would like to PATCH the table by changing the values of field F1 and leave everything else as is.

However, when I send the request I obtain the following error

 {
    "error": {
        "type": "INVALID_VALUE_FOR_COLUMN",
        "message": "Field \"F0\" cannot accept a value because the field is computed"
     }
}

Any guidance would be appreciated!

1 Solution

Accepted Solutions
Bill_French
17 - Neptune
17 - Neptune

Perhaps rhetorical, but a PATCH is designed to be non-destructive, ergo - only F1 would be updated, right? If F1 is not a calculated field, you should be able to update it without mentioning F0 at all, right?

Am I missing something?

See Solution in Thread

1 Reply 1
Bill_French
17 - Neptune
17 - Neptune

Perhaps rhetorical, but a PATCH is designed to be non-destructive, ergo - only F1 would be updated, right? If F1 is not a calculated field, you should be able to update it without mentioning F0 at all, right?

Am I missing something?