Time series and data tables

[Brandon_Cannaday]

That could work depending on the amount of data. Even though each Device State node is quick, when you multiply it by 10’s of thousands of executions, it’s very easy to reach the 60 second timeout when doing large looping operations like this.

I might recommend using a local script (Node.js, Python, Ruby, etc) to do the import using the Losant API. You can export the Data Table to a CSV from the Losant UI, or just use your original CSV files you started with.

I wrote a working Node.js script that can be found here:

Node.js script to batch insert CSV data

We’re seeing some use cases where large amounts of device data needs to be batch inserted from CSV files. This script provides an example of using Node.js to solve this problem. This script breaks up a file into 100 states per API call to Losant. This allows you to insert much more data than if you inserted one at a time. This is because Losant enforces maximum rate of 2 messages per second per device, however each message can contain multiple states with individual time stamps. Here’s the pack…