cancel
Showing results for 
Search instead for 
Did you mean: 

Invalid parametertype used at function 'gt'

venkatesha_n
Explorer
0 Kudos

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member228602
Contributor
0 Kudos

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

venkatesha_n
Explorer
0 Kudos

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.