SAP Knowledge Base Article - Public

3465705 - Parameterized API cannot be used in Data Flow


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.

We can provide the following information to assist either you or an SAP engineer to solve the issue:

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 ("},"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;


SAP Datasphere

Reproducing the Issue

  1. Create ODATA connection type
  2. Start a new Data Flow creation and use the above created connection as source
  3. Data Preview on the Data Flow


Parameterized API is not supported.


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? 


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


SAP Datasphere all versions