Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

IN ODATA, How to pass Timestamp data using POST method

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

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question