Convert JSON formatted text to an Excel file. This will create an Excel file with one sheet with the provided JSON data in table format.
Application
Microsoft 365 Excel
Inputs (what you have)
Name | Description | Data Type | Required? | Example |
JSON text | JSON text you would like to convert to Excel file. Example: {“Col1”:”value1”,”Col2”:”value2”} | Text (Long) | Yes | {“Col1”:”value1”,”Col2”:”value2”} |
Flatten nested JSON? | Convert nested JSON objects to columns. If false, will leave nested objected as JSON | True/False | No | true |
Excel format | Format of output excel file | Text (Short) | No | xlsx |
Outputs (what you get)
Name | Description | Data Type | Required? | Example |
Converted Excel file | Converted Excel file | File | No |
Outcomes
Name | Description |
Success | This status is selected if the job has successfully completed. |
Requirements
N/A