Greetings,
I am trying to get the ArcGIS Server Report out to JSON, there are two issues.
1) Python loops through the reports, is expecting 4 columns?
There is report.reportname, report.metadata, report.time-slices, report.report-data
The Python is writing out rows, this fails when it try's to write out column 2. There is no column 2, 3, 4.
The code is:
with open(outFile, 'w', newline='') as json_file:
for service in srv.services.list():
if service.properties.serviceName != " ":
for report in service:
qk_report = srv.usage.quick_report(since="LAST_DAY", metrics="error")
df = DataFrame(qk_report, columns=['report' ])
flat = pd.json_normalize(qk_report)
flatten = flat.to_json()
print(flatten)
json.dump(flatten, json_file)
print("End of Report")
json_file.close
print("END REPORT")
The output per row (flattened JSON is):
{"report.reportname":{"0":"3da3d646cf434b9c838a822cd5c75d06"},"report.metadata":{"0":"{\"temp\":true,\"title\":\"3da3d646cf434b9c838a822cd5c75d06\",\"managerReport\":false}"},"report.time-slices":{"0":[1622989800000,1622991600000,1622993400000,1622995200000,1622997000000,1622998800000,1623000600000,1623002400000,1623004200000,1623006000000,1623007800000,1623009600000,1623011400000,1623013200000,1623015000000,1623016800000,1623018600000,1623020400000,1623022200000,1623024000000,1623025800000,1623027600000,1623029400000,1623031200000,1623033000000,1623034800000,1623036600000,1623038400000,1623040200000,1623042000000,1623043800000,1623045600000,1623047400000,1623049200000,1623051000000,1623052800000,1623054600000,1623056400000,1623058200000,1623060000000,1623061800000,1623063600000,1623065400000,1623067200000,1623069000000,1623070800000,1623072600000,1623074400000]},"report.report-data":{"0":[[{"resourceURI":"services\/","metric-type":"error","data":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]}]]}}
2) The data returned is not that useful??
