JSON / XML Extractor — UiPath Expression Builder

JSON

XML

◧ Paste JSON

⊞Upload JSON

⊟ Drop .json file here

Variable Name:

→ jsonObj("key").ToString

◈ Null-Safe

Activity:

◷ Recent (Last 5)

No history yet

▦ JSON Extractor for UiPath — Help & Documentation

VERSION 5.0 · UIPATH COMMUNITY · DEVELOPER TOOL

Overview

v5.0 · 2026

JSON Extractor for UiPath is a browser-based tool that auto-generates every VB.NET expression for any JSON payload. Paste your JSON, click ✡ Generate Expressions, and copy ready-to-use expressions directly into UiPath Studio.

REQUIRED

Add Imports Newtonsoft.Json.Linq in the UiPath Imports panel. For List(Of) expressions also add System.Linq.

Interface Zones

Zone	What It Does
Tab Bar	Up to 5 independent JSON workspaces
Left Panel	JSON editor — Prettify, Minify, Snapshot, Compare toolbar
Right Panel	Upload file, Variable Name input, Null-Safe toggle, Session History
Key / Value Grid	Table of all paths, types, and values with per-row actions
Expressions Panel	All VB.NET expressions with type filters, search, batch copy

Getting Started

Step 1 — Paste JSON into the editor, or drag-and-drop a .json file into the Upload area.
Step 2 — Set your variable name in the input field (default: jsonObj).
Step 3 — Optionally enable Null-Safe mode.
Step 4 — Click ✡ Generate Expressions (or press Ctrl+Enter).
Step 5 — Click Copy next to any expression, or use Copy All to grab everything.

TIP

If your JSON has errors (trailing commas, bare keys, single quotes), a repair bar appears automatically. Click Apply Fix to correct and re-parse.

Editor Toolbar

Button	Shortcut	Action
✦ Prettify	Ctrl+P	Format JSON with indentation
≡ Minify	Ctrl+M	Compact JSON to a single line
▯ Snapshot	—	Save current schema as a baseline
⌛ Compare	—	Diff current JSON against saved snapshot

Expressions

After generating, every JSON node gets a type-aware VB.NET expression. Use the type filter tabs (All / String / Number / Boolean / Object / Array / Null / Pinned) and the search box to narrow results.

Expression Types

JSON Type	Expression
string	`jsonObj("key").ToString`
integer	`CInt(jsonObj("key").ToString)`
decimal	`CDbl(jsonObj("key").ToString)`
boolean	`CBool(jsonObj("key").ToString)`
null	`If(jsonObj("key") Is Nothing, "", ...ToString)`
object	`jsonObj("key").ToObject(Of JObject)()`
array	`jsonObj("key").Count`
root init	`Dim jsonObj As JObject = JsonConvert.DeserializeObject(Of JObject)(jsonString)`

Card Actions

Copy — Copy the main expression to clipboard
Copy Alt / SelectToken — Copy the alternative expression row
◇ / ◈ — Bookmark a path (pins it to the Pinned tab)
↓ — Open Drill-Down Explorer for object or array nodes
Copy All — Copy all visible expressions as a VB.NET block

Batch Copy

Click ▯ Select in the panel header to enter selection mode. Check individual cards, then click ↓ Copy Selected to copy only your chosen expressions.

Null-Safe Mode

When enabled, every expression is wrapped in a VB.NET null guard to prevent NullReferenceException if a field is missing at runtime.

' Null-Safe OFF: jsonObj("customer")("email").ToString ' Null-Safe ON: If(jsonObj("customer")("email") Is Nothing, "", jsonObj("customer")("email").ToString)

Default Values by Type

Type	Default when null
string	""
integer	0
decimal	0.0
boolean	False

Toggle with the ◈ Null-Safe switch in the Variable Name bar, or press Ctrl+Shift+N.

List(Of) Expressions

For arrays with 2 or more object items, the tool auto-generates a LINQ expression to extract all values for a key as a List(Of). Shown only on the index 0 card.

' Single item: jsonObj("orders")(0)("orderId").ToString ' All orderIds as a list: Enumerable.Range(0, jsonObj("orders").Count).AsEnumerable.Select(Function(x) jsonObj("orders")(CInt(x.ToString))("orderId").ToString).ToList

PREREQUISITE

List(Of) expressions require System.Linq to be imported in your UiPath workflow Imports panel.

Tabs & History

Work with up to 5 independent JSON workspaces simultaneously. Each tab has its own editor, expressions, bookmarks, aliases, null-safe setting, and history.

Action	How
Add tab	Click + Add Tab in the tab bar
Switch tab	Click any tab
Rename tab	Double-click the label, type, press `Enter`
Close tab	Hover and click the × button

Session History

The last 5 JSON inputs per tab are saved automatically. Click any history entry to restore it. Click × to remove an entry. History persists across browser sessions.

Keyboard Shortcuts

