SAP Knowledge Base Article - Public

3465705 - Parameterized API cannot be used in Data Flow

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.

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 (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

  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

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

Product

SAP Datasphere all versions