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.
|
Copyright © Cloud Software Group, Inc. All rights reserved.