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
