Hello,
I try to get by API the content of a canvas colum (“Notes”).
curl --location --request GET 'https://coda.io/apis/v1/docs/docID/tables/tableID/rows?sortBy=natural&useColumnNames=true&valueFormat=rich&visibleOnly=true&limit=10' \
--header 'Accept: application/json' \
--header 'Authorization: Bearer xxx'
Unfortunately, I don’t get the content for the column (“Notes”) for all the row :
{
"items": [
{
"id": "i-tcG9liuEhe",
"type": "row",
"href": "https://coda.io/apis/v1/docs/tIqR26NrZw/tables/grid-m6XAKZb6bm/rows/i-tcG9liuEhe",
"name": "Image",
"index": 0,
"createdAt": "2022-06-16T19:31:20.268Z",
"updatedAt": "2022-10-03T05:16:30.320Z",
"values": {
"Name": "```Image```",
"Column 2": false,
"Column 3": "{\"i-000000\":{\"name\":\"j.b. o.\"}}",
"People": {
"@context": "http://schema.org/",
"@type": "Person",
"name": "j.b. o.",
},
"Row ID": 1,
"Notes": "",
}
},
{
"id": "i-FFU08CjK1F",
"type": "row",
"name": "Embed",
"index": 1,
"createdAt": "2022-10-03T05:14:50.285Z",
"updatedAt": "2022-10-03T05:16:19.819Z",
"values": {
"Name": "```Embed```",
"Column 2": false,
"Column 3": "{\"i-000000\":{\"name\":\"j.b. o.\"}}",
"People": {
"@context": "http://schema.org/",
"@type": "Person",
"name": "j.b. o.",
},
"Row ID": 5,
"Notes": "https://www.youtube.com/watch?v=JG1e_60599E",
}
},
{
"id": "i-4v_rEzZj7l",
"type": "row",
"name": "Name 1",
"index": 2,
"createdAt": "2022-10-03T05:14:37.464Z",
"updatedAt": "2022-10-03T05:14:37.464Z",
"values": {
"Name": "```Name 1```",
"Column 2": false,
"Column 3": "{\"i-00000\":{\"name\":\"j.b. o.\"}}",
"People": {
"@context": "http://schema.org/",
"@type": "Person",
"name": "j.b. o.",
},
"Row ID": 4,
"Notes": "\n## Text\n\nPizza ipsum dolor amet bacon\n### Image\n\n \n \n \nPesto onions ham fresh tomatoes parmesan bbq. Bbq sauce pie pork, bacon & tomato peppers bacon garlic pepperoni lasagna stuffed crust ph.\n### Fichier\n\n \n \n>> Info\nPepperoni bbq rib sauthicken.\n### Embed\n\nBbq rib sausage ranch white pizza Chicago style red onions thin crust ponions pepperoni.\n```\n`https://api.lorem.space/image/movie?w=150&h=220`\n```\nhttps://www.youtube.com/watch?v=JG1e_60599E\n",
\")": "```{}```",
}
}
],
}
Is there a way to access to the canvas line by line (or content by content)?