ArcGIS server report log error

CliveSwan — Mon, 07 Jun 2021 14:54:10 GMT

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??

topic ArcGIS server report log error in ArcGIS API for Python Questions

ArcGIS server report log error