Skip to Content
0
Former Member
Sep 19, 2014 at 08:46 PM

IN ODATA, How to pass Timestamp data using POST method

203 Views

Dear all

I am trying to insert a record into a HANA column store table using ODATA service.

POST URL

http://hanadrp.sial.com:8000/sial/sapnext/generic/odata/uidatetime.xsodata/UIDateTime

Message one

{

"IDTXT" : "1",

"IDDATETIME" : "2014-09-19 10:20:10"

}

Message Two

{

"IDTXT" : "1",

"IDDATETIME" : "/TO_TIMESTAMP(CURRENT_TIMESTAMP)/"

}

Both give me this message

<?xml version="1.0" encoding="utf-8" standalone="yes"?>

<error

xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">

<code/>

<message xml:lang="en-US">Syntax error at position 0.</message>

</error>

The table here has only two columns and the IDDATETIME is a column of time TIMESTAMP

Please advice