How to get only one of two items returned
In a mapper snap, my current expression is:
$[‘env:Envelope’][‘env:Body’][‘ns0:uploadFileToUcmResponse’].result[‘$’]
I only want the second value “123109” returned as a string. How can I do this?...
Forum Discussion
Sorry. My attachment didn’t get through due to a .json extension. I’m sending it now after change the extension to .txt.
Copy_output0.txt (3.56 KB)
You are dealing with 2 separate input documents. The Mapper gets these one-by-one, not both of them at once.
Assuming the Mapper’s input is coming from a Json Parser, you can deal with this by unchecking “Process array” in the Json Parser settings. Then the Mapper will receive a single document whose root is an array. Then your expression would look like this:
jsonPath($, "$[*]['env:Envelope']['env:Body']['ns0:uploadFileToUcmResponse'].result['$']")[1]
Another approach is to filter the Mapper’s input so that you’re only getting the second document. To do that, insert a Head snap with an offset of 1.
