How to saperate specific value from json

Help Studio
, , , , , , , , , ,
1

Hello,

i am getting below as json response from http request
image

i need to saperate scope value only so expected output is - 53002

it give below error if i use deserialize json

image
image837×424 86.9 KB

image
image775×379 45.6 KB

how can i achive this?

2

Probably the problem is caused by square brackets “[{…}]” arround the JSON string.
Remove it before deserializing.

Cheers

3

Try getting the UiPath AidToolBox tool from UiPath AidToolBox | UiPath Marketplace
Then in the tool, access Miscellaneous → More applications → UiPath JSON Utility.

image
image1920×777 207 KB

The UiPath JSON Utility is a browser-based tool that parses any JSON payload and instantly generates ready-to-paste UiPath VB.NET expressions for every key and path in the document. It presents the result across three side-by-side panels: an interactive collapsible JSON tree, a searchable key/value grid, and a full expression sheet with per-field copy buttons. Five built-in sample payloads (Banking API, Invoice, ChatGPT API, E-Commerce Order, OCR Result) let you explore common automation scenarios without loading your own data. All processing runs 100% locally in your browser. No JSON is uploaded or transmitted anywhere.

Why UiPath RPA Developers Need This Tool

Modern RPA automations constantly interact with REST APIs, web services, AI models, and document processing engines — all of which return data as JSON. Translating that JSON into correct UiPath VB.NET accessor expressions is one of the most repetitive and error-prone tasks developers face daily. The UiPath JSON Utility eliminates that friction entirely:

  • No manual expression writing — Instead of hand-coding jsonObj("invoice")("items")(0)("unitPrice").ToString for every field, the tool generates all paths automatically the moment you load the JSON

  • Correct type conversions every time — UiPath’s VB.NET environment requires explicit casting: integers need CInt(), doubles need CDbl(), booleans need CBool(). Getting these wrong causes runtime errors. The tool detects each field’s type and writes the correct cast automatically

  • Null-safe guards included — JSON fields that carry a null value will crash an automation if accessed without a null check. The tool automatically wraps every null field in If(x Is Nothing, "", x.ToString), preventing NullReferenceException errors without any extra effort

  • Instant LINQ for numeric arrays — When an array contains numbers, the tool generates .Sum(Function(x) CDbl(x)) and .Average(Function(x) CDbl(x)) expressions out of the box, ready for invoice totals, OCR confidence scores, rating aggregates, and similar aggregation tasks

  • Nested path navigation without guessing — Deeply nested structures like jsonObj("branch")("address")("city").ToString are assembled automatically, even when the source JSON has many levels of nesting

  • JObject initialization expression included — The tool always generates the correct deserialization line at the top of the expression panel: Dim jsonObj As Newtonsoft.Json.Linq.JObject = Newtonsoft.Json.JsonConvert.DeserializeObject(Of Newtonsoft.Json.Linq.JObject)(jsonString) — useful as a reference whenever a developer starts a new automation that handles JSON

  • Documentation-ready exports — Export the full expression sheet as CSV, TXT, or JSON to share with your team, attach to a Jira ticket, or keep as reference documentation for the automation

  • Works offline and with sensitive data — The tool runs entirely in the browser with no server connection, making it safe to use with real production JSON payloads that may contain sensitive business data

4

Hi @Mathkar_kunal

  1. Use Deserialize JSON Array (not Deserialize JSON)
  2. Then get scope like this:

jsonArray(0)(“scope”).ToString

Output:
You will get : 53002