Apr-04-2019, 05:59 PM
Hi All,
I am new to python and please excuse for any process in posting the thread.I have a requirement to get few values from a URL.
URL
http://xx.xx.xx.net:xx/xx/xx/select?=&facet.mincount=1&facet.pivot={!range=d1}merchant&facet.range.end=NOW&facet.range.gap=%2B1DAY&facet.range.start=NOW/DAY-90DAYS&facet.range={!tag=d1}indexTimestamp&facet=true&indent=on&q=*:*&rows=0&wt=json
Part of the result of the above URL:
"facet_ranges": {
"indexTimestamp": {
"counts": [
"2019-01-23T00:00:00Z",
3804,
"2019-03-21T00:00:00Z",
436101,
"2019-03-22T00:00:00Z",
11824,
"2019-03-23T00:00:00Z",
1170,
"2019-03-24T00:00:00Z",
744,
"2019-03-25T00:00:00Z",
905,
"2019-03-26T00:00:00Z",
1116,
"2019-03-27T00:00:00Z",
1254,
"2019-03-28T00:00:00Z",
1324,
"2019-03-29T00:00:00Z",
1371,
"2019-03-30T00:00:00Z",
1603,
"2019-03-31T00:00:00Z",
1069,
"2019-04-01T00:00:00Z",
1164,
"2019-04-02T00:00:00Z",
4278,
"2019-04-03T00:00:00Z",
1621986,
"2019-04-04T00:00:00Z",
1223949
],
"gap": "+1DAY",
"start": "2019-01-04T00:00:00Z",
"end": "2019-04-05T00:00:00Z"
}
},
From the above output my requirement is to get each days count, atleast last 2 days.ie
2019-04-04T00:00:00Z : 1223949
2019-04-03T00:00:00Z : 1621986
2019-04-02T00:00:00Z :4278
value2=jData['facet_ranges']['indexTimestamp']['counts']
KeyError: 'facet_ranges'
I am unable to figure out the issue,could please help.
I am new to python and please excuse for any process in posting the thread.I have a requirement to get few values from a URL.
URL
http://xx.xx.xx.net:xx/xx/xx/select?=&facet.mincount=1&facet.pivot={!range=d1}merchant&facet.range.end=NOW&facet.range.gap=%2B1DAY&facet.range.start=NOW/DAY-90DAYS&facet.range={!tag=d1}indexTimestamp&facet=true&indent=on&q=*:*&rows=0&wt=json
Part of the result of the above URL:
"facet_ranges": {
"indexTimestamp": {
"counts": [
"2019-01-23T00:00:00Z",
3804,
"2019-03-21T00:00:00Z",
436101,
"2019-03-22T00:00:00Z",
11824,
"2019-03-23T00:00:00Z",
1170,
"2019-03-24T00:00:00Z",
744,
"2019-03-25T00:00:00Z",
905,
"2019-03-26T00:00:00Z",
1116,
"2019-03-27T00:00:00Z",
1254,
"2019-03-28T00:00:00Z",
1324,
"2019-03-29T00:00:00Z",
1371,
"2019-03-30T00:00:00Z",
1603,
"2019-03-31T00:00:00Z",
1069,
"2019-04-01T00:00:00Z",
1164,
"2019-04-02T00:00:00Z",
4278,
"2019-04-03T00:00:00Z",
1621986,
"2019-04-04T00:00:00Z",
1223949
],
"gap": "+1DAY",
"start": "2019-01-04T00:00:00Z",
"end": "2019-04-05T00:00:00Z"
}
},
From the above output my requirement is to get each days count, atleast last 2 days.ie
2019-04-04T00:00:00Z : 1223949
2019-04-03T00:00:00Z : 1621986
2019-04-02T00:00:00Z :4278
responseurl = requests.get('http://xx.xx.xx.net:xx/xx/xx/select?=&facet.mincount=1&facet.pivot={!range=d1}merchant&facet.range.end=NOW&facet.range.gap=%2B1DAY&facet.range.start=NOW/DAY-90DAYS&facet.range={!tag=d1}indexTimestamp&facet=true&indent=on&q=*:*&rows=0&wt=json') if(responseurl.ok): jData = json.loads(responseurl.content) value2=jData['facet_ranges']['indexTimestamp']['counts'] print value2 else: responseurl.raise_for_status()Executing the above code resulted in below error.
value2=jData['facet_ranges']['indexTimestamp']['counts']
KeyError: 'facet_ranges'
I am unable to figure out the issue,could please help.