Coda API insert/update rows with different object types

[Elam_Jaybal]

Hi All,

I want to insert or update row in the coda table through coda API “https://coda.io/apis/v1/docs/{docId}/tables/{tableIdOrName}/rows” as per the intructions in the below doc.

I will be inserting some different objects like date, currency, user to the row in the doc table. I can use valueType rich to fetch the specific object type results. How can I do the same to insert/update the rows. Could you help me with some syntax please. Thanks for your help in Advance.

Thanks,
Elam

[Eric_Koleda]

Hi @Elam_Jaybal - That’s correct, setting values can only be done via plain text. However Coda intelligently parses those plain text value based on the column type. It works the same way as when you type a value into the cell directly using your keyboard. For a date for example, you can see which date formats are interpreted correctly in the doc, and then use those same formats in your API request.