ODATA API Consumption SAP Datasphere - API filtering issue

[Laxmi5]

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. 

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

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

Thanks, 
Laxmi

[Ryan-Crosby]

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]

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

[Simon_Ye]

Hi,

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

FiscalYear%20eq%202022

Regards,

Simon

[Dinu]

I am not familiar with this service. But, in general with oData, FiscalYear is probably modeled as a String. So you have to put single quotes around it in $filter. Verify how Fiscal year appears in the result or check $metadata to ascertain its datatype. 

[Laxmi5]

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