Executing OData over BW Query pass back an error 400 for a non mandatory variable

[Henry_Hill]

Hello to all of you!

When I am executing an OData service exposing BW Query I include all the variables - the non-mandatory I leave empty like X_0Material='', but about the mandatory one I pass a parameter like X_0Fiscper='001.2025'. Unfortunately for Calday's variable, which is optional it returns error - status code 400 and more precisely "Invalid key predicate type . Expected type is 'Edm.DateTime' ".
I tried with /Date('') and all the variances but it doesn't recognize it.

Every assistance is appreciated.
Thank you in advance!

[yogeswara_adapa · Accepted solution]

Please use below format 

Variable=datetime'YYYY-MM-DDT00:00:00'

Here format should be maintained whether optional or mandatory in order for URL to work.

[junwu]

https://www.odata.org/documentation/odata-version-2-0/overview/

probably you need to follow that to pass datetime.