I would like to look up a data table on a third party web site that has the table stored in either JSON, csv or XML format.
Would you suggest to look the values up in real time or perhaps ‘sync’ it as a Losant Data Table, say once a day? It’s not important that it be up-to-date to the minute as the data table on the external website are in fact updated only daily which is more than enough. However, the look ups on the “day old” data will be quite frequent as device state is saved within my workflows.
The table is about 1800 rows and 9 rows of text. The JSON version of the table is about 250kb.