Documentation › Convert JSON to CSV

Convert JSON to CSV

Converts JSON to a CSV file with the help of Make.

Parameters

Output Parameters

Parameter

Description

Example

File Content

The content of the result CSV file.

It is the content of the result file.

Input Parameters

Parameter

Description

Example

Connection

To allow your scenarios to get information from and send it to Plumsail Documents, you need to create a connection.

For more information on how to create a connection to Plumsail Documents, see the online Help.

Input type

Defines the source of the JSON.

JSON File or Raw JSON

Source JSON

The option depends on the Input type. You can specify raw JSON here or extract a JSON file content from other apps like:

  • SharePoint

  • Salesforce

  • Box

  • OneDrive

  • Google Drive

  • Dropbox

  • SFTP

  • File System

List of apps

The action supports JSON in the following formats:

[
    {
      "prop": "value"
    },
    {
      "prop": "value"
    }
]

--------------------------------------

{
  "data": [
    {
      "prop": "value"
    },
    {
      "prop": "value"
    }
  ]
}

--------------------------------------

{
  "prop1": {
    "prop2": {
      "prop3": [
        {
          "prop": "value"
        },
        {
          "prop": "value"
        }
      ]
    }
  }
}

Delimiter

Delimiter of columns. By default it’s a comma.

You can select from the following default values: Comma, Semicolon, Tab or Pipe.

Path to JSON array

Specify the property with array explicitly.

Define the path to the array in the JSON to process complex objects like the following:

{
  "data": [
    {
      "prop": "value"
    },
    {
      "prop": "value"
    }
  ],
  "prop1": "value1",
  "prop2": "value2"
}

Locale

The locale that will be applied to the source document.

Specify the locale in order to correctly parse currencies, dates and other depending values.

Example

Download a source JSON file and use the output in the Convert JSON to CSV action, or apply raw JSON.

Convert JSON to CSV example