Data Export

Data Export

The Export Data feature enables you to efficiently extract variables from your bucket. This function is accessible within the Admin panel, specifically in the Bucket Module . To use it, select a bucket and navigate to the ' Variables' tab. On this screen, you can filter your variables to obtain precisely what you need by fine-tuning the selection of variables you wish to export.

Exporting data will consume your Data Output service .

Filtering data before exporting

Before exporting your data, you can utilize the filtering options to ensure that you obtain exactly what you need and avoid exporting undesired data. This helps prevent the consumption of your Data Output quota with unnecessary variables. Within the ' Variables Data ' table, you can use the search fields to filter your variables by any required value.

Additionally, you can hide or show columns to narrow down the data and select a different time format. To customize the columns and time format, simply click on the cog icon located in the lower-left corner of the table.

Once you have filtered the data, click the ' Export data ' button to initiate the export process with your specified parameters.

Exporting Data

To export the data filtered in your ' Variables Data' table, click on the ' Export data ' button in the right top corner. You will have the following options at your disposal:

  1. Columns: select which columns you want to include in the export file. 
  2. File Format: you can choose between two widely-used file formats: .csv for spreadsheet applications and JSON for data interchange and further processing in various applications.
  3. Amount of Records:  the number of records you wish to export. The records will be exported in sequence, adhering to the filters you've applied in the table prior to initiating the export.
  4. All Data: you can opt to export all records that have been filtered within the bucket. 

With these options, TagoIO ensures that you have full control over the data export process, allowing you to obtain the precise data set you require for your operations or analysis.

For Device Optimized Data (Immutable) buckets, you have the added option to export chunks of data. Learn more about Chunk Management .
You can export data using our API . Learn more about Getting Data.

    • Related Articles

    • Data Output Service

      One transaction of Data Output is counted for each register read from a data bucket. Learn more about Getting Data. You need to define the Data Output limit per month for each Profile where your applications are running. Here is one example: a device ...
    • Deleting Data

      DEL - Headers: Authorization: Your device token. Optional Query Strings KEY TYPE DESCRIPTION query string pre-defined by Tago qty string Maximum number of data to be returned start_date string Start date end_date string end ...
    • Getting Data

      HEADERS: Authorization: Your-Device-Token GET - QUERYSTRINGS: KEY TYPE DESCRIPTION variable string || array Get variables query string pre-defined by Tago qty string Maximum number of data to be returned. start_date string ...
    • MQTT - Process data, Publish it and Subscribe to a topic

      In this tutorial, you will learn how to process data, publish to a topic, and subscribe to it. We will be using the MQTTX client throughout this tutorial. Connecting to TagoIO MQTT Broker To publish a topic via TagoIO's MQTT, you must first add a ...
    • Data Records

      Data Record is related to the variables stored in the data buckets that are fed by the devices. Each register is composed of a variable and all metadata associated with it. The data record limit will define the maximum storage capacity for the ...