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 casestep. Is there a way to accomplish this? We tried doing SQL Lookup or In Memory lookup but joining with each case step on the code didnโt work. The jsonPath syntax we were using always returned an array of codes and the lookup was failing. Any help is appreciated!
[
{
caseId: 1,
caseDate: โ2017-08-04โ,
caseSteps: [{
code: โxyzโ,
value: 10,
primary: null
},
{
code: โabcโ,
value: 20,
primary: null
},
{
code: โdefโ,
value: 20,
primary: null
}]
},
{
caseId: 2,
caseDate: โ2017-08-04โ,
caseSteps: [{
code: โrewโ,
value: 10,
primary: null
},
{
code: โwbcโ,
value: 20,
primary: null
},
{
code: โwweโ,
value: 20,
primary: null
}]
}
]
Thanks
