Clear/delete Time Series Data?

[hammad_haroon]

Is it possible to delete unwanted historical time-series data of a stream?

[arundhati.ghosh · Accepted solution]

Hi @hammad_haroon. Currently, the only way to erase the time-series data from the UI would be to delete the Stream Connection. Other options are:

• If you are sending the data to Tandem from a CSV file used for testing, you could potentially edit the CSV and try to resend.
• You can use the Tandem API to delete data points of multiple streams. It allows you to specify a time boundary for the time range to be deleted. https://aps.autodesk.com/en/docs/tandem/v1/reference/quick_reference/tandem-data-deletestreamsdata-P...

I am curious about your use-case; are you intending to delete the historical data because it was unintentionally sent to Tandem or is there a different scenario you are trying to test? 

[hammad_haroon]

I'm pushing data to Tandem through other methods, for instance historical data in csv format. This means i'm converting timestamps to epochs for example, but i made an error with the timezone (timestamp wasnt converted to GMT before conversion to epoch). If i fix it and send it again, it'll be overlaid with the existing data so i'll need to delete it and send it again.

[robert_seliger]

To elaborate on this, while creating a test setup for feeding a temperature parameter value on a periodic basis, we accidentally submitted an incorrect timestamp in the payload. The timestamp was set for a future date. Now we can no longer update the parameter with new values with correct timestamps for "now". We would like a simple way to clear the history for this parameter. Can this be done?

[jessica_smith]

Hello @robert_seliger ,

I chatted with the team about the best way to resolve this, and there are two ways:

1. Delete the IOT Connection, recreate it with the same name and classification, and re-push their corrected data.
2. The API documentation the Arundahti provided in a previous post should provide you with the capabilities to do what you need > https://aps.autodesk.com/en/docs/tandem/v1/reference/quick_reference/tandem-data-deletestreamsdata-P...

If you continue to experience an issue with this, please submit a support case at https://www.autodesk.com/support/contact-support