|
Klasyczne typy plików nie są już dostępne od stycznia 2021 r. Możesz przenieść swoje klasyczne pliki lub pobrać plik PDF. Dowiedz się więcej

Malformed Value Error on Script to Update Sheet

Zamów wersję demonstracyjną

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

Komentarze

Komentarze: 3

Data Głosy
  • 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

Zaloguj się, aby dodać komentarz.