Export format – ConsumptionCSV

  • Updated

This article describes the data format for files created by exports with the data format named ConsumptionCSV. 

To set up an export for your account to another system, contact us at support@metry.io. You can read more about the export functionality in Metry in our article Exportingdata from Metry. 

See the API reference for how to create an export via the API.

The file is a tabular text file, using a semicolon as a column delimiter. Each line has one consumption value and other fields describing the meter. The following columns are in order:

  • Meter ID: A unique identifier for the meter in Metry.
  • EAN: The ID used for the metering point by the data source such as the utility provider or sub-metering system.
  • Name: A name on the meter given by the user. (optional)
  • Type: The type of utility being measured or it could be sensor for other kinds of measurements. For example electricity, heat, cooling, gas, hot_water, water, or sensor. 
  • Provider ID: The ID of the actor responsible for the metering. For meters from a utility provider, this is an ID referencing a utility provider in Metry. For sub-metering, it could be the account holding the meter.
  • Provider Name: The name of the actor responsible for metering.
  • Address: The address of the meter (optional)
  • Longitude: Geographical coordinate of the meter. (optional)
  • Latitude: Geographical coordinate of the meter. (optional)
  • Tags: Free text values set by the user separated by comma. (optional)
  • Timezone: The timezone used for interpreting the date period.
  • Period: The month, day or hour of the consumption value represented as YYYYMM, YYYYMMDD or YYYYMMDDHH respectively.
  • Metric: The value's metric. The following metrics are supported.
    • energy (kWh)
    • estimated_energy (kWh)
    • flow (m3)
    • estimated_flow (m3)
    • return_temperature (°C)
    • supply_temperature (°C)
    • temperature (°C)
    • tvoc (ppm)
    • co2 (ppm)
  • Unit: The unit of the consumption values.
  • Value: The amount consumed during the given period.
  • Granularity: The length of the period. Either month, day or hour. 
  • Updated: A flag indicating if the value has been updated in Metry. Either "true" or "false". If it is true, then a different value has likely already been imported from Metry. Updated values are rare but can happen if Metry received an incorrect value from a utility provider or if an interpolated value was later replaced with a correct one.
  • Pushed At: Formatted date-time value (UTC) indicating when the stream entry has been pushed to the stream. (This field can be empty in some cases)

 

Example

Meter ID;EAN;Name;Type;Provider ID;Provider Name;Address;Longitude;Latitude;Tags;Timezone;Period;Metric;Unit;Value;Granularity;Updated;Pushed At
5d53c683775578009914b906;7359992480025334212;test;electricity;5d53c67f775578009914b904;Öresundskraft;Aminogatan 1;57.704542;11.965346;54224,exmpeltagg;Etc/GMT-1;2018010100;energy;kWh;3.23;hour;false;2021-05-20 19:53:40
5d53c683775578009914b906;7359992480025334212;test;electricity;5d53c67f775578009914b904;Öresundskraft;Aminogatan 1;57.704542;11.965346;54224,exmpeltagg;Etc/GMT-1;2018010101;energy;kWh;3.23;hour;false;
5d53c683775578009914b906;7359992480025334212;test;electricity;5d53c67f775578009914b904;Öresundskraft;Aminogatan 1;57.704542;11.965346;54224,exmpeltagg;Etc/GMT-1;2018010102;energy;kWh;3.23;hour;false;
5d53c683775578009914b906;7359992480025334212;test;electricity;5d53c67f775578009914b904;Öresundskraft;Aminogatan 1;57.704542;11.965346;54224,exmpeltagg;Etc/GMT-1;2018010103;energy;kWh;3.23;hour;false;2021-05-20 19:54:21

Related articles