' oicbasics: Lookup integration testing
February 11, 2020

Lookup integration testing

Please access the previous blog to see integration development steps.

Step 1 :  
Activate the integration and click on endpoint.

Copy the Endpoint URL.

Step 2 : 
Open SoapUI tool and click on REST and paste the above copied endpoint URL and click ok.

Add basic Authentication

Enter your OIC instance username & password for basic authentication

Select below details :

             Method : PUT
             Media Type : application/XML
            Paste below input XML payload inside request box :

           <?xml version="1.0" encoding="utf-8"?>

Hit the RUN button. You will find "United States of America" as output. Because in Lookup table 'US' country code is mapped to "Unites States of America" as Country Name.

Similarly this time change the CountryCode value to "IS" in input XML payload and hit the RUN button. This time Output will be "ISRAEL"


  1. Thanks for your post!
    And I have a question about Lookups. What is the limitation of the Lookups?
    For example, how many tables can we create in Lookups in maximum? How many records can we insert into a single table in maximum?

    1. Each Lookup is a table and you can create as many as you want depending on your use case

      For a individual lookup, there are no limits to how many records(columns) you can create. However there is a limit of 64 characters in lookup value field

  2. Why we have used PUT operation here for Lookup while developing Integration. Can GET be used for this scenario?


If you have any doubts, Please let me know.