Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
How to Parse Date From EPMAutomate downloaded Activity reports' Json File — Cloud Customer Connect
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

Received Response
12
Views
3
Comments
edited May 1, 2021 1:36AM in Financial Consolidation and Close 3 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!