POST Service Response Data
REST services return data in XML or JSON format depending on the following:
Accept and Content-type header parameters.
XSD or JSON schema submitted as POST request.
The following tables lists the tags in the response output.
Tag | Description |
IDENTIFIER | Unique number to retrieve values from the exception queue. The identifier tag is not included if the POST request was executed with explicit interchange mapping. To retrieve values from the exception queue, you must use an interchange mapping. |
MESSAGE | Short description of the process execution result. |
DETAILS | Minimal detailed information about exceptions. Includes elapsed time. |
DATA | Data values from the object that is represented by the XML element name. This tag is shown only when the returnColumns request parameter is specified. |
STATUS | Process execution status: “Success” or “Failure.” |
Successful Operation Response
The following XML output sample is of a successful response from the POST operation.
<?xml version="1.0" encoding="UTF-8" ?>
<OUTPUT>
<IDENTIFIER>447426</IDENTIFIER>
<RESULT>
<MESSAGE>Process finished successfully. </MESSAGE>
<STATUS>Success</STATUS>
<DETAILS>
<![CDATA[ Total records inserted/updated: 10The process finished
successfully.Elapsed time: 1 s ]]>
</DETAILS>
</RESULT>
</OUTPUT>
Error Response
The following XML output sample is of a failed response from the POST operation.
<?xml version="1.0" encoding="UTF-8" ?>
<OUTPUT>
<IDENTIFIER>447421</IDENTIFIER>
<RESULT>
<MESSAGE>Process finished with errors. Please use the identifier to
retrieve values from exception queue.</MESSAGE>
<STATUS>Failure</STATUS>
<DETAILS><![CDATA[ ORA 12899: value too large for column
"DEV_STG"."AKJ_TEST_IMPORT_1"."COLUMN2" (actual: 22, maximum: 10)
There were errors during the import process. As partial commit was
enabled for whole process, all successful transactions have been
commited.All extracted entries that failed are posted into the
exception queue.]]>
</DETAILS>
</RESULT>
</OUTPUT>