UiPath-ADPv1 Advanced Data Manipulation Practice Question
You are processing a large JSON string containing employee records. Which LINQ expression correctly extracts a list of names for all employees whose 'department' is 'Finance'?
⚠ Common exam trap
Many test-takers try to query JSON strings using direct DataTable filtering activities without realizing the JSON must first be parsed into a LINQ-compatible object.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
JArray.Parse(jsonString).Where(Function(x) x("department").ToString = "Finance").Select(Function(x) x("name").ToString).ToList()
Selecting data from JSON strings efficiently requires parsing the string into a JObject or JArray using Newtonsoft.Json. The LINQ 'Where' clause filters the collection based on the property value, while the 'Select' method projects only the required field. Mastering these transformations is crucial for handling complex API responses, reducing code complexity compared to traditional For Each loops, and ensuring high-performance data processing within large-scale UiPath automation projects.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
JArray.Parse(jsonString).Select(Function(x) x("name")).Where(Function(x) x("department").ToString = "Finance")
Why it's wrong here
The order of operations is incorrect here. You must filter the objects using the Where clause before projecting the specific name property. Attempting to select the name first results in an object that no longer contains the department property, causing a null reference or runtime exception during execution.
- ✓
JArray.Parse(jsonString).Where(Function(x) x("department").ToString = "Finance").Select(Function(x) x("name").ToString).ToList()
Why this is correct
This expression correctly parses the JSON into a collection, filters the elements where the department matches the string 'Finance', and projects only the name field. Converting to a list ensures the result is usable in subsequent activities like For Each or data table manipulation within the workflow.
- ✗
JArray.Parse(jsonString).Filter(Function(x) x("department") = "Finance").Map(Function(x) x("name"))
Why it's wrong here
UiPath LINQ syntax does not support 'Filter' or 'Map' methods natively on JArray objects. These methods belong to other programming languages or specific framework extensions not included in the standard UiPath.Core.Activities. Using these methods will cause a compilation error as the methods are not defined for the JToken type.
- ✗
JObject.Parse(jsonString).Select(Function(x) x("name").Where(Function(y) y("department") = "Finance"))
Why it's wrong here
JObject represents a single JSON object, not an array. Attempting to use LINQ directly on a JObject without indexing into the specific array property will result in a runtime exception. This approach fails to navigate the document structure correctly, as the root element is typically a JSON array.
About these practice questions
Courseiva writes every UiPath-ADPv1 question from scratch — 276 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official UiPath exam blueprint
This UiPath-ADPv1 practice question is part of Courseiva's free UiPath certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the UiPath-ADPv1 exam.