How to Parse Date From EPMAutomate downloaded Activity reports' Json File
Content
I downloaded FCCS activity reports, I like to know how to scraping data from this Json file for analytics. I basically want to convert it like the original table form or convert it to csv file for excel, python dataframe, so I can calculate history average for certain metrics and set up Alert in our system monitoring app if certain metrics are below historical average threshold. I look into the file in vscode and jsoneditor, the file does not look like a typical Json file. I have tried get external data in excel, online Json to csv, no clean tables obtain, also
0