Groovy Sample – ExportQueryResult.groovy for Oracle Profitability and Cost Management Cloud

Prerequisites: json.jar

Common functions: See Appendix C: Common Helper Functions for Groovy.

def exportQueryResult() {
        String queryName = "Profitability - Product";
        String fileName = appName +"_"+ queryName + "_Query_Result";
            
        JSONObject json = new JSONObject();
        json.put("queryName", queryName);
        json.put("fileName", fileName);
        json.put("exportOnlyLevel0Flg", false);
        
        String urlString = serverUrl + "/epm/rest/"+ apiVersion + "/applications/" + appName + "/jobs/exportQueryResultsJob";
                
        def url;   
        
         try {
                 url = new URL(urlString)
         } catch (MalformedURLException e) {
                 println "Malformed URL. Please pass valid URL"
                 System.exit(0);
         }        
        executeJob(url, "POST", json.toString());
}