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.

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