I am caching an xml document in an add to cache shape. this profile has the following structure:
My goal is that in my map, search for example for the name="Bachelors" and then get the id value for it, which for Bachelors is 1. if However my name value was Doctorate, then id= 2 should be returned.
So to achieve this I have added this structure to a cache and added the name as my index.
then in my map, I have added a cache lookup function and then output id. However the id returned is not right when returned. I am not sure what I am missing.
I would really appreciate your help!
Below you can find the screenshots: