Skip to main content
Solved

Patch records with computed fields

  • October 8, 2019
  • 1 reply
  • 19 views

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!

Best answer by Bill_French

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?

1 reply

Forum|alt.badge.img+19
  • Inspiring
  • 3263 replies
  • Answer
  • October 8, 2019

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?