Forum Discussion

Wassim's avatar
Wassim
New Contributor
4 years ago
Solved

Problem with copy and join

Hello, I am working on this pipeline The problem is with this part I copy my result set. I keep my first output And aggregate my second output And finally I want to take those a...
Best Practices
j_angelevski's avatar
j_angelevski
Contributor III
5 years ago
Copy LinkReport

Hi @arunnp ,

This can be done with the following steps:

  1. Add JSON Splitter after the input json and split on $result

  2. Add a mapper to map the corresponding values ( you can easily map the values now since they are no longer in an array )

  3. And finally add a Group by N snap to group every object into a single array.

Result:

  {
    "result": [
      {
        "ticketNumber": "INC0029337",
        "description": "test",
        "sys_id": "90a4a74e1be97010ef9f6208b04bcb96",
        "comments": "thh lafldsf. legmsfd",
        "status": "In Progress",
        "lastUpdateTime": "2021-07-26 10:53:28"
      },
      {
        "ticketNumber": "INC0029337",
        "description": "test",
        "sys_id": "90a4a74e1be97010ef9f6208b04bcb96",
        "comments": "thh lafldsf. legmsfd",
        "status": "In Progress",
        "lastUpdateTime": "2021-07-26 10:53:28"
      }
    ]
  }
]