Shortcut	Action
Ctrl + Enter	Generate Expressions
Ctrl + Shift + C	Copy all expressions
Ctrl + L	Clear all input and output
Ctrl + Shift + N	Toggle Null-Safe mode
Ctrl + P	Prettify JSON
Ctrl + M	Minify JSON
Esc	Close any open modal or dialog

ACTIVE XDocument · —

⚙Settings

Variable Name

Null-Safe

Root: xmlDoc.Root

⏱History

No history yet

⬆Upload File

📂 Drop .xml file here

XML Extractor For UiPath — Help

Quick reference guide

XML Extractor For UiPath

v1.0 · 2026

XML Extractor for UiPath auto-generates every VB.NET expression for any XML payload. Paste XML, click ✡ Generate Expressions, and copy directly into UiPath Studio in under 60 seconds.

REQUIRED

Add System.Xml.Linq in the UiPath Imports panel. This provides XDocument, XElement, and XAttribute.

What Gets Generated

Node Type	Example Expression
Init variable	`Dim xmlDoc As XDocument = XDocument.Parse(xmlString)`
Text leaf	`xmlDoc.Root.Element("Name").Value`
Attribute	`xmlDoc.Root.Element("Employee").Attribute("id").Value`
Element object	`xmlDoc.Root.Element("Address")`
Repeated node	`xmlDoc.Root.Elements("Item").ElementAt(0)`
List of all values	`Enumerable.Range(0,…Count()).Select(Function(x) …).ToList`

Getting Started

Step 1 — Paste XML into the editor, or drag-and-drop a .xml file into the Upload card.
Step 2 — Set your variable name in the Settings card (default: xmlDoc).
Step 3 — Optionally enable the Null-Safe toggle.
Step 4 — Click ✡ Generate Expressions (or press Ctrl+Enter).
Step 5 — Click Copy next to any expression, or use ✡ Copy All Expressions in the export bar.

TIP

If your XML has syntax errors, a repair bar appears above the Generate button. Click Auto-Fix to correct and re-parse.

Editor Toolbar

Button	Shortcut	Action
⊞ Prettify	Ctrl+P	Format XML with indentation
⊟ Minify	Ctrl+M	Strip whitespace to a single line
⊠ Clear	Ctrl+K	Clear editor and reset all output

Expressions

The Expressions panel shows all auto-generated VB.NET expressions. Use the filter tabs (All / Text / Attribute / Element / Elements / List / Pinned) and the search box to find what you need.

Card Actions

Button	Action
Copy	Copy the main expression to clipboard
Copy Alt	Copy the alternate expression
Copy XPath	Copy the equivalent XPath string
Copy List	Copy the List(Of String) expression (repeated nodes only)
↓ Drill	Open Drill-Down Explorer for element / collection nodes
⭐ Pin	Bookmark the expression — appears in the Pinned tab

Batch Copy

Click ▯ Select in the panel header to enter selection mode. Click cards to select them, then use ↓ Copy Selected. Press Esc to exit.

Key / Value Grid

The grid shows every node — path, value, type, and depth. Use the Filter… input to search. Row actions: ◇ bookmark | ○ mark required | ✏ set alias | ↓ drill down. Click ↓ CSV in the grid header to export.

Null-Safe Mode

When enabled, every expression is wrapped in a VB.NET null guard to prevent NullReferenceException if a node is missing at runtime.

Normal: xmlDoc.Root.Element("Email").Value Null-Safe: If(xmlDoc.Root.Element("Email") Is Nothing, "", xmlDoc.Root.Element("Email").Value)

List Expressions

Normal: Enumerable.Range(0, …Elements("Project").Count()).Select(Function(x) …Element("ID").Value).ToList Null-Safe: Enumerable.Range(0, …Elements("Project").Count()).Select(Function(x) If(…Element("ID") Is Nothing, "", …Element("ID").Value)).ToList

Toggle with the Null-Safe pill in the Settings card, or press Ctrl+Shift+N. The NS badge appears on all wrapped expressions.

Tabs & History

Work with up to 5 independent XML workspaces. Each tab has its own XML, expressions, bookmarks, aliases, null-safe setting, and history. Tabs persist across browser sessions.

Action	How
Add tab	Click + Tab in the tab bar
Switch tab	Click any tab
Rename tab	Double-click the label, type, press `Enter`
Close tab	Hover and click the ✕ that appears

Session History

The last 5 XML inputs per tab are saved automatically. Click any entry to reload it into the editor. Click ✕ next to an entry to remove it.

Keyboard Shortcuts

Shortcut	Action
Ctrl+Enter	Generate expressions
Ctrl+P	Prettify XML
Ctrl+M	Minify XML
Ctrl+K	Clear all
Ctrl+Shift+N	Toggle Null-Safe mode
Ctrl+Shift+C	Copy all expressions
Esc	Close any open modal / exit selection mode

Get FREE access to
JSON / XML Extractor Tool

JSON Extractor For UiPath

Get FREE access toJSON / XML Extractor Tool

Get FREE access to
JSON / XML Extractor Tool