3 weeks ago
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
Hi,
Please try to replace the space on either side of 'eq' with '%20', the new filter as below:
FiscalYear%20eq%202022
Regards,
Simon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
11 | |
10 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.