Convert to JSON

The Convert to JSON (JavaScript Object Notation) block allows users to transform structured data formats, such as CSV, XML, and Excel, into JSON, which is widely used for data exchange and automation processes.

This feature enhances the ability to process and transfer data efficiently between applications.

Note: This feature is available starting from Release 2025.1.

This block allows users to transform Excel, CSV, and XML files to JSON format, making them easier to share, store, and process in automation workflows.

Example: A CSV file containing customer data can be converted to JSON and then sent to another system via an API call.

Fully expanded, the Convert to JSON block shows the following properties:

The Block Header ("Convert to JSON")

The green input connector in the header is used to trigger the block to start executing.

The green output connector in the header triggers when the file type has been successfully converted to text.

The title of the block “Convert to JSON” can be changed by double-clicking on it and typing in a new title.

Source Type

Once you drag the file into the block, the block will automatically recognize the file type. A user can choose any of the below options as a source type:

• Data File: File for upload will be saved inside of Leapwork.
• Local Path: File for upload will be referred to from a specified path.
• Cloud Input: Files can be sent from other blocks via the “Input” property.

Select file to convert

This field allows you to drop the file that is to be converted.

Output

This property contains the output result of the block, which will be JSON data once the conversion process is completed.

The blue output connector triggers when the file type has been successfully converted to text and can be used as the source element in other building blocks.

Not Converted

This green output connector triggers if the file type is not converted within the time specified in the timeout field.

This connector can be used to branch the execution of the flow based on whether the file type is converted or not.

Default Timeout

If the Default Timeout property checkbox is not selected, then the timeout value is 10 seconds. If the Default Timeout property checkbox is selected, then the Default Timeout value selected in the flow settings will be applicable.

Timeout

The maximum time spent converting the file type before giving up and triggering the Not converted connector.

Note: All cases have a global timeout that can be configured in the Settings panel. This is unrelated to the timeout of a single building block. However, a running case will automatically be cancelled if it runs for longer than the global timeout.

Created 2025.02.07