Скачать или смотреть How to Create a Pipe Delimited CSV File in Multipart Form Data Using DataWeave

Learn how to create a pipe delimited CSV file in multipart form data using DataWeave, ensuring seamless data transmission in APIs.
---
This video is based on the question https://stackoverflow.com/q/77786387/ asked by the user 'Prasanth Vukoti' ( https://stackoverflow.com/u/23218271/ ) and on the answer https://stackoverflow.com/a/77787005/ provided by the user 'aled' ( https://stackoverflow.com/u/721855/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, comments, revision history etc. For example, the original title of the Question was: How to create pipe delimited csv file in multipart form data in dataweave

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
Creating a Pipe Delimited CSV File in Multipart Form Data with DataWeave

If you're working with MuleSoft and DataWeave to send data to APIs, you might find yourself needing to format your data in a specific way. One common requirement is sending a CSV file with custom delimiters, such as using a pipe (|) instead of the default comma (,). This guide addresses how to accomplish this using DataWeave.

The Problem

While attempting to send a CSV file with pipe-separated values as multipart form data, many developers encounter an issue where the data transforms into comma-separated values. This can be particularly troublesome when the receiving API expects a specific format, leading to failed data transmissions.

Example Scenario

You may have the following payload:

[[See Video to Reveal this Text or Code Snippet]]

As a result of your efforts, you end up with the following output:

[[See Video to Reveal this Text or Code Snippet]]

As seen above, the expected pipe-separated format is lost, causing the data not to conform to the requirements of the receiving API.

The Solution

To resolve the issue of creating a pipe-delimited CSV file while sending it as multipart form data, you can leverage the write() function in DataWeave. This function allows fine control over how the data is structured and formatted. Here's a structured breakdown of the solution.

Step-by-Step Solution

Revising the DataWeave Script: Make the following modification in your DataWeave code:

[[See Video to Reveal this Text or Code Snippet]]



{
"parts": {
"upload": {
"headers": {
"Content-Disposition": {
"name": "upload",
"filename": "test.csv",
},
"Content-Type": "application/csv"
},
"content": write(payload, "application/csv", {separator: "|"})
}
}
}

[[See Video to Reveal this Text or Code Snippet]]

------=_Part_9925_416179401.1704798991668
Content-Type: application/csv
Content-Disposition: form-data; name="upload"; filename="test.csv"

id|name
001|test
002|test
003|test

-----=_Part_9925_416179401.1704798991668-

[[See Video to Reveal this Text or Code Snippet]]