cURL Sample – ExportQueryResult.sh for Profitability and Cost Management

Common functions: See Profitability and Cost Management Common Helper Functions for cURL.

funcExportQueryResult() {
	queryName="Profitability - Product";
	fileName=$APP_NAME+"_"+$queryName+"_Query_Result"
	param="{\"queryName\":\"$queryName\",\"fileName\":\"$fileName\",\"exportOnlyLevel0Flg\":\"false\"}"
	url=$SERVER_URL/epm/rest/$API_VERSION/applications/$APP_NAME/jobs/exportQueryResultsJob
	funcExecuteRequest "POST" $url "$param" "application/json"

	output=`cat response.txt`
	status=`echo $output | jq '.status'`
    if [ $status == -1 ]; then
        echo "Started Exporting successfully"
		funcGetStatus "GET"
    else
        error=`echo $output | jq '.details'`
        echo "Error occurred. " $error
    fi
	funcRemoveTempFiles "respHeader.txt" "response.txt"
}