Convert - JSON to Excel

Overview

The 'Convert - JSON to Excel' flow action provides the capability to convert the JSON data to provided to a Microsoft Excel or CSV document.

Example Flows

Please refer to the following article showcasing the 'Convert - JSON to Excel' action

• Convert JSON Data to a Microsoft Excel File
• Remove Duplicate Entries in Excel

Credit Count

This action consumes 1 credit per operation.

Note, different Encodian actions can consume different number credits. Please always check the action specific documentation and read What is an Encodian Action for a full description of how credits are consumed.

Parameters

The default 'Convert - JSON to Excel' flow action parameters are detailed below:

• Output Filename: The filename (including extension) of the output document.
• File Content: Optional - A Base64 encoded representation of the JSON file to be processed.
• JSON Data: Optional - The JSON data (as a string) to be processed.

Additional Guidance

• You must provide either a 'File Content' (a file) value or a 'JSON Data' value but not both.
• You can control the output file format by setting the file extension of the 'Output Filename' property, i.e. 'file.xslx' or 'file.csv'

Advanced Parameters

The advanced 'Convert - JSON to Excel' flow action parameters are detailed below:

• First Row: The first row to be written to.
• First Column: The first column to be written to.
• Worksheet Name: The name of the worksheet that the JSON data is added to
• Convert Numeric and Date: Auto parse numeric and date values, setting the cell format category to 'Number' or 'Date'
• Date Format: Set the date and time format - https://learn.microsoft.com/en-us/dotnet/standard/base-types/custom-date-and-time-format-strings
• Numeric Format: Set the numeric format - https://learn.microsoft.com/en-us/dotnet/standard/base-types/standard-numeric-format-strings
• Ignore Null Values: Ignore JSON properties which contain null values
• Title - Font Color: Set the title font color
• Title - Font Bold: Set the title to bold
• Title - Wrap Text: Set whether a titles text is wrapped
• Ignore Attribute Titles: Ignores titles of JSON attributes when converting JSON to Excel
• Culture Name: This setting is used to set the culture for the workbook prior to conversion. Please refer to the Culture Names article for a list of supported cultures. 

Return Parameters

The 'Convert - JSON to Excel' flow action returns the following data. 

Standard Return Values

• Filename - The filename of the document.
• FileContent - The processed Excel document.
• OperationId - The unique ID assigned to this operation.
• HttpStatusCode - The HTTP Status code for the response.
• HttpStatusMessage - The HTTP Status message for the response.
• Errors - An array of error messages should an error occur.
• Operation Status - Indicates whether the operation has been completed, has been queued or has failed.