Configuring the JSON Converter node

  1. On the General tab, specify this information:
    Configuration name

    Select the configuration that you want to be used for this activity. If you want to use an existing configuration, select a name from the list. If you leave the field blank, the default configuration will be used.

    Converter Type

    Select from these options:

    • JSON->XML: converts JSON to XML. The wrapper name of the JSON text is always needed to convert this into XML. The wrapper name is the outer placeholder element that groups the contents of its inner elements.

      In this example, "people" is the wrapper name:

      { 
         "people": 
              { "firstName": "John", "lastName": "Smith" },	
              { "firstName": "Jane", "lastName": "Doe" } 
      }
    • XML->JSON: converts XML into JSON. Element and attribute names are treated as keys in JSON. This means that when a JSON text is converted back to XML, attributes will be changed to elements in the converted XML.

    • JSON->CSV: converts only a JSON array into CSV format

    • CSV->JSON: converts CSV into a JSON array

    Data to Convert

    Specify the data to be converted. You can select variables, copy-paste, or specify the data in the box.

  2. On the On Error tab, specify this information:
    What should happen on an error?

    Select from the available options.

    Notify

    Select the check box if you want to send a notification when an error occurs. If this option is selected, you must fill out the notification details.

    Custom log entry

    Select the check box if you want a custom log entry in addition to the system-generated log entry.