cancel
Showing results for 
Search instead for 
Did you mean: 

ODATA API Consumption SAP Datasphere - API filtering issue

Laxmi5
Explorer
0 Kudos
378

Hi All,

 

I am using GET method to bring data from Datasphere relational dataset. I want to filter the data based on fiscal year. When i do that in the HTTP request in Postman. It returns with below error. 

Laxmi5_0-1712852051004.png

Can you please guide if the syntax being used correct for filtering the data is correct? I have used SAP API documentation

Laxmi5_1-1712852166952.png

Link to API reference: https://api.sap.com/api/DatasphereConsumption/path/getRelationalData

Thanks, 
Laxmi

Ryan-Crosby
Active Contributor
0 Kudos
You are missing the /Set mentioned in the documentation and there is no way to validate that the remainder complies with the specification because it's blacked out.
Laxmi5
Explorer
0 Kudos
Hi Ryan, Thanks, I am using below API call and it is working. I want to extend it to filter using FiscalYear column and value = 2022
View Entire Topic
Simon_Ye
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

Please try to replace the space on either side of 'eq' with '%20', the new filter as below:

FiscalYear%20eq%202022

Regards,

Simon