Converting CSV to array using DataWeave

Question

I'm using Mule Requester to load a CSV file. After the file is loaded, the payload is a byte array, which I store in a flow variable, mycsv. I keep getting an exception.

org.mule.api.MessagingException: Exception while executing: 
    NetIds: flowVars.mycsv map $."My Column Name"   
                        ^
Cannot coerce a :binary to a :array (com.mulesoft.weave.mule.exception.WeaveExecutionException). Message payload is of type: byte[]

Here's my DataWeave code:

%dw 1.0
%output application/java
---
{
    Values: flowVars.mycsv map $."My Column Name"
}

The previous flow element is a choice, so I set the metadata on that to output to a FlowVar with the right name and referenced a sample CSV file, so DataWeave things the variable type is List<Csv>.

How can I read the CSV? Thanks!

Ryan Carter · Accepted Answer · 2015-11-30 22:31:03Z

1

It's because it doesnt know the mimeType of the flowVar because it's not set. Try this before the dataweave transformer:

<set-variable value="#[flowVars.mycsv]" variableName="mycsv" mimeType="application/csv" doc:name="Variable" />

or set the mimeType when you first read the csv.

answered Nov 30, 2015 at 22:31

Ryan Carter

11.6k2 gold badges22 silver badges28 bronze badges

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

Comments

vijay narasimha reddy · Accepted Answer · 2018-01-10 15:08:22Z

0

This is the first time I found a requirement to put two different formats into one csv file. In order to get the expected result, I prefer to use this trick: Create both expressions and combine them into one simple array, using flatten Add an empty object as line separator

answered Jan 10, 2018 at 15:08

vijay narasimha reddy

11 bronze badge

Collectives™ on Stack Overflow

Converting CSV to array using DataWeave

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related