Smart Sheet API GET Rows not wokring

Eric Olsen

Hi all,

I am using the smart sheet api to read and update a rows values. I am performing this task using a python script and then requests library.

My current code setup looks something like this

------------------------------------

import requests

Test = "_________________________________________"

url = "https://api.smartsheet.com/2.0/sheets/"+Test

Header = {

    'Authorization': "Bearer ___________________________________________"

    }

response = requests.request("GET",url+"rows/__________________",headers=Header)

print(response.text)

-------------------------------------

where the blank areas are redacted information pertaining to the Test sheet ID, the auth token, and the row ID respectively.

The issue i am having with this is when making the request to the api i get the following as a response

{

 "errorCode" : 1006,

 "message" : "Not Found",

 "refId" : "xs0utqgw9426"

}

I am able to make GET requests with the API as i was able to use it flawlessly to read a whole sheets contents however now i would like to just read one row so that i may use it to update a cells contents on the row as per the documentation.

Any help would be appreciated

Eric Olsen

An easier to read version of this question posted to stackoverflow as well https://stackoverflow.com/questions/72310026/python-using-smartsheet-api-to-update-cell-value-without-sdk

Genevieve P.

Hi @Eric Olsen

I just checked your post on StackOverflow and I see you were able to resolve this issue by using the Sheet ID (found in the Properties of the Sheet), versus the unique string in the URL of the sheet.

Thanks for posting the link to your other discussion!

Cheers,

Genevieve