2 Replies Latest reply on Aug 10, 2017 4:45 PM by AnatoliAtanasov

    Take a Json input in Rest Adapter and invoke a proc that takes user-defined Collection Type

    3518429

      I see many examples to return Json response, but don't see how to take a Json input in Rest Adapter.

      My requirement is:

       

      • Take a POST Json request in Rest Adapter
      • Invoke a procedure that takes an user-defined Collection Type

       

      Here is what I've done.

       

       

      Submit Rest Service

          

          

          

       

       

      I have 2 xsd.

      • Used by Rest Adapter (I converted my Json to XML, then, generate a xsd from XML)
      • Used by DB Adapter (Automatically created when adding DB Adapter)

       

      BPEL Design:

          

          

       

          

       

      If I test this service, I get 500 Internal Server Error as below.

       

      <?xml version = '1.0' encoding = 'UTF-8'?>

      <RestFaultElement>

         <code>XPath expression failed to execute</code>

         <summary>An error occurs while processing the XPath expression; the expression is ora:doXSLTransformForDoc("../Transformations/SubmitTransformation.xsl", $inputVariable.request)</summary>

         <detail>XPath expression failed to execute.

      An error occurs while processing the XPath expression; the expression is ora:doXSLTransformForDoc("../Transformations/SubmitTransformation.xsl", $inputVariable.request)

      The XPath expression failed to execute; the reason was: javax.xml.transform.TransformerConfigurationException: oracle.xml.xpath.XPathException: Expression error: Empty string.

      Check the detailed root cause described in the exception message text and verify that the XPath query is correct.

      </detail>

      </RestFaultElement>

       

       

      What do I do wrong? Any help is appreciated!