How to remove the indentation from json output ? in MuleSoft 131

  How to remove the indentation from json output ? in MuleSoft

Here are two primary methods to remove indentation from the JSON output in MuleSoft 4:

Method 1: Using DataWeave:

DataWeave provides a built-in way to control the output formatting, allowing you to remove indentation.

%dw 2.0
---
// Sample JSON object
var data = {
  "name": "John",
  "age": 30,
  "city": "New York"
};

// Set the output format to compact (no indentation)
output application/json compact

---
write(data, application/json);

Explanation:

1. Define the JSON object (data).

2. Set the output format using the output directive:

• application/json: Specifies the content type as JSON.

• compact: Instructs DataWeave to produce a compact JSON output without indentation.

3. The write function writes the data object to the output stream in the specified format (JSON without indentation).

Method 2: Using MEL (Message Expression Language):

While MEL doesn't directly offer formatting options, you can achieve this by leveraging a transformer component. Here's an example:

XML

<transformer ref="JSONTransformer">
  <input doc:name="Input Payload" />
  <output doc:name="Output Payload">#[payload.toString().replaceAll('\n', '')]</output>
</transformer>

Explanation:

1. A JSON Transformer component is used to modify the payload.

2. The input property references the incoming payload.

3. The output property defines the transformed payload:

• #[payload.toString()]: Converts the payload to a string representation.

• .replaceAll('\n', ''): Removes all newline characters (\n) from the string, effectively removing indentation.

Choosing the Right Approach:

• DataWeave: This is the preferred method as it offers a more declarative and concise approach to control the output formatting directly within your DataWeave script.

• MEL: While functional, the MEL approach requires an additional transformer component and might be less readable for complex formatting requirements.

Additional Considerations:

• Ensure the payload is a valid JSON object before applying these methods.

• Consider using a consistent formatting approach throughout your Mule application for better maintainability.

Here are some helpful resources for further exploration:

• DataWeave output directive: https://docs.mulesoft.com/dataweave/latest/dataweave-formats-json

• MEL replaceAll function: https://help.mulesoft.com/s/question/0D52T00004xzuprSAA/how-to-replace-a-part-of-a-string-in-mule-3-

Remember that using DataWeave provides a more streamlined and efficient way to manage JSON output formatting within your MuleSoft 4 applications.