|
Klassiska filtyper är inte längre tillgängliga för användning från och med januari 2021. Du kan överföra dina klassiska filer eller ladda ner en PDF. Läs mer

Malformed Value Error on Script to Update Sheet

Begär demo

Hello! I am writing a script that attempts to lock a single sheet within a spreadsheet using the Partially update a single sheet API. 

Here is the chunk of code I am using to replace the lock value:

patch_body = [
        {
            "op": "replace",
            "path": "/lock",
            "value": "locked"
        }
    ]
 
I've also tried using "/locked" for the path and "true" for the value instead of the above.
 
However, I continue to get a 400 error that reads:
 
Failed to lock sheet: 400 {"code":"MalformedValue","details": [{"code":"MalformedValue","message":"resource must be one of the specified enumerator values","target":"/0"}],"documentationUrl":"https://developers.workiva.com/2022-01-01/partiallyupdateprototypesheetbyid.html?rel=error","message":"invalid operation"}.
 
My questions are: Is there a better API endpoint to use for this type of operation? And why could I be getting these 400 errors when using the documented PATCH operations supported for this endpoint?
0

Kommentarer

3 kommentarer

Datum Röster
  • Jeff Hickey

    Hi Talia Test,

    Try changing value to "lock" to lock the whole sheet. It is expecting a SheetLockType.

    [
      {
        "op": "replace",
        "path": "/lock",
        "value": "lock"
      }
    ]

    Thanks,
    Jeff

    0
  • Talia Test

    Jeff Hickey Thank you - this worked! Do you know if there is a way to unlock a sheet? I tried using "unlock" and "none" for the value, but no luck...

    0
  • Jeff Hickey

    Hi Talia Test,

    Glad that worked. Yes, to unlock a sheet, pass null value Here is an example body for the request to unlock a sheet:

    [
      {
        "op": "replace",
        "path": "/lock",
        "value": null
      }
    ]

    Thanks,
    Jeff

    0

Du måste logga in om du vill lämna en kommentar.