Member since
04-22-2020
9
Posts
0
Kudos Received
0
Solutions
09-24-2020
05:56 AM
@ravi_sh_DS This gets a bit high level, so forgive me, as I am not sure how you know which ID to change and what to change it too. That said, your approach could be to use QueryRecord and find the match you want, then update that match with UpdateRecord. You can also split the json image array with SplitJson, then use UpdateRecord as suggested above. In either method depending on your Use Case when you split the records and process the splits separately you may need to rejoin them downstream. Some older methods useful here are SplitJson, EvaluateJson, UpdateAttribute, AttributeToJson, but the Query Update Records are now preferred as it is possible to do things more dynamically.
... View more
06-28-2020
06:26 AM
Hi @ravi_sh_DS, I am perfectly getting the output after using the joltTransformRecord The spec I used is the same that you mentioned in your question. I don't think that the processor is converting the xml into json at first. Had it been that case, jolt must be acting on { "note":{ "to":"...", "from":"...", "heading":"...", "body":"..." } } Even if the jolt is applied on the above json, your ouput will be empty json object. Can you check it once again?
... View more
04-24-2020
07:45 AM
I have some sort of the same scenario. But I have to route out on department value, like department="IT" route to some other flow and for department="DB" route to another flow. For that, I have written out expression as $.[?(@.department=="DB")]. But this doesn't work. Please suggest for the above scenario. And also if we have to apply some conditions like route data for a>10 like that.
... View more