Via the API is there a way that I could pull the value from a particular cell?
You can use the GET /docs/{docId}/tables/{tableId}/data endpoint, with a filter={"id": NNN}
where NNN
is the id of the row the cell lives in (you can find this from an =$id
formula). Or filter by some other id your records have. Either way, you’ll get back the cells on that row, including the one you want. Would that work for you?
https://support.getgrist.com/api/#tag/Data-Tables/paths/~1docs~1{docId}~1tables~1{tableId}~1data/get
Yes I can make that work. Was just wondering if there was an easier way to reference a particular cell when the position is fixed/known (i.e. row5 col3).
We could certainly add a little wrapper endpoint for that. I’d be interested to hear about your use-case, if you are willing to share?
Just thinking that it might more easily allow me to pull values into a web widget of some sort (a chart or progress indicator etc) or even just to display the raw value somewhere.