Enter your details below to unlock the full tool — completely free!
Key/value grid will appear here
Expressions will appear here
JSON Extractor For UiPath · Built for the UiPath Community · Rajkumar Durai
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.
Imports Newtonsoft.Json.Linq in the UiPath Imports panel. For List(Of) expressions also add System.Linq.| 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 |
.json file into the Upload area.jsonObj).| 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 |
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.
| 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) |
Click ▯ Select in the panel header to enter selection mode. Check individual cards, then click ↓ Copy Selected to copy only your chosen expressions.
When enabled, every expression is wrapped in a VB.NET null guard to prevent NullReferenceException if a field is missing at runtime.
| 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.
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.
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 |
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.
| 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 |
No history yet
Grid will appear here
Expressions will appear here
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.
XDocument, XElement, and XAttribute.| 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 |
.xml file into the Upload card.xmlDoc).| 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 |
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.
| 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 |
Click ▯ Select in the panel header to enter selection mode. Click cards to select them, then use ↓ Copy Selected. Press Esc to exit.
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.
When enabled, every expression is wrapped in a VB.NET null guard to prevent NullReferenceException if a node is missing at runtime.
Toggle with the Null-Safe pill in the Settings card, or press Ctrl+Shift+N. The NS badge appears on all wrapped expressions.
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 |
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.
| 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 |
XML Extractor For UiPath · Built for the UiPath Community · Rajkumar Durai