Calling Vendor RESTful APIs from Your PL/SQL Program

12:45 PM–1:45 PM Apr 9, 2019

GH 4TH FL Republic C


Session ID: 10757

Abstract: More and more third-party vendors are requiring the use of Representational State Transfer (REST) Application Programmatic Interfaces (APIs) rather than traditional file exchanges to maintain data to and from E-Business Suite. Learn how to call these APIs from within PL/SQL code, using our experience integrating a third-party eProcurement vendor with Human Resources, Accounts Payable, and General Ledger.

Objective 1: Overview of Representational State Transfer (REST) APIs

Objective 2: Creating the Oracle Wallet to store database credentials

Objective 3: Explain components needed for the HTTPS call

Objective 4: Handling Extensible Markup Language (XML) or JavaScript Object Notation (JSON) data within PL/SQL

Objective 5: Lessons learned and other tips and tricks

Audience: Technical