Parse Data From Oracle EPM Cloud FCCS Activity Report JSON File
We have a project to use EPM Automate to download FCCS activity report file to a local computer which is a JSON format file. I like to parse the metrics data from the file, conduct data analytics for our service performance management team. The file does not look like a traditional Json file, anybody has the experience of scraping Oracle EPM cloud JSON file? Json vs actual table attached. Thank you