SAP Knowledge Base Article - Public

2729920 - You received the Error Message 'Invalid parametertype used at function' during an oData Query

Symptom

You used an oData URL like https://my[your system URL].sapbydesign.com/sap/byd/odata/ana_businessanalytics_analytics.svc/RP[your report ID]QueryResults?&$filter=[your filter/selection characteristic] eq 'value for filter/selection' for example and received the error message 'Invalid parametertype used at function eq'.

Environment

  • SAP Cloud for Customer
  • SAP Business by Design

Cause

You are using an incorrect oData URL and the selection or filter used in the query does not work.

Resolution

Please check the report metadeta via oData and here the parameter type for the field you would like to use.

Metadeta oData Query: https://my[your system URL].sapbydesign.com/sap/byd/odata/ana_businessanalytics_analytics.svc/$metadata?entityset=RP[your report ID]QueryResults.
You can also use the Build Odata Queries feature to check the report metadeta.

When you check the metadeta, please search for the field you used in your link and the parameter type.

  • If it shows Edm.String, the values have to be used in ' '.
  • If it shows Edm.Int64, the values have to be used without the inverted comma in the oData Query.

See Also

More information can be found in the following blog: OData for SAP Business by Design Analytics.

Keywords

odata, error message, odata query, parameter, exception, odata URL, selection, filter parameter type , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP Business ByDesign all versions ; SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions