Genzbots
~4 min12 / 14

JSON & XML Activities

Parse JSON or XML strings into structured objects, serialise objects back to JSON, and extract values using JSONPath or dotted paths. Useful when consuming REST APIs, processing config files, or transforming data between formats.

JSON (3)

Get JSON ValueGet JSON Value

Extracts a value from a JSON string using a dot-notation path expression (e.g. "person.address.city" or "items[0].name").

ParameterTypeRequiredDefaultDescription
JsonStringStringYes—The JSON string to query (or a variable containing JSON)
PathStringYes—Dot-notation path to the value (e.g. "person.address.city" or "items[0].name")
ResultStringYes—Variable to store the extracted value

Parse JSONParse JSON

Parses a JSON string into a structured JSON document for further processing.

ParameterTypeRequiredDefaultDescription
JsonStringStringYes—The JSON string to parse (can be a variable containing JSON)
ResultStringYes—Variable to store the parsed JSON document

Serialize JSONSerialize JSON

Converts an object, DataTable, or value to a JSON-formatted string.

ParameterTypeRequiredDefaultDescription
InputValueStringYes—The value, variable, or DataTable to serialize to JSON
IndentedBooleanNotrueIf true, outputs formatted/indented JSON
ResultStringYes—Variable to store the JSON string output

XML (1)

Parse XMLParse XML

Parses an XML string into a structured XML document. Optionally extracts elements using an XPath-like expression.

ParameterTypeRequiredDefaultDescription
XmlStringStringYes—The XML string to parse (or a variable containing XML)
XPathStringNo—Optional element path to extract (e.g. "catalog/book/title" or "root/items/*")
ResultStringYes—Variable to store the parsed XML or extracted value
Was this helpful?
PDF & Image / OCRSystem & Clipboard