Dataweave 2 - Output multiple JSON by line

Question

My input is a Array of Objects that I want to map to a JSON object.

I want each JSON object to be line per line and the JSON set in the same payload.

My Dataweave code:

 %dw 2.0
 output application/json indent = false
 ---
 payload map (payload, indexOfPayload ) -> {
     id: payload.externalid_c,
     surname: payload.surname__c
         platform: payload.platform__c
 }

Example output I want:

 {"id": "demo", "surname": "anypoint", "platform": "testing"}
 {"id": "demo2", "surname": "studio", "platform": "apple"}
 {"id": "demo3", "surname": "windows", "platform": "microsoft"}

Ryan Carter · Accepted Answer · 2019-05-08 19:43:57Z

3

write as json first to use the writer property to remove indentation, join the list items together seperated by a new line and output as text/plain(cannot use json as its not valid json)

%dw 2.0
output text/plain
---
payload map ((item, index) -> 
    write({id: item.externalid_c,
    surname: item.surname__c,
    platform: item.platform__c
    }, "application/json", {"indent":false}) 

) joinBy  '\r'

edited May 8, 2019 at 19:43

answered May 8, 2019 at 16:44

Ryan Carter

11.6k2 gold badges22 silver badges28 bronze badges

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

2 Comments

gtx911 Over a year ago

It returns

"Message               : "You called the function 'map' with these arguments:    1: Binary ("" as Binary {mediaType: "*/*; charset=UTF-8", encoding: "UTF-8", mimeType: "...)   2: Function ((item:Any, index:Any) -> ???)  But it expects arguments of these types:   1: Array   2: Function

machaval Over a year ago

That is because your input payload doesn't have the mimetype set. Check that on the source of the payload you specify is application/json

machaval · Accepted Answer · 2019-05-08 16:42:25Z

3

Hi you need to use the write function and output it as text plain as the desire output is not a valid json

%dw 2.0
output text/plain
---
payload map ((value, index) -> write(value, "application/json", {indent: false})) joinBy  "\n"

This example shows you how to do it.

answered May 8, 2019 at 16:42

machaval

5,06916 silver badges20 bronze badges

Collectives™ on Stack Overflow

Dataweave 2 - Output multiple JSON by line

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related