Symptom
Using ODATA connection type with parameterized API is not working during Data Preview of creation of new Data Flow:
parameterized API example: /sap/opu/odata/sap/XYZ/XYZAPI(xxx='xxxx',xxxx='xxxx')
Error message:
Failed to fetch data preview.
Correlation ID: xxxxx
HTTP Status: 500 error
Error Code: getDataSetFailed
Technical Message: Failed to fetch the data. Error in getDataSet. Failed to get dataset data for /xxx. Cause 1: HTTP/1.1 400 Bad Request{"error":{"code":"CX_SADL_GW_PARAMETER_ENTITY","message":{"lang":"en","value":"Entity 'xxx': Parameter entity set 'xxx' cannot be used for read"},"innererror":{"application":{"component_id":"BC-ESI-ESF-GW","service_namespace":"/SAP/","service_id":"xxx","service_version":"0001"},"transactionid":"xxx","timestamp":"xxx","Error_Resolution":{"SAP_Transaction":"For backend administrators: use ADT feed reader \"SAP Gateway Error Log\" or run transaction /IWFND/ERROR_LOG on SAP Gateway hub system and search for entries with the timestamp above for more details","SAP_Note":"See SAP Note 1797736 for error analysis (https://service.sap.com/sap/support/notes/1797736)"},"errordetails":[{"ContentID":"","code":"CX_SADL_GW_PARAMETER_ENTITY","message":"Entity 'xxx': Parameter entity set 'xxx' cannot be used for read","propertyref":"","severity":"error","transition":false,"target":""},{"ContentID":"","code":"/IWBEP/CX_MGW_BUSI_EXCEPTION","message":"An exception was raised","propertyref":"","severity":"error","transition":false,"target":""}]}}} Code:99999;
Environment
SAP Datasphere
Reproducing the Issue
- Create ODATA connection type
- Start a new Data Flow creation and use the above created connection as source
- Data Preview on the Data Flow
Cause
Parameterized API is not supported.
Resolution
Datasphere Data Flow only supports OData "custom query option".
If the above mentioned API is necessary, please create a new enhancement request: KBA 3332382 - How to create an enhancement request for SAP Datasphere?
Keywords
KBA , DS-DI-DF , Data Flows , CA-DI-IS-FA , Flow Agent , DS-BB-ODATA , To address issues related to Odata consumption API , How To