Configuring the JSON Converter node
- On the General tab, specify this information:
- Configuration name
-
Select the configuration to use for this activity. To use an existing configuration, select a name from the list. If you leave the field blank, the default configuration is 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.
- On the On Error tab, specify this information:
- What should happen on an error?
-
Select from the available options.
- Notify
-
Select this check box to send a notification when an error occurs. If this option is selected, you must fill out the notification details.
- Custom log entry
-
Select this check box to have a custom log entry in addition to the system-generated log entry.