Use Smartsheet API to sync with external system
I have a need to sync Smartsheet with an external system, the only way I can get the data out of the system is via a regularly updated report - however I have no way for the report to not include all data.
Ideally the API would give me an option to specify the value of the primary column, and if there is an existing record update it, but otherwise create a new record - but this does not appear to be possible. Since i am looking at thousands of records at a time I also don’t want the overhead of searching for each record.
I think my best solution is to delete all the data in the import table each time I do an import, but I don’t see an easy way of deleting all rows of a table so I assume I will have to first pull all rows, and then iterate through and delete them all - which seems clunky.
I don’t think there is a way for me to create a new sheet each time but retain the reporting.
Does anyone have any ideas?