Converts JSON to an XLSX file with the help of Zapier.
Output Parameters
Parameter |
Description |
Example |
---|---|---|
File Content |
The content of the result XLSX 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 XLSX |
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:
|
The action supports JSON in the following formats:
|
Mappings |
Specify XLSX column types and names corresponding to the JSON property. |
The result XLSX column will have this type and a new name. If not specified, the type and name will be inferred from the column values. |
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 JSON 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. |
Download a source JSON file and use the output in the Convert JSON to XLSX File action, or apply raw JSON.