Lookup integration testing

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.

       
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″?>
           <IntegrationRequest>
           <Input>
          <CountryCode>US</CountryCode>
          </Input>
          </IntegrationRequest>
       

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”

• 

  Anonymous April 26, 2021 at 2:30 am - Reply

  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?
• 

  Anonymous February 9, 2022 at 4:56 pm - Reply

  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
• 

  Anonymous February 8, 2023 at 7:19 am - Reply

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