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.
0 Comments