Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
api 2.0 update of a cell and "Invalid row location."
I am attempting to do a cell update (in python) and it keeps telling me "Invalid row location" and I am not sure how to track this down (or even why the row location is invalid).
The call is:
sheetURL: https://api.smartsheet.com/2.0/sheets/<sheet_id>/rows
data: [{'cells': [{'columnId': '<column_id>', 'value': 'updated'}], 'id': '<row_id>'}]
The python is:
results = requests.post(sheetURL,
json=data,
headers={'Authorization': token})
I have done data retrieves so it appears the token is correct. I am an admin on the page so I should have sufficient access to update the cell.
Comments
-
Hello,
In order to troubleshoot this quickly and effectively, I'd suggest sending an email to api@smartsheet.com. Please include a copy of the full JSON request and response that returns this error, if possible.
Thanks!
Joseph
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives