Generate Array from Array

Question

I have an input like:

[
    {
        "Attachments": [
            {
                "FileType": "pdf"
            },
            {
                "FileType": "txt"
            }
        ],
        "Name": "test"
    },
    {
        "Attachments": [],
        "Name": "test2"
    }
]

]

and the output I want is:

[
    {
        "FileType": "pdf",
        "Name": "test"
    },
    {
        "FileType": "txt",
        "Name": "test"
    },
    {
        "FileType": null,
        "Name": "test2"
    }
]

So, the question is how can I get an array with an element for each combination of attachment and name using DataWeave 2.0?

Shoki · Accepted Answer · 2019-08-06 20:02:34Z

3

This script does, though I wonder if it could be simpler:

%dw 2.0
output application/json
---
flatten(
    payload map ((item) -> 
        if (!isEmpty(item.Attachments)) 
            item.Attachments map ((value) -> 
                {
                    Name: item.Name,
                    FileType: value.FileType
                }
            ) 
        else {
            Name: item.Name,
            FileType: "null"
        } 
    )
)

Input:

[
    {
        "Name": "test",
        "Attachments": [{ "FileType": "pdf" }, { "FileType": "txt" }] 
    },{ 
        "Name": "test2", 
        "Attachments": [] 
    }
]

Output:

[
  {
    "Name": "test",
    "FileType": "pdf"
  },
  {
    "Name": "test",
    "FileType": "txt"
  },
  {
    "Name": "test2",
    "FileType": "null"
  }
]

edited Aug 6, 2019 at 20:02

Shoki

1,5488 silver badges14 bronze badges

answered Aug 4, 2019 at 0:32

aled

26.5k4 gold badges36 silver badges52 bronze badges

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

Collectives™ on Stack Overflow

Generate Array from Array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related