2.7 🎨 Let's Format Data

The Formatter tool converts data from one format to another. It is a data conversion tool that helps you prepare data in the exact format needed by your destination system.

Seven Conversion Options Available:

1. JSON to String — Convert structured JSON data into plain text format.

2. String to JSON — Convert plain text into structured JSON data.

3. XML to JSON — Convert XML formatted data into JSON format.

4. JSON to CSV — Convert JSON data into comma-separated values for spreadsheets or exports.

5. CSV to JSON — Convert comma-separated data into structured JSON format.

6. Generate Timestamp — Create a timestamp for the current date and time.

7. Convert Time Zone — Convert time values from one time zone to another.

Create a Batch Workflow and use a Formatter tool. Choose the Generate Timestamp option and give a sample date. Enable console log for this step as well as in the Workflow Settings. Save and execute the workflow to find the formatted result.

🎉 You have successfully used a formatter inside your workflow!

Add another Formatter to Convert JSON to CSV passing

[
  {
    "name": "John Doe",
    "age": 30,
    "email": "[e-mail]",
     "street": "123 Main St",
      "city": "New York",
      "zip": "10001"
  },
  {
    "name": "Jane Smith",
    "age": 25,
    "email": "[e-mail]",
      "street": "456 Elm St",
      "city": "Los Angeles",
      "zip": "90001"
  }
]

Enable console log for the step and execute and check logs.