Integrations and Extensions

Enterprise Resource Planning

Topic

    Durgaprasad Mohapatro
    how we can automate REST APIsAnswered
    Topic posted October 25, 2019 by Durgaprasad MohapatroGold Medal: 3,500+ Points, tagged File Based Data Integration - FBDI, Financials, Project Portfolio Management, REST Services, SOAP Services 
    64 Views, 3 Comments
    Title:
    how we can automate REST APIs
    Content:

    Currently, In PPM Billing, There is no way to automatically release all approved invoices. It is a manual action.

    We were looking for a way to automate the process and found a REST API, that releases a single approved invoce.

    Now, In EBS, It is very easy to achieve., By writing a PL/SQL code, looping the approved invoices and calling the API for release invoices one by one. Then register the PL/SQL code as a conc request and schedule the conc request for automatically release the approved invoices.

    Is it the same with REST API? Can we call this API in PL/SQL and loop through?

    If not, then how we can automate REST APIs?So hat we can schedule them as a process/job to run periodically.

    Best Comment

    Pavol Vataj

    Hi,

    with REST API you are just more flexible. You can use pl/sql, java, python,... you choose the language in order to automate.

    Regards,

    Pavol

    Comment

     

    • Pavol Vataj

      Hi,

      with REST API you are just more flexible. You can use pl/sql, java, python,... you choose the language in order to automate.

      Regards,

      Pavol

      • Durgaprasad Mohapatro

        Hi Pavol,

        Thanks for the info.

        Can we just call the rest api, the way used to call in PL/SQL? Is there any sample example showing this?

        Thanks,

        Durga

    • Pavol Vataj

      Hi Durga,

      yes you can call REST API from pl/sql ... ideally you use apex apis for that ... there are plenty of examples on the web.

      Regards,

      Pavol