Lookup on an array in the input document
Hello,
I have a incoming JSON document that has cases and array of casesteps inside. I need to do a lookup on the case step code from a table in the database and add additional properties to the ca...
Forum Discussion
[{, …}, {, …}]
{codeArr:[xyz, abc, def], codeStr:xyz,abc,def}
“codeArr”: [xyz, abc, def]
“xyz”,
“abc”,
“def”
“codeStr”: “xyz,abc,def”
{codeArr:[rew, wbc, wwe], codeStr:rew,wbc,wwe}
“codeArr”: [rew, wbc, wwe]
“rew”,
“wbc”,
“wwe”“codeStr”: “rew,wbc,wwe”
Is this what you were expecting? of course if you want a single value from the code, you would need to define the criteria.
You can further do all variations
PS: It would be nice if you pasted your entire RAW json. I had to plugin the "" around all json elements and jsonify it to get the exact format.
