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

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.
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk