We use cookies on our website to analyze website usage and to help secure the website against misuse. Advertising and functional cookies are not used in our site or our web application products.
By clicking “Accept Essential Cookies Only”, you consent to us placing these cookies.
Convert a JSON string to XML using explicit record and field path mappings
Parses the JSON in the current result buffer and maps it to an XML document using JSONPath expressions. Both the result buffer and the XML document buffer (mdoc) are updated. Field paths can include optional formatting instructions. Use this when the JSON structure does not map cleanly to a simple record/field layout.
| Parameter | Description |
|---|---|
| cmd | JSONPath to the array node containing each record |
| Argument 0 | Field map: comma-separated list of fieldname:jsonpath pairs (relative to each record), or fieldname:instruction:jsonpath for formatted values |
| Argument 1 | 1 to compress output using field tags (default true); 0 to skip compression |
JsonToXMLTable "JSONPath to the array node containing each record", "Field map: comma-separated list of fieldname:jsonpath pairs (relative to each record), or fieldname:instruction:jsonpath for formatted values", "1 to compress output using field tags (default true); 0 to skip compression"