SAP Knowledge Base Article - Public

3435969 - Problems when setting values for Input Parameters (Consuming data via the OData API)

Symptom

Some views exposed for consumption may contain input parameters which allow you to set values to filter or otherwise modify the data you consume. 

For this, the URL passed should be according to the input parameter type, otherwise unexpected results can occur. 

Environment

SAP Datasphere 

Resolution

  • The URL to be passed is according to the OData Documentation. Data types dwc.Principal, String and String256, URL will contain straight single quotation marks, as below: 
    https://<tenant_url>/api/v1/dwc/consumption/relational/<space_id>/<asset_id>/<asset_id>(<param>='<val>')/Set

    To the other Data types,  straight single quotation marks are not necessary: 
    https://<tenant_url>/api/v1/dwc/consumption/relational/<space_id>/<asset_id>/<asset_id>(<param>=<val>)/Set

  • The technical name of the parameter should be used in the URL. 


  • Input parameters with data type Boolean, Binary and UUID are not currently working (considering input value or default value). 

See Also

Consume Data via the OData API

Keywords

{"status":400,"message":"Bad request; please refer to documentation"}, Binary, Boolean, Date, DateTime, Decimal, DecimalFloat, Double, hana.BINARY, hana.REAL, hana.SMALLDECIMAL, hana.SMALLINT, hana.TINYINT, Integer, Integer64, String, Time, Timestamp, UUID, odata api , KBA , DS-BB-ODATA , To address issues related to Odata consumption API , DS-BB , Business Builder , Problem

Product

SAP Datasphere all versions