Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to lookup a value in one xml based upon some key in another xml in ICS

edited Mar 1, 2019 5:49AM in Integration 7 comments

Summary

looking for example to use lookup-xml function

Content

Hi ICS community,

We would like to lookup a value from one xml (response received from a REST call) based upon some key value in another XML (response from another REST call). Basically we are looking at a way to join the two separate XML in ICS. We looked at the lookup-xml function and it seems to be doing the same. Below is the example from the oracle documentations.

 

oraext:lookup-xml('file:/d:/country_data.xml', '/Countries/Country', 'Abbreviation', 'FullName', 'UK') returns the value of the element FullName child of /Countries/Country

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!