I’m trying to link the IoTaWatt data through EmonCMS to an excel sheet in more or less real-time.
I included a query in excel to download and transform the JSON data into excel formating. Which more or less works. Once in a while excel shows the following error:
As the feeds downloaded are the public ones the Credentials do not really make sense. Also, the format doesn’t make sense for me as it works in 4 out of 5 cases.
Does someone have experience with this?