Data Parser Node

The Data Parser node enables you to convert JSON or XML data into a list of key-value pairs. You can use it instances such as needing some specific data from a JSON or XML file.

When you double-click the node, the Data parser screen appears with two tabs: Configuration and Transition Actions. The Configuration tab enables you to configure the input file, parse the data, and extract the desired values from the parsed data. Using the Transitions tab, you can configure node on-enter/on-leave operations.

As part of converting JSON or XML data into a list of key-value pairs, you need to first import data from the JSON or XML file, Once imported, you need to parse that data. You can parse a sample data and test it to see how it works.

From the parsed data, you can select the desired variable and then import it. The imported variable is available as an output variable in the Output Variables panel.

Here is the node image:

Interface Elements

Here is the description for interface elements:

Converting JSON or XML Data

You can convert the JSON or the XML data into key-value pairs in four steps: Configuring Input Data, Parsing Data, Testing Data, and Configuring Transition Actions. However, Configuring Transition Actions is optional.

Here is the description for these steps:

Configuring the Input Data

1. Double click the Data Parser Node.
   The Data parser screen appears.
2. On the Data parser screen, click the Configuration tab if it is already not opened by default.
3. On the Configuration tab:

• In the IMPORT DATA FROM field, enter the variable name in which JSON or XML data is stored. For example, $(n4.http.responsebody).
• From the INPUT DATA FORMAT drop-down box, select JSON or XML. This is the format of the input data file.

Parsing the Data

1. In the Sample Body box, enter a sample data. If the input file data format is JSON, then you need to enter JSON sample data. Otherwise, enter XML data.
2. Click the PARSE button located below the PROVIDE DATA INPUT box.
   The parsed data is populated in the SELECT OUTPUT VARIABLES BOX.
3. In the SELECT OUTPUT VARIABLES BOX, select the variables, which you wish to extract. For example, $.glossary.title.

4. Click the IMPORT button located below the SELECT OUTPUT VARIABLES BOX.
   The selected variable is populated in the Variable Path field in the Parsed data output area.
5. In the Parsed data output area, specify a name for the Output variable in the OUTPUT VARIABLE Name field.

The output variable is populated in the Output variables collapsible panel.
Note: If you wish to extract another variable from the SELECT OUTPUT VARIABLES BOX, select that variable, and then follow the above steps from 4 to 6.
7. Click the Save button.

Testing the Data

1. Click the Test button.
   The Test window appears.
2. On the Test window, make the required changes in the Sample body box, and then click the Test button.

Configuring the Transition Actions

As part of configuring transition actions, you can configure on-enter/on-leave operations. However, configuring these are optional.

To configure the transition actions, you need to first configure and then test them.

Here are the steps:

1. On the Data Parser screen, click the Transition Actions tab.
2. On the Transition Actions tab, click Add Action.

The Transition Actions area appears.
3. On the Transition Actions area:

• From the Time drop-down box, select On-enter or On-leave. For example, On-enter.
• From the Acton drop-down box, select an action choosing from the pre-built options.

📘

Tip

To delete an event, click the delete button corresponding to that event. See the image below.

• Click the Test button at the bottom to test it.
• Finally, click the Save button at the bottom.
  The transition actions are configured.