DATA FORMAT functions overview

Description

This article provides an overview of the Data Format functions available in RPA. Data Format functions allow you to query, manipulate, and convert structured data in JSON and XML formats.

Key concepts

• JSON – JavaScript Object Notation, a lightweight data format widely used in APIs
• XML – Extensible Markup Language, used in enterprise integrations and legacy systems
• Dot notation – path syntax for navigating JSON (e.g. users.0.name)
• XPath – path syntax for navigating XML (e.g. .//tag[@attr="val"])

Available Data Format Functions

• Query JSON: Queries a value from JSON data using dot notation.
• Set JSON: Sets a value in JSON data at a given path.
• Delete JSON key: Deletes a key from JSON data.
• Merge JSON: Merges two JSON objects together.
• Flatten JSON: Flattens nested JSON into a single-level object.
• Query XML: Queries values from XML data using XPath.
• Set XML: Sets values in XML data using XPath.
• Create XML: Creates XML from structured data.
• JSON to XML: Converts JSON data to XML format.
• XML to JSON: Converts XML data to JSON format.