JSON TO CSV Conversion In Mule 4

In this tutorial we will demonstrate how can we perform json to csv conversion in mule 4 and perform some more operations while converting to CSV

UseCase-1

Sample JSON

{
"First Name": "John",
"Last Name": "Right",
"Sex": "Male",
"EmployeeID": "123",
"email_address": "[email protected]",
"country": "India",
"date_of_birth": "17-07-1966"
}

Create a sample mule application

Write Transformation to convert json to csv

%dw 2.0
output application/csv quoteValues=true
---
Payload

Write file to local directory

Deploy the application and test the flow

CSV File is created in Local Directory

UseCase-2

Now if we don’t want to write the Header we need to write the transform message as shown below

%dw 2.0
output application/csv quoteValues=true,header=false
---
Payload

Deploy the application and see the result below:

UseCase-3

Now if we want to change the separator, use the below transformation

%dw 2.0
output application/csv quoteValues=true,header=true,separator="|"
---
Payload

Deploy the application and see the result after opening in Text Pad