Smartsheet API Error using Python
Hello all,
I am trying to extract smartsheet data from a particular sheet using python and the Api but I keep getting an error preventing me from doing so. The code I use works for other sheets so I wonder whats preventing it from working now. The error I get is shown below.
ApiError: {"result": {"code": 1006, "errorCode": 1006, "message": "Not Found", "name": "ApiError", "recommendation": "Do not retry without fixing the problem. ", "refId": "1ba29nwzhu6i4", "shouldRetry": false, "statusCode": 404}}
The code is the regular ss_client.Sheets.get_sheet(sheet_ID) which works for other sheets i've been interacting with. Could someone please tell me what the issue might be.
Cheers
Best Answer
-
Ben Goldblatt Employee
I can see that you also reached out to the Support team on your API issue and that the issue had to do with your GET command looking for a Sheet ID rather than a Report ID. I'm glad to hear you were able to get this issue resolved in a timely fashion.
Support will be your best bet for troubleshooting these types of issues so feel free to submit a new ticket via theGet Help formwhen you run into any roadblocks or unexpected behavior. If you're a licensed user on a plan that's eligible for phone support, you can also call in to the Support team between 6:00am and 6:00pm US Pacific Time, Monday through Friday. Eligible users can find the live phone support number by clicking theAccount Profile Iconin the upper right corner and selectingPlan Info. This will open theAccount Administrationwindow and the phone number is listed at the bottom.
Thanks!
Ben
Answers
-
Ben Goldblatt Employee
I can see that you also reached out to the Support team on your API issue and that the issue had to do with your GET command looking for a Sheet ID rather than a Report ID. I'm glad to hear you were able to get this issue resolved in a timely fashion.
Support will be your best bet for troubleshooting these types of issues so feel free to submit a new ticket via theGet Help formwhen you run into any roadblocks or unexpected behavior. If you're a licensed user on a plan that's eligible for phone support, you can also call in to the Support team between 6:00am and 6:00pm US Pacific Time, Monday through Friday. Eligible users can find the live phone support number by clicking theAccount Profile Iconin the upper right corner and selectingPlan Info. This will open theAccount Administrationwindow and the phone number is listed at the bottom.
Thanks!
Ben