About the Coda API 'get a row'

Developers Central
1

Hello,

When I used the Coda API to get a row from the Coda table (attached images below), there are no values present for the button and notes column. I want to know if there is an issue with the Coda API or if there is an error on my part.

Python Code:
image

Terminal Result:

Row values are: JA, 2000, 10000, ,

Please let me know if there is a solution.

Thank you!

2

Buttons don’t hold any values. If you want to examine the button’s config such as its formula etc, you have to look into the Columns endpoint for that.

Notes is a canvas column and I guess there’s just no support for retrieving canvas content yet. Last time I needed this (to cross-doc table content from one doc into another) I had to work this around by making a separate column with

Notes._Merge() + ""

formula to convert the canvas to its JSON representation, and turn it back into a canvas on the receiving side with

ParseJson('{"o":' + JSON + '}')._Deref_Object("o")
2 Likes
3

Canvas columns are supported by the API, and you should get a text approximation of the content within. There isn’t full fidelity however, so certain types of content in the canvas may not be accessible.

1 Like