Task Purpose
The ExcelToJson task reference converts an encoded Base64 Excel file to JSON format.
Properties
Input and output parameters are shown below.
| Incoming | Type | Description |
|---|---|---|
| input | String | Input Base64 Excel content to be converted to JSON. |
| headersIncluded | Boolean | Headers included in input. |
| headerRow | Array | Optional array of headers to use for mapping. |
| Outgoing | Type | Description |
|---|---|---|
| response | String | Response output from the Base64 Excel content. |
How to Configure
In this example we are uploading a spreadsheet with the input variables for the workflow. The Reference variable for the input is the uploaded Excel spreadsheet and is static. The headersIncluded variable is set to True.
You can convert an Excel spreadsheet into Base64 format using an online converter tool of your preferred choice.
Figure 1: Incoming
The response that returns for this task are the spreadsheet values converted into a JSON format. You can view the response of the outgoing properties in Job (Operations) Manager when the task is complete.
Figure 2: Outgoing
Potential Use Case
Let’s say you are building a workflow and you need to convert the user inputs into JSON format. Rather than fill in a JSON form to provide the workflow with the input job variables, you can upload a spreadsheet with the input variables for the workflow. After the spreadsheet values are converted to JSON with the excelToJson task reference, the variables can be queried from the output and used in further tasks.
References
For related information on the excelToJson task, see the excelToJson API reference.