API Management

Get Involved. Join the Conversation.

Topic

    Aff Team
    Custom Web Service for multiple records
    Topic posted November 12, 2019 by Aff TeamGreen Ribbon: 100+ Points, tagged APIs, Gateways, Integration 
    22 Views, 5 Comments
    Title:
    Custom Web Service for multiple records
    Summary:
    Custom Web Service for multiple records
    Content:

    Hi Experts,

    I am able to develop and deploy a web service which when we pass inventory item id give me one record details of that inventory item id in EBS R12.1.3.

    Now My requirement is when i pass LAST_UPDATE_DATE it should give me all the items later than that last update date. I will use this web service in OIC to get EBS Items and POST in Engagement Cloud adapter.

    Regards,

    Zahid Rahim

     

     

    Version:
    EBS R12.1.3
    Code Snippet:

    Comment

     

    • Ankur Jain

      Hi,

      Please follow below steps to achieve your use case:

      Please see YouTube channel to learn OIC https://www.youtube.com/c/TechSupper

      Regards,

      Ankur

    • Aff Team

      Dear Ankur,

      Thank you for the reply.

      Initially i am struggling with the Pl/SQL API to return me multiple records which i should first be able to test in SoapUI/Postman tool before taking it to OIC. Looking at my code snippet can you please advice what should be the approach to get multiple records.

      Regards,

      Zahid Rahim

    • Aff Team

      Dear Ankur,

      Getting Last Update Date, Suppose we have 3 new records created in EBS.

      Now how can we fetch 3 records one by one to integrate in Cloud?

      Can we get all 3 records in one go?

      Can we loop through those record one by one?

      EBS Web Service is customized so we can change it to whatever suits us.

       

      Regards,

      Zahid Rahim

      • Ankur Jain

        Hi Zahid,

        Call EBS service once to get all records once based on Last run date and pass all same to target application.

        Rgeards,

        Ankur

         

        • Aff Team

          Dear Ankur,

          Can you please share a piece of code which return multiple records or some blog/reference.

          I want to develop a Pl/SQL package which should give multiple records. Then after deploying as a web service give multiple records in SoapUI/PostMan. and finally i should be able to use the same in Oracle Integration Cloud.

          Regards,

          Zahid Rahim