Exportdata Rest API error with HTTP status: 400; Status text: BAD_REQUEST;
Summary:
I am working on Groovy script to call REST API /exportdata, but getting following error:
HTTP status: 400; Status text: BAD_REQUEST;
Response: This is an invalid request. The following field is not recognized by the system: formatPercentageAsPercent
I can use some help to troubleshoot the code …
Content (please ensure you mask any confidential information):
Map<String, Object> exportPayload =
[
"exportPlanningData": false,
"formatPercentageAsPercent": true,
"gridDefinition": [
"suppressMissingBlocks": true,
"suppressMissingRows": true,
"suppressMissingColumns": true,
"suppressMissingRowsNative": true,
"suppressMissingSuppressesZero": true,
"suppressInvalidScenarioTps": true,
"suppressInvalidColumns": true,
"suppressInvalidRows": true,
"predictionSupportForDynCalcMbrs": true,
"autoCorrectSegments": true,
"PovAxisDefinition": [
"dimensions": ["Plan Element", "Years", "Currency", "Department","Custom1","Custom2","Custom3","Custom4","Version","Scenario","Entity"],
"members": ["OFA_Total Plan", "FY25","USD", "Total Department","Total Custom1","Total Custom2", "Total Custom3", "Total Custom4", "OEP_working", "OEP_Forecast","ENT001"]