Tuesday, November 26, 2019

OIC - Create an Integration (Rest to DB data fetch)

Designer⇾Integrations⇾Create
 Select Basic Routing Style
 Provide the Name, package and description
 Integrations canvas opened
Drag the created DB Trigger and invoke type connection in target
Steps to create DB trigger and invoke connection oic-create-db-connection
Provide the name and Run a SQL Statement option.
Provide your SQL query to fetch the department name from department id.
 Validate SQL Query
 Next
 Target is ready
Now drag and drop created trigger rest connection.
Steps to create trigger rest connection oic-create-trigger-type-rest-connection
 Provide the details
 Provide the input field details
 here i selected JSON sample as response
 Provide the response JSON part
 Next
 Source and Target is ready
 Now map the inbound flow

 Map the outbound flow


 Provide Tracking details


 Activate



 Take the endpoint and create a rest project in SOAPUI
 Add the input parameters
 Add Authorization
 Test

1 comment:

Featured Post

OIC - How to Retrieve Email Attachments Using Microsoft Graph API: Automating Payment File Processing

Retrieving Email Attachments Using Microsoft Graph API: Automating Payment File Storage in Object Storage Use Case: A finance team needs t...