Scroll to top

Dynamic Updation of OIC Lookups Using Rest API


Joel Rajive - October 31, 2023

Reading Time: 3 minutes

In this blog, we’ll discover how to update an OIC Lookup using OIC Integration. So, let’s begin.

Step 1: Create a REST connection with the OIC URL in which the lookup is located and give the credentials for the connection.

Step 2: Create a new Lookup or use an already existing Lookup.

Step 3: Now, let us create an App Driven Integration.

Step 4: Add a Trigger REST Endpoint and give the Request Payload as follows.

Here we pass the Key and Value for the lookup.

Step 5: Give the response payload in such a way that we can know the status of the Integration.

Step 6: Use the REST connection we created in step 1 as an invoke and create a PUT Method.

The URL should be provided in this format – /ic/api/integration/v1/lookups/{lookup_name}

And configure the endpoint to accept request.

Suggested for you: A Detailed Guide to Expose Oracle REST Data Services (ORDS)

Step 7: Give the request payload in the following format with columns as the source and target columns and rows containing the lookup data that you want to insert and the name holding the lookup name.

Step 8: In the Mapping for UpdateLookup Endpoint, repeat the node for Column for providing the Key and Value Column.

Provide the Column Names Respectively.

Step 9: Map Rows to the Array from the request to map the number of rows to be Updated.

Step 10: Repeat Node for RowData to Map the Key and Target Value for each Request.

Step 11: In the Name section, pass the Lookup Name.

Step 12: Validate and Close.

Step 13: In the Response for The Trigger Pass Success.

Step 14: Activate and Test the Integration.

Step 15: Give Request Payload for Array of Key and Values and Test.

Step 16: Check the Lookup if it’s Updated.

Values are updated in the LookUp.

Instead of Passing the Key and Value from Request it is possible to update the lookup by Reading BI Report and other methods also.

Let us know your views in the comments or write to us at [email protected] to know more.

Joel Rajive

Joel is a Computer Science Graduate. He is working as an Associate consultant at Conneqtion Group and has an excellent command over VBCS, OIC, PL/SQL and JavaScript.

Author avatar

Joel Rajive

Joel is a Computer Science Graduate. He is working as an Associate consultant at Conneqtion Group and has an excellent command over VBCS, OIC, PL/SQL and JavaScript.

Related posts

Post a Comment

Your email address will not be published. Required fields are marked *