consumer to gateway date format problem

[Former Member]

Hello,

Problem is when ui5 app is passing date in format: YYYMMDD, app is passing '20141029 '

In odata data model this date type is DATS (char 😎  YYYYMMDD

the error at GW is

Der Wert 20141029 stellt kein gültiges Datum bzw. keine gültige Zeit dar.

means: The value 20141029 is not a valid date or a valid time.

Any idea ?

Thank in advance

Lucas

[kammaje_cis]

Lukaz,

This should help you.

[AshwinDutt]

Hello Lukasz,

Please pass the date in the format as 2014-03-11T00:00:00 in the URL when u fire the service.

So that GW will covert this into YYYYMMDD ( 20140311 ) format at the DPC level and it can be directly used in our logic.

Sample URL ->

$filter=OrderDate eq datetime'2014-03-11T00:00:00'

Regards,

Ashwin

[Former Member]

Thanks Ashwin,

This date is passing in create odata request in payload.

It should be also in format like you wrote ?

Lucas

[AshwinDutt]

Hello Lucas,

Yes please pass as below :

{

"REQUEST_NO":"56-11003",

"SEND_DATE":"2013-10-23T00:00:00"

}

Regards,

Ashwin

[Former Member]

I am not ui5 programmer.. could you explain what is meaning of "REQUEST_NO":"56-11003" ?

Lucas

[sreehari_vpillai]

what is your UI tool used to consume odata service ? this is the basic json structure

[AshwinDutt]

Hello Lucas,

That is just a sample payload.

U need not to send "REQUEST_NO":"56-11003".

Just have a look at the date format "2013-10-23T00:00:00" inside the payload which is shared.

Regards,

Ashwin