Oracle Applications E-Learning Lab

 In this tutorial, we will develop a REST API and upon the call of it, CSV File with data will be generated at FTP Server Create a connector for the FTP  Fill the the mandatory details as shown in the screenshot Enter FTP Server details on which you want to copy files Test the connection Now let's create the integration  Select App Driven Orchestration  Fill the relevant details  Drop REST Connector on the pallette  Fill the endpoint name which you want to call  Select the Operation Post and provide the desired URI name Click on JSON Sample   copy the below format { "UserData":[         {          "id":"",          "firstname":"",          "lastname":"",  "email":"",          "qualification":""       },       {          "id":"",          "firstname":"",          "lastname":"",  "email":"",

 In this case study, we will build a REST integration through OIC with the purpose to insert data into On-Prem DB through the DML command First step would be to create integration through service console , as shown in the below screenshot click on Create button  Choose App Driven Orchestration Fill the mandatory fields with relevant information Since we are building REST API to insert data into On-Prem DB , we should drop REST connector onto the Pallette  Provide the name for the endpoint URL Fill the URI name and select the Operation as POST Click on Next and load sample JSON format  { "UserData":[         {          "id":"",          "firstname":"",          "lastname":"", "email":"",          "qualification":""       },       {          "id":"",          "firstname":"",          "lastname":"", "email&qu