"errorCode" : 1008 | Adding new new row using powershell

I am using powershell to automate smartsheet entries, I am able fetch sheet data but I am facing issues while adding a new row to the smartsheet.

$headers = @{

'Authorization' = 'Bearer <API token>'

'Content-Type' = 'application/json'

}

$body = @{

'columnId ' = '229799331424132'

'value' = 'true'

}

$puturi="https://api.smartsheet.com/2.0/sheets/7647453991200644/rows"

Invoke-RestMethod -Method post -Uri $puturi -Headers $headers -Body $body

using this API reference guide:

https://smartsheet-platform.github.io/api-docs/?shell#add-rows

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" : "1aipur5vacxtg"

}

At line:1 char:1

Find more posts tagged with

Accepted answers

All comments

Genevieve P.

Hi @kashif.raza

Is that column a checkbox column? If so, try removing out the quotes from around the True value:

}

$body = @{

'columnId ' = '229799331424132'

'value' = true

}

Let me know if this works for you!

Cheers,

Genevieve

kashif.raza

I tried it but but it is not working and surprisingly column is not a checkbox that is a text colume and I tried this also.

$body = @{

'columnId ' = '229799331424132'

'value' = "My text String"

}

Genevieve P.

Hi @kashif.raza

If you're updating a Text/Number cell with a text value via the API, then yes, wrapping it in quotes is the correct syntax.

The error message expecting ('true', 'false' or 'null') sounds to me like the column is expecting a boolean value (e.g. a checkbox column, or flag or star symbol). I'm unable to replicate that error with a Text/Number column.

That said, I am using the API directly and have not worked with PowerShell. I would suggest posting in the Power Shell Tech Community for help with Power Shell syntax.

Thanks!

Genevieve

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.