Transform list of objects into csv using dataweave

Question

I am trying to transform a list of objects to csv using the following code in dataweave:

%dw 1.0
%type company = :object {class: "java.util.ArrayList"}
%input payload application/java
%output application/csv
---
{
    name: payload.name,
    address: payload.address
} as :company

The below is the output that I get when I execute the above data weave code.

name,name
testName,testName2
testAddress,testAddress2

whilst I am expecting the following: (Sample data)

name,address
testName,testAddress
testName2,testAddress2

Help me understand to what am I missing in the data weave component

Shoki · Accepted Answer · 2015-08-25 14:50:38Z

6

In general terms, when using DataWeave you describe your output using a canonical representation which is more or less a super-set of other data formats.

To generate a CSV output you need to generate an array of objects.
Each of these objects represent a CSV row.
Objects in DataWeave are sets of key-value pairs

The mapping should be something like:

%dw 1.0
%output application/csv
---
payload map {
    name: $.name,
    address: $.address
}

The map operation here generates an object with a name and address for each entry in the list. $ represents the implicit variable under iteration (each list entry).

Note: The %input payload application/java directive is not necessary since the content-type for your input (JSON, XML, CSV, etc) is taken from the mule message when it is set, and it defaults to java if it's not present.

answered Aug 25, 2015 at 14:50

Shoki

1,5488 silver badges14 bronze badges

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

Comments

Tilo · Accepted Answer · 2015-08-25 18:28:58Z

1

The following works for me:

INPUT:

%dw 1.0
%output application/java
---
[{
    name: "nameInput",
    address: "addressInput"
}]

MAPPING:

%dw 1.0 %output application/csv
---
payload

OUTPUT:

name,address
nameInput,addressInput

edited Aug 25, 2015 at 18:28

Tilo

3,35529 silver badges33 bronze badges

answered Aug 25, 2015 at 12:51

mtorsing

191 bronze badge

1 Comment

clare Over a year ago

Thanks :) Even though it works it is not what I want. I want to specify the fields that I want in the mapping.

Eric Aya · Accepted Answer · 2018-01-10 15:19:38Z

0

A splitter with xpath as evaluator should do the trick...like:

<splitter evaluator="xpath" expression="/document/article"/>

edited Jan 10, 2018 at 15:19

Eric Aya

70.2k36 gold badges190 silver badges266 bronze badges

answered Jan 10, 2018 at 15:04

vijay narasimha reddy

11 bronze badge

Comments

user6017600 · Accepted Answer · 2020-01-08 09:03:02Z

0

For me, similar as @Tilo descirbed in his post, but I had to put extra "flatten" because I had Array of Arrays as my input.

MAPPING:

%dw 1.0
%output application/csv
---
flatten payload

answered Jan 8, 2020 at 9:03

user6017600

Collectives™ on Stack Overflow

Transform list of objects into csv using dataweave

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related