Integration

Get Involved. Join the Conversation.

Topic

    Mohana Gopal Selvam
    How to pass one connection response to another connection...Answered
    Topic posted August 6, 2019 by Mohana Gopal SelvamSilver Crown: 22,500+ Points, tagged Connection 
    35 Views, 10 Comments
    Title:
    How to pass one connection response to another connection request
    Content:

    Hi,

    Use Case:

    When we click one button in VBCS, read the data from DBCS and push to external application.

    I have created two connections.

    1. Rest Connection - Pass the Id get the response from DBCS

    2. External Connection - Pass the request

    I have created one Orchestration. How to pass the Rest API response as external connection request. 

    Thanks,

    Mohan

    Best Comment

    Kanchankumar Khedkar

    the you highlighted in yellow looks mapped activity which is output of your REST API which you will be sending at the end of process to called (in this case VBCS).  It should be second last activity. and you can map whatever response you need to send to VBCS or response of your API output. Once you move it down to second last (after invokation of DSC, you will be able to see other variables.

    In second mapper you need to map input received from VBCS (Query parameters defined by you in REST) to input of ORDS. 

    In second mapper you can directly map response received from ORDS to your external API mappe

    Comment

     

    • Kanchankumar Khedkar

      In your Orchestration, 

      1. Receive request (say Id from VBCS )

      2. Pass this Id to DBCS Invoke activity and get response.

      3. Mapper to Response received from DBCS to Request of external application

      4. Invoke external application. 

      when you add invoke, it creates mapper activity as well. During mapping you can select variable which will get mapped to invoke request. 

    • Mohana Gopal Selvam

      Hi Kanchan,

      In my Orchestration I did the followings.

      1. I drag and put my ORDS Rest API connection in Start 

      2. Configured Request arguments and configure the response Json.

      3. Then I drag external API (SOAP) and configure the SOAP header

      If I remove all mapper which created automatically and drag the new mapper. It seems something I am missing here. Provide me the next steps.

      Can we achieve this using Basic routing?

      Thanks,

      Mohan

    • Kanchankumar Khedkar

      first you will need three connections 

      1. one which REST connection which is exposed to VBCS

      2. ORDS for DBCS

      3. External application

      flow would be VBCS invokes OIC rest . This orchestration invokes ORDS REST API. Output from ORDS rest is mapped to external API. 

      You can not drag and drop ORDS REST connection directly at start. ORDS REST connection is Invoke not Trigger for your service. 

      In above connections 1st connection (REST i mentioned would be at start) .

    • Kanchankumar Khedkar

      And sorry, I forgot, your use case is Orchestration involving call to more than 1 end point, I don't think you can use basic Routing for this use case.

    • Mohana Gopal Selvam

      Hi Kanchan,

      My assumption is once we complete this orchestration in OIC, we will get OIC Rest API which we can use it in our VBCS.

      You meant to say we have to create one dummy rest API connection?

      Thanks,

      Mohan 

      • Kanchankumar Khedkar

        Yes, we need to create connection for REST API to be exposed and use it at start of integration. Once we activation integration that is when API is exposed. You will get end point which you can use in VBCS to trigger this orchestration. 

    • Mohana Gopal Selvam

      Hi Kanchan,

      I have created the Rest Trigger Connection. But what needs to be mapped between OIC Rest connection & ORDS Rest?

      It is showing OIC query parameter which I created in the right side & OIC response parameter in the left side.

      Thanks,

      Mohan

      • Kanchankumar Khedkar

        the you highlighted in yellow looks mapped activity which is output of your REST API which you will be sending at the end of process to called (in this case VBCS).  It should be second last activity. and you can map whatever response you need to send to VBCS or response of your API output. Once you move it down to second last (after invokation of DSC, you will be able to see other variables.

        In second mapper you need to map input received from VBCS (Query parameters defined by you in REST) to input of ORDS. 

        In second mapper you can directly map response received from ORDS to your external API mappe

    • Mohana Gopal Selvam

      Find the mapping screenshot

    • Mohana Gopal Selvam

      Thanks Kanchan for your support.