Parse JSON

Parse JSON activity takes the JSON data, processes it, and converts it into XML data.

General

The General tab has the following fields.

Field Literal Value/Process Property/Module Property Description
Name None The name to display as the label for the activity in the process.
Schema Type None Specifies the mode for the output data. The following schema types are supported:
  • Generic: converts a JSON string to an XML string
  • XSD: converts a JSON string to an XML document defined using a schema specified in the Output Editor.

The default value in this field is the XSD schema type.

Note: Ensure the schema resource you select does not contain cyclic dependencies on other schemas , or a type that has two child members with the same local name, but different namespaces.
Badgerfish None Specifies the following conversion rules:
  • Select this check box for converting JSON data to XML data with the mapping of XML namespace, XML attribute, CDATA, and so on.
  • Do not select this check box if you want normal conversion rules for mapping data from JSON to XML.

XML attributes are converted into elements when the check box is not selected

Input Json Style None Specifies the method to parse the data.
  • None : Select this option to exclude the root element in the JSON string.
  • Json with Root : Select this option to include the root element in the input JSON string.
  • Anonymous Array : Select this option to accept a Json array without the parent element, where the root element has exactly one child of the type Array.
Use Null For Empty Values None Select the check box to use null in the place of empty values in the JSON. This option is applicable only for Objects and Arrays. This has no effect on primitive types. By default, the check box is not selected.
Ignore Additional JSON Fields None This check box is available when the XSD option is selected in the Schema Type field.

Select the check box to ignore the additional fields received due to the changes made in external payload while processing the schema.

This check box is not selected by default.

Description

Provide a short description for the activity.

Output Editor

From the Output Editor you can define or reference an XML schema for the activity output. You can use the BW JSON Utils tool to generate an XML schema file with a specified JSON file.

Input

The Input tab has the following fields.

Field Description
jsonString The input JSON data for translation.

Output

The output for the Parse JSON activity varies depending on the data schema you specified in the Schema Type field on the General tab.

Fault

The Fault tab lists the possible exceptions generated by this activity. For more information about error codes and the corrective action to take, see the TIBCO BusinessWorks™ Container Edition Error Codes guide.

Fault Generated When..
JSONParserException An exception occurred when parsing the JSON data.