Integration

Get Involved. Join the Conversation.

Topic

    Karthick R
    OIC - How to invoke BIP ws and read output dataAnswered
    Topic posted October 9, 2019 by Karthick RRed Ribbon: 250+ Points, tagged Adapters, API, Cloud, Events, Integration, Mapping, Orchestration, PaaS, REST, SOAP, Web Services, xml 
    97 Views, 7 Comments
    Title:
    OIC - How to invoke BIP ws and read output data
    Summary:
    How to invoke BIP web service and parse/read the output in OIC?
    Content:

    Hi everyone,

    How to invoke BIP web service and parse/read the output and share the parsed data (column1, column2 ... column n) to another 3rd party application in OIC?

    Can anyone point out any blog/document reference material?

    Regards,

    Karthick.R

    Best Comment

    Ankur Jain

    Hi Karthick,

    Please follow below blog to cal BI service in OIC

    https://www.techsupper.com/2019/09/call-business-intelligence-api-in-oracle-integration-cloud.html

    Regards,

    Ankur

     

     

     

    Comment

     

    • Ankur Jain

      Hi Karthick,

      Please follow below blog to cal BI service in OIC

      https://www.techsupper.com/2019/09/call-business-intelligence-api-in-oracle-integration-cloud.html

      Regards,

      Ankur

       

       

       

      • Karthick R

        Hi Ankur,

        Your blog was very useful.

        I'm using /xmlpserver/services/PublicReportService?wsdl endpoint.

        I got stuck in one of the places.

        I have a report with multiple parameters. The blog doesn't include parameter use case.

        I'm not sure how to add new item in OIC. PFA screenshot.

        Can you please guide on this?

        PFB. SOAP UI request.

        <soapenv:Body>
              <pub:runReport>
                 <pub:reportRequest>
                    <pub:parameterNameValues>
                       <!--Zero or more repetitions:-->
                       <pub:item>
                          <pub:name>p_po_number</pub:name>
                          <pub:values>
                             <!--Zero or more repetitions:-->
                             <pub:item>2068</pub:item>
                          </pub:values>
                       </pub:item>
                       <pub:item>
                          <pub:name>rECEIPT</pub:name>
                          <pub:values>
                             <!--Zero or more repetitions:-->
                             <pub:item>25</pub:item>
                          </pub:values>
                       </pub:item>

                    </pub:parameterNameValues>
                    <pub:reportAbsolutePath>/Custom/SCM/PO_Header_Details.xdo</pub:reportAbsolutePath>
                    <pub:sizeOfDataChunkDownload>-1</pub:sizeOfDataChunkDownload>
                 </pub:reportRequest>
                 <pub:userID>User1</pub:userID>
                 <pub:password>Password1</pub:password>
              </pub:runReport>
           </soapenv:Body>

        Regards,

        Karthick.R

        • Ankur Jain

          Hi,

          If you want to add one more item, follow below step:

          • Right click on item
          • Click on Repeat Element

          Repeat Element would add one more new item

          Regards,

          Ankur Jain

          • Karthick R

            Hi Ankur,

            Encountered below error. PFA screenshot for more info.

            CASDK-0033: Received a SOAP fault while invoking endpoint target: https://xxxxxxyyyyyzzzzzzz/xmlpserver/services/PublicReportService. This indicates a processing exception on the service endpoint side. Please check service side logs to further diagnose the problem <![CDATA[
            Fault Code : soapenv:MustUnderstand
            Fault String : Did not understand "MustUnderstand" header(s):{http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd}Security
            Fault Details :
            <ns1:hostname xmlns:ns1="http://xml.apache.org/axis/">nlc6far09080347.nldc1.oraclecloud.com</ns1:hostname>
             ]]>
            :Application Error

            Regards,

            Karthick.R

    • Monish Munot

      Do a right click on item and then you should see option add more.

    • Monish Munot

      Also I would suggest make use of ExtrernalReportService instead of PublicReportService as you do not need to provide password explicitly.