An external tool within my ecosystem generates data files (JSON, CSV) that I’d like to leverage in my Coda doc. As the tool runs 1+ times a day, it’s constantly making new data available. This data is only static input data for my Coda doc, but a data set that my doc relies on.
I’d like to be able to setup a table in my Coda doc that is linked to the data file my tool generates. Its within my control to ensure that the format of the data file remains constant, so a straight import of the data into my Coda Table would be consistent from day to day - consistent enough that I’d want the table just refreshed when new data is available.
As this “data table” that is linked to an external file would be used in queries, references, etc. in other Tables in my Coda document, I’d want the refresh to be literally a refresh and not a “create new table every day” situation.
Is there a way that I can refresh the data in a Table, leveraging an external data file, on daily basis, and maintain references that I would have to that data table within my Coda document?