Mulesoft Dataweave convert CSV to map dynamically

Question

I've created a flow that accepts a CSV via a form-data API POST and then processes each row in a batch job. Ideally, I do not want to hand-map each column before passing it to the batch executor, but I could not figure out how to just "pass through" the key/value pairs dynamically. I want to ensure that the CSV can have new columns and we'll pass them through without knowing about them beforehand... This is what I have:

%dw 1.0
%output application/java
---
payload map {
    title: $.title,
    description: $.description,
    template_id: $.template_id,
    pricing_flat_price: $.pricing_flat_price,
    scheduled_start_date: $.scheduled_start_date,
    resource_id: $.resource_id,
    industry_id: $.industry_id,
    owner_email: $.owner_email,
    location_offsite: $.location_offsite
}

And this is what I'm going for (in non-sensical psuedocode):

%dw 1.0
%output application/java
---
payload map {
    *:*
}

I have to imagine this is easily done, but I couldn't figure it out.

Thank you, Steve

Manik Magar · Accepted Answer · 2017-07-18 19:42:21Z

0

You can simply use transformation like below -

%dw 1.0
%output application/java
---
(payload)

answered Jul 18, 2017 at 19:42

Manik Magar

1,4012 gold badges10 silver badges21 bronze badges

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

Comments

Jason Estevan · Accepted Answer · 2017-07-18 18:25:55Z

0

hand-map each column before passing it to the batch executor

You shouldn't need to do this. Pass the whole csv to the batch-input phase and allow it to split each line into a Linked Hashmap.

answered Jul 18, 2017 at 18:25

Jason Estevan

1137 bronze badges

1 Comment

Steve N Over a year ago

This did not work for me. Error indicated the input class was not the right type.

Collectives™ on Stack Overflow

Mulesoft Dataweave convert CSV to map dynamically

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related