Documentation › Convert JSON to CSV

Convert JSON to CSV

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

Parameters

Output Parameters

Parameter

Description

Example

File Content

The content of the result CSV file.

It is the content of the result file.

Setup Parameters

Parameter

Description

Example

App

Select the app.

Plumsail Documents

Action event

Select an action from the Plumsail Documents bundle.

Convert JSON to CSV

Account

To allow your zaps 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.

Configure Parameters

Parameter

Description

Example

Source JSON

Specify raw JSON here or extract a JSON file content from other apps like:

  • SharePoint

  • Salesforce

  • Box

  • OneDrive

  • Google Drive

  • Dropbox

  • SFTP

  • File System

Zapier 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.

Specify one of the 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