How to flatten array of arrays in json using jsonata

Question

I want to flatten an array of arrays in json data into array of objects. I am giving input and expected output. I am not familiar with some flattening functions in jsonata and that's where I need help.

Input:

[
  [
    {
      "date": "2022-09-22",
      "name": "modules/dynatrace",
      "count": 60
    },
    {
      "date": "2022-09-22",
      "name": "modules/dynatrace/monitors/http-monitors/basic",
      "count": 4
    }
    ],
    [
    {
      "date": "2022-09-22",
      "name": "modules/splunk/hec-token",
      "count": 14
    },
    {
      "date": "2022-09-22",
      "name": "modules/aws/lambda/logs_streaming_splunk",
      "count": 29
    }
    ]
]

Output:

[
    {
      "date": "2022-09-22",
      "name": "modules/dynatrace",
      "count": 60
    },
    {
      "date": "2022-09-22",
      "name": "modules/dynatrace/monitors/http-monitors/basic",
      "count": 4
    },
    {
      "date": "2022-09-22",
      "name": "modules/splunk/hec-token",
      "count": 14
    },
    {
      "date": "2022-09-22",
      "name": "modules/aws/lambda/logs_streaming_splunk",
      "count": 29
    }
]

I believe this SO question provides some options: stackoverflow.com/questions/49570172/… — mralex
– mralex, Commented Sep 28, 2022 at 14:33

Ashish Sharma · Accepted Answer · 2022-09-28 14:42:07Z

1

I used below command as mention in the another ticket and it worked for me.|https://stackoverflow.com/questions/49570172/jsonata-query-to-flatten-array-of-arrays

$reduce($, $append)

answered Sep 28, 2022 at 14:42

Ashish Sharma

6801 gold badge11 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to flatten array of arrays in json using jsonata

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related