table-e2.github.io/test2.py at master · table-e2/table-e2.github.io · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
from urllib.request import urlopen

baseurl = 'https://ucd-pi-iis.ou.ad3.ucdavis.edu/piwebapi/elements/'
url = baseurl + 'E0bgZy4oKQ9kiBiZJTW7eugwBjj8KdFl6BGUWQBQVpcmaQVVRJTC1BRlxSRVNUIFBPU1RTIFRPIFBJXFJFU1QgUE9TVFMgVE8gUElcVUZMXFVGTFxXSUZJIEFDQ0VTUyBQT0lOVFM/elements'
req = urlopen(url)

import json
data = json.load(req)
for key in data['Items']:
    newurl = key['Links']['RecordedData'] + '?startTime=-1h' + '&selectedFields=Items.Items.Value'
    # print(newurl)
    req = urlopen(newurl)
    selected = json.load(req)
    try:
        last = selected['Items'][0]['Items'][-1]['Value']
        val = int(last)
        print(key['Name'], end=' ')
        print(val)
    except ValueError:
        pass
    except IndexError:
        pass