Skip to main content

Xml To Json

The XML to JSON activity converts XML data into JSON format.

Configuring the Xml To Json Activity

To configure the Xml To Json activity, fill in the required fields in the activity panel.

Configuration

FieldRequiredDescriptionExample
NameRequiredSpecifies the name of the component.MyActivity
DescriptionOptionalOptional description of the component.Reads a file from S3
Field Name SeparatorOptionalDefines the separator used for field names.
Value Field NameOptionalDefines the field name for storing element values.
Whitespace HandlingOptionalControls how whitespace is handled Options: Trim, Preserve, Collapse.Trim, Preserve, Collapse
Skip AttributesOptionalSkips processing attributes.
Skip Element ValuesOptionalSkips processing element values.
Text As ValueOptionalTreats text nodes as values.
Attributes As FieldsOptionalConverts attributes to fields.

Advanced

FieldRequiredDescriptionExample
Strip LevelsOptionalNumber of levels to strip from the structure.
Attribute PrefixOptionalDefines a prefix for attributes.
Naming ConventionOptionalSets naming convention for fields Options: Preserve, Camel Case, Snake Case.Preserve, Camel Case, Snake Case
Attribute HandlingOptionalDefines how attributes are handled Options: Prefix, None, Skip.Prefix, None, Skip
Include NodesOptionalSpecifies nodes to include.
Exclude NodesOptionalSpecifies nodes to exclude.
Force Array PathsOptionalForces paths to be treated as arrays.
Auto Convert NumbersOptionalAuto Convert value to Numbers
Auto Convert Boolean.OptionalAuto Convert value to Boolean.