Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to Parse Date From EPMAutomate downloaded Activity reports' Json File

edited May 1, 2021 1:36AM in Financial Consolidation and Close 4 comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!