on 06-07-2017 12:42 PM
Hi, I am using the Request URI in sap gateway client transaction as below:
/sap/opu/odata/sap/Servcie/Entityset?&$filter=((Property1 eq 'O2C_1') and (PropertyFrmDateTime gt datetimeoffset'2017-06-10T12:00:00Z'))
I receive a 400 Bad request error:
<message xml:lang="en">Invalid parametertype used at function 'gt' (Position: 75)</message>
Anything wrong with gt(greaterthan) keyword ?
BR,
Venky.
Hello Venky,
I checked with sample odata service url . This one works
http://services.odata.org/V2/OData/OData.svc/Products?$format=json&$filter=ReleaseDate gt datetime'1995-09-01T00:00:00' and ReleaseDate lt datetime'1995-12-01T00:00:00'
I can see using datetimeoffset could be the culprit. Can you provide the metadata your entity. We might need to check the entity type. Else the above url might work.
Thanks and Regards,
Veera
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Veera,
I tried with datetime, still it gives me the same error.
I have attached the notepad about metadata of the entity, please check.metadata.txt
BR,
Venky.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.