Update lookups in Oracle Integration Cloud are one of the most common requirements and this has been asked in multiple forums on how to update lookup hence the article is written.

Update Lookups in Oracle Integration Cloud

Integration doesn’t have inbuilt functions to update lookup values at runtime.

To solve this, OIC offers a REST API to update lookup as per need.

The REST API details:

PUT: /ic/api/integration/v1/lookups/{lookupname}

Request Payload:

{
   "columns":[
      "DepartmentCode",
      "DepartmentName"     
   ],
   "rows":[
      {
         "rowData":[
            "IT","Information"
         ]
      }, {
         "rowData":[
            "OP","Operation"
         ]
      }
   ],
   "name":"Department_Lookup_7"
}

Click on the video to see how to update the lookup.

Subscribe to my YouTube channel to get the latest videos on your notification list directly.

View more interesting posts

See how OIC integrations are behaving at runtime

HCM Data loader in Oracle Integration

Oracle Integration Cloud HCM adapter