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"
}