I'm trying to select all users with a roleId of 4 based on the first element of the array or value. How can I do that? Also, how can I display the roleId? Here's my JSON string:
{
"?xml" : {
"@version" : "1.0",
"@encoding" : "UTF-8"
},
"DataFeed" : {
"@FeedName" : "AdminData",
"People" : [{
"id" : "63",
"active": "1",
"firstName" : "Joe",
"lastName" : "Schmoe",
"roleIds" : {
"int" : "4"
}
} , {
"id" : "65",
"active": "1",
"firstName" : "Steve",
"lastName" : "Jobs",
"roleIds" : {
"int" : ["4", "16", "25", "20", "21", "22", "17", "23", "18"]
}
} , {
"id" : "66",
"active": "1",
"firstName" : "Bill",
"lastName" : "Gates",
"roleIds" : {
"int" : ["3", "16", "25", "20"]
}
}
]
}
}
Here's the query that I'm using:
JObject jsonFeed = JObject.Parse(jsonString);
from people in jsonFeed.SelectTokens("DataFeed.People").SelectMany(i => i)
let ids = people["roleIds.int"]
where (int) people["active"] == 1 &&
(ids.Type == JTokenType.Array) ?
((int[]) ids.ToObject(typeof(int[]))).Any(k => k == 4) :
// <-- this looks through all items in the array.
// I just want to compare against the 1st element
(int) ids == 4
select new {
Id = (int) people["id"],
ResAnFName = (string) people["firstName"],
ResAnLName = (string) people["lastName"],
RoleId = ?? // <-- how do I get the roleID displayed
});
I'm getting the following error on ((int[]) ids.ToObject(typeof(int[]))).Any(k => k == 4)
:
NullReferenceException: Object reference not set to an instance of an object.
In the end, my results should be: Joe Schmoe
& Steve Jobs
, only.
What am I doing wrong?