CSV to JSON


Stuff You Need to Know

This component converts a specified CSV file to JSON. This makes it easy to use and manipulate the data in downstream components. It can use either CSV input from an upstream component, or read from disk.

How to Configure

Component-specific settings:
  • filename (field) - If using a file stored on disk to read from, enter the filename with full path here. If no filename is specified, it will look to the input for the CSV data.

Standard settings:

Click here to view information on standard settings.


What Happens Next

Given a CSV file that looks like this:

ID,Email
82EF7D3F-4370-4B91-9D72-3D609CF9EB47,82EF7D3F-4370-4B91-9D72-3D609CF9EB47@mysite.com


The response would look like this:

{
  "item": {
    "ID": "82EF7D3F-4370-4B91-9D72-3D609CF9EB47",
    "Email": "82EF7D3F-4370-4B91-9D72-3D609CF9EB47@mysite.com"
  }
}