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.
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 is a Computer Science Graduate. He is working as an Associate consultant at Conneqtion Group. He has very good knowledge of VBCS, OIC, PL/SQL and JavaScript.
