api 2.0 update of a cell and "Invalid row location."

cjones

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. 

Joseph Miller

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