Get cell value by api rest

miguelf

Hello, 

 

We need to get a specific cell value given the row and column id via an api call. I get one way getting the history of the cell but this call has a problem when you call more than 10 times in a couple of second, do you have another solution?

 

Thanks 

Miguel 

KevinFansler

If you just need a cell value, it's much faster to do a GET /row (https://smartsheet-platform.github.io/api-docs/#get-row). You'll get the value for each column. If you already have the columnId, then it's just a matter of matching up that columnId in the return data to see what the value for the cell is. If the simplest version of that call doesn't answer your question, the documentation has several include query params that can help you modify your query.