Simple row update via API/Powershell


Just getting started with the API. Just want to show a proof of concept of updating a cell. I'm able to authenticate and get sheet, row and column details. I'm getting the error:

Invoke-RestMethod : { "errorCode" : 1008, "message" : "Unable to parse request. The following error occurred: Unrecognized token 'value': was expecting ('true', 'false' or 'null')\n at [Source: REST input; line: 1, column: 7]","refId" : "1s91b4mmwsgg2"}

I saw a similar error here but can't get it to work. Sorry for the noob question.....


$body = @{

 'columnId ' = '229799331424132'

 'value'  = 'true'


 Invoke-RestMethod -Method put -Uri $uri -Headers $headers -body $body

Best Answer