Calling SOAP and REST API's from PL/SQL

Calling SOAP and REST API's from PL/SQL

• 1.
  SOAP AND RESTAPIS
• 2.
  API Definition: Is aninterface to allow applications to talk each other.
• 3.
  WHAT I SHOULDKNOW BEFORE CALLING AN API ? IT PROVIDES INFORMATION FOR HOW TO COMMUNICATE WITH A SOFTWARE COMPONENT, DEFINING THE – OPERATIONS (WHAT TO CALL) – INPUTS (WHAT TO SEND WITH A CALL) – OUTPUTS (WHAT YOU GET BACK FROM A CALL) – UNDERLYING DATA TYPES
• 4.
  CATEGORIES OF APIS APISBELONG TO TWO CATEGORIES – TRADITIONAL SERVER TO SERVER, LIBRARIES IN SOURCE CODE – WEB APIS (FOCUS WILL BE ON THIS THROUGHOUT THE CLASS) 4
• 5.
  WEB APIS OVER TENSOF THOUSANDS OF PUBLIC WEB APIS THAT HELP CONNECT APPLICATIONS VIA THE INTERNET EXISTS • WEB APIS ARE CREATED IN A WIDE RANGE OF WEB FORMATS AND STANDARDS – SOAP (SIMPLE OBJECT ACCESS PROTOCOL) APIS – RPC (REMOTE PROCEDURE CALL) APIS • JSON-RPC APIS • XML-RPC APIS – REST (REPRESENTATIONAL STATE TRANSFER) APIS 5
• 6.
  SOAP API CAN BEUSED ACROSS DIFFERENT COMMUNICATION PROTOCOLS (HTTP, SMTP, UDP) • REQUIRE SOAP LIBRARY IN THE CLIENT TO BUILD AND RECEIVE REQUESTS • CAN BE STATEFUL OR STATELESS • REQUIRES EXTENSIVE PROGRAMMING KNOWLEDGE • RELY HEAVILY ON XML FORMAT FOR DEFINING A WEB SERVICE (WSDL) – XML FORMAT RESULTS IN MORE LINES OF CODE WHICH RESULTS IN BIGGER MESSAGE SIZES MAKING THEM UNWIELD 6
• 7.
  SOAP REFERENCES Sample SOAP http://webservicex.net/new/home Takeany soap wsdl file from the above link, validate the wsdl and follow the instructions given in below link. Calling soap services in pl/sql https://martin-mares.com/2010/08/oracle-db-consume-wsdl- webservice-in-plsql/ 7
• 8.
  REST (REPRESENTATIONAL STATE TRANSFER) •Typically used over http • supports any content type (xml, json, yaml…) • requires single command for multiple actions • stateless • are less difficult for new developers to use compared to soap apis 8
• 9.
  REST REFERENCE Sample REST http://training-american-ws.cloudhub.io/api/flights Followthe instruction given in below link. Calling rest apis from pl/sql Https://technology.Amis.Nl/2015/05/11/invoke-a-rest-service- from-plsql-make-an-http-post-request-using-utl_http-in-oracle- database-11g-xe/ 9
• 10.
  10 Thank You