How to get yesterday's kWhd value?

Submitted by JumpMaster on Fri, 28/08/2015 - 11:40

Hi,

I've got a kWhd feed using PHPTIMESERIES and from the vis view I can see each days value at 12:00. How do I pull that value from the feed API? It seems whatever json I user (get/data/histogram) I get back blank data such as 0/false/[]

Thanks for your help!
Kev

Re: How to get yesterday's kWhd value?

Submitted by JumpMaster on Fri, 28/08/2015 - 13:57.

I've managed to get a list of feeds from data.json and limited to a single item.

http://emoncms.org/feed/data.json?id=8343&start=1440633600000&end=144072...

and here's the output

[[1440630000000, 10.639547348022]]

Is there a way of directly requesting entry 1440630000000?

Thanks,
Kev

Re: How to get yesterday's kWhd value?

Submitted by TrystanLea on Fri, 04/09/2015 - 11:37.

Hello Kev, limiting a data.json request to one item is the only way to do it at the moment, Its the method I recently used to fetch last week/month/year data in myelectric.

All that you need to do, much as you've worked out is set the end time to 1 second after the time you wish to request and the interval to 1 second and then it will give the value at the start time requested.

http://emoncms.org/feed/data.json?id=8343&start=1440633600000&end=1440633601000&interval=1

Archived Forum