Jump to content

Welcome to Smart Home Forum by FIBARO

Dear Guest,

 

as you can notice parts of Smart Home Forum by FIBARO is not available for you. You have to register in order to view all content and post in our community. Don't worry! Registration is a simple free process that requires minimal information for you to sign up. Become a part of of Smart Home Forum by FIBARO by creating an account.

 

As a member you can:

  •     Start new topics and reply to others
  •     Follow topics and users to get email updates
  •     Get your own profile page and make new friends
  •     Send personal messages
  •     ... and learn a lot about our system!

 

Regards,

Smart Home Forum by FIBARO Team


  • 0

How to download Energy consumption data as csv


Markus2801A

Question

Is there a possibility to download the Energy Consumption data as csv File?
I can't find the export Energy data button?

Please login or register to see this attachment.

Link to comment
Share on other sites

5 answers to this question

Recommended Posts

  • 0

You can download the data using API swagger (in json format) and convert it to csv later if you want.
For example using this: 

Please login or register to see this link.

  • Like 1
Link to comment
Share on other sites

  • 0
  • Inquirer
  • Thank you very much, for your fast answer and help.

    As I`m not familiar with programming and SWAGGER I`m overwhelmed with this for me new type of interface.

    Which one to choose to get the energy data from only one specific device?

    Please login or register to see this attachment.

    Link to comment
    Share on other sites

    • 0
  • Inquirer
  • I think I figured it out with the help of this: 

    and this:

     

    In my case:

     

    http://HCL3-IP/api/energy/StartDate-UNIX-TimeStamp/EndDate-UNIX-TimeStamp/summary-graph/devices/power/Device-ID

     

    returns:

    [[1656226800000,115.1],[1656226811000,230.9],[1656226812000,115.9],[1656226852000,217.7],[1656226853000,108.6],[1656226893000,227.7],[1656226894000,114.8],[1656226939000,229.3],[1656226940000,114.3],[1656227002000,231.2],[1656227003000,109.1],[1656227021000,228.0],[1656227022000,113.7],[1656227062000,228.4],[1656227063000,114.2],[1656227067000,228.5],[1656227068000,108.3],[1656227149000,228.4],[1656227150000,108.2],[1656227190000,216.4],[1656227191000,108.4],[1656227231000,216.3],[1656227232000,115.1],[1656227236000,228.0],[1656227237000,113.9],[1656227277000,227.8],[1656227278000,114.1],[1656227318000,227.5],[1656227319000,114.3],[1656227323000,229.4],[1656227324000,114.5],[1656227364000,229.2],[1656227365000,114.1],[1656227451000,228.8],[1656227452000,109.0],[1656227579000,216.3],[1656227580000,114.3],[1656227625000,226.9],[1656227626000,113.8],[1656227666000,227.8],[1656227667000,114.0],[1656227707000,229.4],[1656227708000,114.6],[1656227712000,229.7],[1656227713000,115.2],

    and so on!

     

    Thanks again!!!

    Best greetings from Austria!

    Stay healthy!

    • Like 1
    Link to comment
    Share on other sites

    • 0

    Can someone explain how this works ? I went into the swagger, and apparenty once you enter your devide ID it pepares a script for you (CURLor ???)

     

    What do you do next ? How to execute this "code" ?

     

    It looks that in the terminal you cannot write anything.

     

     

    Link to comment
    Share on other sites

    Join the conversation

    You can post now and register later. If you have an account, sign in now to post with your account.

    Guest
    Answer this question...

    ×   Pasted as rich text.   Paste as plain text instead

      Only 75 emoji are allowed.

    ×   Your link has been automatically embedded.   Display as a link instead

    ×   Your previous content has been restored.   Clear editor

    ×   You cannot paste images directly. Upload or insert images from URL.

    ×
    ×
    • Create New...