Forum Discussion

deepak_shaw's avatar
deepak_shaw
Contributor
4 years ago
Solved

Key value pair from object array

Hi, I would like to create the below outbound message from an incoming object array. { "root": { "elementName": { "@attributeName": "attributeValue", "$": "el...
Aleksandar_A's avatar
Aleksandar_A
Contributor III
3 years ago

Hi @arvindnsn,

You can try to filter out documents that have “error” keys, and later on to split them using JSON Splitter Snap.

$result.filter(x => x.hasPath("error"))

Let me know if this helps you.

BR,
Aleksandar.

  • deepak_shaw's avatar
    deepak_shaw
    Contributor
    4 years ago

    Hi @bojanvelevski , Amazing 🙂 it’s working as expected.
    Can you please explain a bit about the code you have written in the map i.e.

    $InvoiceLines.map(x=>{"LineNumber":{"@LineExtAmtExclTax":x.LineExtAmtExclTax,"$":x.LineNumber},"value":x.Employee})

    Many thanks for your help,
    Deepak Shaw.

    • bojanvelevski's avatar
      bojanvelevski
      Valued Contributor
      4 years ago
      $InvoiceLines.map(x=>{"LineNumber":{"@LineExtAmtExclTax":x.LineExtAmtExclTax,"$":x.LineNumber},"value":x.Employee})

      I’m glad I could help.

      With the expression above, we’re mapping a specific value to every object inside the $InvoiceLines array. Basically the .map() function will iterate through the array, and for every object, it will map a JSON structure, using the values of that object.