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
Thank you for your response, and sorry for the inconvenience with JSON. My requirement is little different. Given the original JSON source, I have to do a lookup on a second JSON source and add the exp_time property to the case step
[
{
“code”: “abc”,
“exp_time”: “30s”
},
{
“code”: “xyz”,
“exp_time”: “20s”
},
{
“code”: “def”,
“exp_time”: “40s”
}
]
The output we are expecting is something like
[
{
“caseId”: 1,
“caseDate”: “2017-08-04”,
“caseSteps”: [{
“code”: “xyz”,
“value”: 10,
“primary”: null,
“exp_time”: “20s”
},
{
“code”: “abc”,
“value”: 20,
“primary”: null,
“exp_time”: “30s”
},
{
“code”: “def”,
“value”: 20,
“primary”: null,
“exp_time”: “40s”
}]
}
]
please post the second json source and mention the condition you want to join.
You can add exp_time to caseSteps in the mapper snap.
That was just a sample to manipulate JSON but you can achieve more granularity.
