exceltojson
  • 25 Oct 2023
  • Dark
    Light
  • PDF

exceltojson

  • Dark
    Light
  • PDF

Article summary

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
01-IAP23.1-input


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
02-IAP23.1-exceltojson-output

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.


Was this article helpful?

What's Next
Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.