Learn the essential features and functions of the popular JavaScript framework for building mobile, desktop and web applications.
Extracting Key/values in C#
Hi,
I have the following string:
[
{"Active":true,"Id":"aa-bb
{"Key":"Locale","Value":"e
{"Active":true,"Id":"11-22
{"Key":"Locale","Value":"e
{"Active":true,"Id":"3g-3f
{"Key":"Locale","Value":"F
]
And want to display the following way:
1) if I want to see a specific person's info,
PersonNameA:
Height: 5.8
Locale: en
Age: 21
Sex: Male
PersonID: 0001
2) If I want to see a specific property
Height:
5.8
5.9
6.2
I tried to use dictionary but couldn't make it work.
Any easier way to achieve this?
Thank you guys!
I have the following string:
[
{"Active":true,"Id":"aa-bb
{"Key":"Locale","Value":"e
{"Active":true,"Id":"11-22
{"Key":"Locale","Value":"e
{"Active":true,"Id":"3g-3f
{"Key":"Locale","Value":"F
]
And want to display the following way:
1) if I want to see a specific person's info,
PersonNameA:
Height: 5.8
Locale: en
Age: 21
Sex: Male
PersonID: 0001
2) If I want to see a specific property
Height:
5.8
5.9
6.2
I tried to use dictionary but couldn't make it work.
Any easier way to achieve this?
Thank you guys!
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Create a class to represent that JSON structure:
e.g.
Then you can use a deserializer like JSON.NET to deserialize the string into a class instance:
Then you get Intellisense support on the data:
e.g.
class Person
{
public bool Active { get; set; }
public string Id { get; set; }
public string Name { get; set; }
public KeyValuePair<string, string>[] Properties { get; set; }
}
Then you can use a deserializer like JSON.NET to deserialize the string into a class instance:
Person[] people = JsonConvert.DeserializeObject<Person[]>(SampleString());
Then you get Intellisense support on the data:
*No Points*
Proof of Concept from Kaufmeds recommendation:
-saige-
Proof of Concept from Kaufmeds recommendation:
using System;
using System.Collections.Generic;
using System.Linq;
using Newtonsoft.Json;
namespace EE_Q28695326
{
class Program
{
static string data = @"[
{""Active"":true,""Id"":""aa-bb-cc-dd"",""Name"":""$PersonNameA"",""Properties"":[{""Key"":""Height"",""Value"":""5.8""},{""Key"":""Locale"",""Value"":""en""},{""Key"":""Age"",""Value"":""21""},{""Key"":""Sex"",""Value"":""Male""},{""Key"":""PersonID"",""Value"":""0001""}]},
{""Active"":true,""Id"":""11-22-33-44"",""Name"":""$PersonNameB"",""Properties"":[{""Key"":""Height"",""Value"":""5.9""},{""Key"":""Locale"",""Value"":""en""},{""Key"":""Age"",""Value"":""27""},{""Key"":""Sex"",""Value"":""Female""},{""Key"":""PersonID"",""Value"":""0002""}]},
{""Active"":true,""Id"":""3g-3f-33-77"",""Name"":""$PersonNameC"",""Properties"":[{""Key"":""Height"",""Value"":""6.2""},{""Key"":""Locale"",""Value"":""Fr""},{""Key"":""Age"",""Value"":""31""},{""Key"":""Sex"",""Value"":""Male""},{""Key"":""PersonID"",""Value"":""0003""}]}
]";
static void Main(string[] args)
{
Person[] people = JsonConvert.DeserializeObject<Person[]>(data);
var p1 = (from person in people where person.Name.Equals("$PersonNameA") select person).FirstOrDefault();
if (p1 != null)
{
Console.WriteLine("{0}:", p1.Name);
foreach (var prop in p1.Properties)
Console.WriteLine("{0}: {1}", prop.Key, prop.Value);
}
Console.WriteLine();
var heights = (from person in people
from property in person.Properties
where property.Key.Equals("Height")
select property);
Console.WriteLine("Height:");
foreach (var height in heights)
Console.WriteLine(height.Value);
Console.ReadLine();
}
}
class Person
{
public bool Active { get; set; }
public string Id { get; set; }
public string Name { get; set; }
public KeyValuePair<string, string>[] Properties { get; set; }
}
}
Yes. this is a Json string.
When I enter URL in my program, it returns that result.
Then my program stored it as a string using ReadLine() method.
Actually, I tried
JObject obj = JObject.Parse(resultString
but I got "Error reading JObject from JsonReader. Current JsonReader item is not an object: StartArray. Path '', line 1, position 1." error.
and yes this is the exact string format I am dealing with.
When I enter URL in my program, it returns that result.
Then my program stored it as a string using ReadLine() method.
Actually, I tried
JObject obj = JObject.Parse(resultString
but I got "Error reading JObject from JsonReader. Current JsonReader item is not an object: StartArray. Path '', line 1, position 1." error.
and yes this is the exact string format I am dealing with.
I really appreciate your answer. This is fascinating.
However, you already added extra " around the each key and value string.
It would be very hard if I follow this method since there are more than 10 operations(resources) and so many properties to deal with at the end.
Especially, the result will be different each time. For example, there might be 100 people instead of 3.
However, you already added extra " around the each key and value string.
It would be very hard if I follow this method since there are more than 10 operations(resources) and so many properties to deal with at the end.
Especially, the result will be different each time. For example, there might be 100 people instead of 3.
However, you already added extra " around the each key and value string.If the service you are contacting is returning valid JSON, then these quotes would already be in place. I'm afraid I do not understand what you are implying.
It would be very hard if I follow this method since there are more than 10 operations(resources) and so many properties to deal with at the end.How so?
For example, there might be 100 people instead of 3.So what is the concern?
I got it. I misunderstood it.
It works now!!!
Thank you very much!!!~~
Thank you 'it_saige' as well!
It works now!!!
Thank you very much!!!~~
Thank you 'it_saige' as well!
As Kaufmed stated the escape characters would already be in place. Also regardless of the number of returned objects, the code as presented would parse them all (so long as the returned objects follow the same pattern you provided).
Consider the following:
Fully serialized:
-saige-
Consider the following:
using System;
using System.Collections.Generic;
using System.Linq;
using Newtonsoft.Json;
namespace EE_Q28695326
{
class Program
{
static void Main(string[] args)
{
List<Person> testing = new List<Person>();
for (int i = 0; i < 100; i++)
{
testing.Add(new Person() { Active = true, Id = string.Format("aa-bb-cc-dd-{0:00}", i), Name = string.Format("PersonName{0:00}", i), Properties =
((i % 5 == 0) ? new List<KeyValuePair<string, string>>() { new KeyValuePair<string, string>("Height", (5f * i / 100f).ToString()), new KeyValuePair<string, string>("Locale", "en"), new KeyValuePair<string, string>("Age", (10 + i).ToString()), new KeyValuePair<string, string>("Sex", "Male"), new KeyValuePair<string, string>("PersonID", i.ToString("00000")) }
: (i % 4 == 0) ? new List<KeyValuePair<string, string>>() { new KeyValuePair<string, string>("Locale", "fr"), new KeyValuePair<string, string>("Age", (10 + i).ToString()), new KeyValuePair<string, string>("Sex", "Female"), new KeyValuePair<string, string>("PersonID", i.ToString("00000")) }
: (i % 3 == 0) ? new List<KeyValuePair<string, string>>() { new KeyValuePair<string, string>("Age", (10 + i).ToString()), new KeyValuePair<string, string>("Sex", "Unknown"), new KeyValuePair<string, string>("PersonID", i.ToString("00000")) }
: (i % 2 == 0) ? new List<KeyValuePair<string, string>>() { new KeyValuePair<string, string>("Sex", "Undeclared"), new KeyValuePair<string, string>("PersonID", i.ToString("00000")) }
: (i % 1 == 0) ? new List<KeyValuePair<string, string>>() { new KeyValuePair<string, string>("Sex", "Unknown"), new KeyValuePair<string, string>("PersonID", i.ToString("00000")) }
: new List<KeyValuePair<string, string>>()).ToArray() });
}
string json = JsonConvert.SerializeObject(testing.ToArray());
Person[] people = JsonConvert.DeserializeObject<Person[]>(json);
var p1 = (from person in people where person.Name.Equals("PersonName50") select person).FirstOrDefault();
if (p1 != null)
{
Console.WriteLine("{0}:", p1.Name);
foreach (var prop in p1.Properties)
Console.WriteLine("{0}: {1}", prop.Key, prop.Value);
}
Console.WriteLine();
var heights = (from person in people
from property in person.Properties
where property.Key.Equals("Height")
select property);
Console.WriteLine("Height:");
foreach (var height in heights)
Console.WriteLine(height.Value);
Console.ReadLine();
}
}
class Person
{
public bool Active { get; set; }
public string Id { get; set; }
public string Name { get; set; }
public KeyValuePair<string, string>[] Properties { get; set; }
}
}
Fully serialized:
[{"Active":true,"Id":"aa-bb-cc-dd-00","Name":"PersonName00","Properties":[{"Key":"Height","Value":"0"},{"Key":"Locale","Value":"en"},{"Key":"Age","Value":"10"},{"Key":"Sex","Value":"Male"},{"Key":"PersonID","Value":"00000"}]},{"Active":true,"Id":"aa-bb-cc-dd-01","Name":"PersonName01","Properties":[{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00001"}]},{"Active":true,"Id":"aa-bb-cc-dd-02","Name":"PersonName02","Properties":[{"Key":"Sex","Value":"Undeclared"},{"Key":"PersonID","Value":"00002"}]},{"Active":true,"Id":"aa-bb-cc-dd-03","Name":"PersonName03","Properties":[{"Key":"Age","Value":"13"},{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00003"}]},{"Active":true,"Id":"aa-bb-cc-dd-04","Name":"PersonName04","Properties":[{"Key":"Locale","Value":"fr"},{"Key":"Age","Value":"14"},{"Key":"Sex","Value":"Female"},{"Key":"PersonID","Value":"00004"}]},{"Active":true,"Id":"aa-bb-cc-dd-05","Name":"PersonName05","Properties":[{"Key":"Height","Value":"0.25"},{"Key":"Locale","Value":"en"},{"Key":"Age","Value":"15"},{"Key":"Sex","Value":"Male"},{"Key":"PersonID","Value":"00005"}]},{"Active":true,"Id":"aa-bb-cc-dd-06","Name":"PersonName06","Properties":[{"Key":"Age","Value":"16"},{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00006"}]},{"Active":true,"Id":"aa-bb-cc-dd-07","Name":"PersonName07","Properties":[{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00007"}]},{"Active":true,"Id":"aa-bb-cc-dd-08","Name":"PersonName08","Properties":[{"Key":"Locale","Value":"fr"},{"Key":"Age","Value":"18"},{"Key":"Sex","Value":"Female"},{"Key":"PersonID","Value":"00008"}]},{"Active":true,"Id":"aa-bb-cc-dd-09","Name":"PersonName09","Properties":[{"Key":"Age","Value":"19"},{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00009"}]},{"Active":true,"Id":"aa-bb-cc-dd-10","Name":"PersonName10","Properties":[{"Key":"Height","Value":"0.5"},{"Key":"Locale","Value":"en"},{"Key":"Age","Value":"20"},{"Key":"Sex","Value":"Male"},{"Key":"PersonID","Value":"00010"}]},{"Active":true,"Id":"aa-bb-cc-dd-11","Name":"PersonName11","Properties":[{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00011"}]},{"Active":true,"Id":"aa-bb-cc-dd-12","Name":"PersonName12","Properties":[{"Key":"Locale","Value":"fr"},{"Key":"Age","Value":"22"},{"Key":"Sex","Value":"Female"},{"Key":"PersonID","Value":"00012"}]},{"Active":true,"Id":"aa-bb-cc-dd-13","Name":"PersonName13","Properties":[{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00013"}]},{"Active":true,"Id":"aa-bb-cc-dd-14","Name":"PersonName14","Properties":[{"Key":"Sex","Value":"Undeclared"},{"Key":"PersonID","Value":"00014"}]},{"Active":true,"Id":"aa-bb-cc-dd-15","Name":"PersonName15","Properties":[{"Key":"Height","Value":"0.75"},{"Key":"Locale","Value":"en"},{"Key":"Age","Value":"25"},{"Key":"Sex","Value":"Male"},{"Key":"PersonID","Value":"00015"}]},{"Active":true,"Id":"aa-bb-cc-dd-16","Name":"PersonName16","Properties":[{"Key":"Locale","Value":"fr"},{"Key":"Age","Value":"26"},{"Key":"Sex","Value":"Female"},{"Key":"PersonID","Value":"00016"}]},{"Active":true,"Id":"aa-bb-cc-dd-17","Name":"PersonName17","Properties":[{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00017"}]},{"Active":true,"Id":"aa-bb-cc-dd-18","Name":"PersonName18","Properties":[{"Key":"Age","Value":"28"},{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00018"}]},{"Active":true,"Id":"aa-bb-cc-dd-19","Name":"PersonName19","Properties":[{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00019"}]},{"Active":true,"Id":"aa-bb-cc-dd-20","Name":"PersonName20","Properties":[{"Key":"Height","Value":"1"},{"Key":"Locale","Value":"en"},{"Key":"Age","Value":"30"},{"Key":"Sex","Value":"Male"},{"Key":"PersonID","Value":"00020"}]},{"Active":true,"Id":"aa-bb-cc-dd-21","Name":"PersonName21","Properties":[{"Key":"Age","Value":"31"},{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00021"}]},{"Active":true,"Id":"aa-bb-cc-dd-22","Name":"PersonName22","Properties":[{"Key":"Sex","Value":"Undeclared"},{"Key":"PersonID","Value":"00022"}]},{"Active":true,"Id":"aa-bb-cc-dd-23","Name":"PersonName23","Properties":[{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00023"}]},{"Active":true,"Id":"aa-bb-cc-dd-24","Name":"PersonName24","Properties":[{"Key":"Locale","Value":"fr"},{"Key":"Age","Value":"34"},{"Key":"Sex","Value":"Female"},{"Key":"PersonID","Value":"00024"}]},{"Active":true,"Id":"aa-bb-cc-dd-25","Name":"PersonName25","Properties":[{"Key":"Height","Value":"1.25"},{"Key":"Locale","Value":"en"},{"Key":"Age","Value":"35"},{"Key":"Sex","Value":"Male"},{"Key":"PersonID","Value":"00025"}]},{"Active":true,"Id":"aa-bb-cc-dd-26","Name":"PersonName26","Properties":[{"Key":"Sex","Value":"Undeclared"},{"Key":"PersonID","Value":"00026"}]},{"Active":true,"Id":"aa-bb-cc-dd-27","Name":"PersonName27","Properties":[{"Key":"Age","Value":"37"},{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00027"}]},{"Active":true,"Id":"aa-bb-cc-dd-28","Name":"PersonName28","Properties":[{"Key":"Locale","Value":"fr"},{"Key":"Age","Value":"38"},{"Key":"Sex","Value":"Female"},{"Key":"PersonID","Value":"00028"}]},{"Active":true,"Id":"aa-bb-cc-dd-29","Name":"PersonName29","Properties":[{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00029"}]},{"Active":true,"Id":"aa-bb-cc-dd-30","Name":"PersonName30","Properties":[{"Key":"Height","Value":"1.5"},{"Key":"Locale","Value":"en"},{"Key":"Age","Value":"40"},{"Key":"Sex","Value":"Male"},{"Key":"PersonID","Value":"00030"}]},{"Active":true,"Id":"aa-bb-cc-dd-31","Name":"PersonName31","Properties":[{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00031"}]},{"Active":true,"Id":"aa-bb-cc-dd-32","Name":"PersonName32","Properties":[{"Key":"Locale","Value":"fr"},{"Key":"Age","Value":"42"},{"Key":"Sex","Value":"Female"},{"Key":"PersonID","Value":"00032"}]},{"Active":true,"Id":"aa-bb-cc-dd-33","Name":"PersonName33","Properties":[{"Key":"Age","Value":"43"},{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00033"}]},{"Active":true,"Id":"aa-bb-cc-dd-34","Name":"PersonName34","Properties":[{"Key":"Sex","Value":"Undeclared"},{"Key":"PersonID","Value":"00034"}]},{"Active":true,"Id":"aa-bb-cc-dd-35","Name":"PersonName35","Properties":[{"Key":"Height","Value":"1.75"},{"Key":"Locale","Value":"en"},{"Key":"Age","Value":"45"},{"Key":"Sex","Value":"Male"},{"Key":"PersonID","Value":"00035"}]},{"Active":true,"Id":"aa-bb-cc-dd-36","Name":"PersonName36","Properties":[{"Key":"Locale","Value":"fr"},{"Key":"Age","Value":"46"},{"Key":"Sex","Value":"Female"},{"Key":"PersonID","Value":"00036"}]},{"Active":true,"Id":"aa-bb-cc-dd-37","Name":"PersonName37","Properties":[{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00037"}]},{"Active":true,"Id":"aa-bb-cc-dd-38","Name":"PersonName38","Properties":[{"Key":"Sex","Value":"Undeclared"},{"Key":"PersonID","Value":"00038"}]},{"Active":true,"Id":"aa-bb-cc-dd-39","Name":"PersonName39","Properties":[{"Key":"Age","Value":"49"},{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00039"}]},{"Active":true,"Id":"aa-bb-cc-dd-40","Name":"PersonName40","Properties":[{"Key":"Height","Value":"2"},{"Key":"Locale","Value":"en"},{"Key":"Age","Value":"50"},{"Key":"Sex","Value":"Male"},{"Key":"PersonID","Value":"00040"}]},{"Active":true,"Id":"aa-bb-cc-dd-41","Name":"PersonName41","Properties":[{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00041"}]},{"Active":true,"Id":"aa-bb-cc-dd-42","Name":"PersonName42","Properties":[{"Key":"Age","Value":"52"},{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00042"}]},{"Active":true,"Id":"aa-bb-cc-dd-43","Name":"PersonName43","Properties":[{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00043"}]},{"Active":true,"Id":"aa-bb-cc-dd-44","Name":"PersonName44","Properties":[{"Key":"Locale","Value":"fr"},{"Key":"Age","Value":"54"},{"Key":"Sex","Value":"Female"},{"Key":"PersonID","Value":"00044"}]},{"Active":true,"Id":"aa-bb-cc-dd-45","Name":"PersonName45","Properties":[{"Key":"Height","Value":"2.25"},{"Key":"Locale","Value":"en"},{"Key":"Age","Value":"55"},{"Key":"Sex","Value":"Male"},{"Key":"PersonID","Value":"00045"}]},{"Active":true,"Id":"aa-bb-cc-dd-46","Name":"PersonName46","Properties":[{"Key":"Sex","Value":"Undeclared"},{"Key":"PersonID","Value":"00046"}]},{"Active":true,"Id":"aa-bb-cc-dd-47","Name":"PersonName47","Properties":[{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00047"}]},{"Active":true,"Id":"aa-bb-cc-dd-48","Name":"PersonName48","Properties":[{"Key":"Locale","Value":"fr"},{"Key":"Age","Value":"58"},{"Key":"Sex","Value":"Female"},{"Key":"PersonID","Value":"00048"}]},{"Active":true,"Id":"aa-bb-cc-dd-49","Name":"PersonName49","Properties":[{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00049"}]},{"Active":true,"Id":"aa-bb-cc-dd-50","Name":"PersonName50","Properties":[{"Key":"Height","Value":"2.5"},{"Key":"Locale","Value":"en"},{"Key":"Age","Value":"60"},{"Key":"Sex","Value":"Male"},{"Key":"PersonID","Value":"00050"}]},{"Active":true,"Id":"aa-bb-cc-dd-51","Name":"PersonName51","Properties":[{"Key":"Age","Value":"61"},{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00051"}]},{"Active":true,"Id":"aa-bb-cc-dd-52","Name":"PersonName52","Properties":[{"Key":"Locale","Value":"fr"},{"Key":"Age","Value":"62"},{"Key":"Sex","Value":"Female"},{"Key":"PersonID","Value":"00052"}]},{"Active":true,"Id":"aa-bb-cc-dd-53","Name":"PersonName53","Properties":[{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00053"}]},{"Active":true,"Id":"aa-bb-cc-dd-54","Name":"PersonName54","Properties":[{"Key":"Age","Value":"64"},{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00054"}]},{"Active":true,"Id":"aa-bb-cc-dd-55","Name":"PersonName55","Properties":[{"Key":"Height","Value":"2.75"},{"Key":"Locale","Value":"en"},{"Key":"Age","Value":"65"},{"Key":"Sex","Value":"Male"},{"Key":"PersonID","Value":"00055"}]},{"Active":true,"Id":"aa-bb-cc-dd-56","Name":"PersonName56","Properties":[{"Key":"Locale","Value":"fr"},{"Key":"Age","Value":"66"},{"Key":"Sex","Value":"Female"},{"Key":"PersonID","Value":"00056"}]},{"Active":true,"Id":"aa-bb-cc-dd-57","Name":"PersonName57","Properties":[{"Key":"Age","Value":"67"},{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00057"}]},{"Active":true,"Id":"aa-bb-cc-dd-58","Name":"PersonName58","Properties":[{"Key":"Sex","Value":"Undeclared"},{"Key":"PersonID","Value":"00058"}]},{"Active":true,"Id":"aa-bb-cc-dd-59","Name":"PersonName59","Properties":[{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00059"}]},{"Active":true,"Id":"aa-bb-cc-dd-60","Name":"PersonName60","Properties":[{"Key":"Height","Value":"3"},{"Key":"Locale","Value":"en"},{"Key":"Age","Value":"70"},{"Key":"Sex","Value":"Male"},{"Key":"PersonID","Value":"00060"}]},{"Active":true,"Id":"aa-bb-cc-dd-61","Name":"PersonName61","Properties":[{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00061"}]},{"Active":true,"Id":"aa-bb-cc-dd-62","Name":"PersonName62","Properties":[{"Key":"Sex","Value":"Undeclared"},{"Key":"PersonID","Value":"00062"}]},{"Active":true,"Id":"aa-bb-cc-dd-63","Name":"PersonName63","Properties":[{"Key":"Age","Value":"73"},{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00063"}]},{"Active":true,"Id":"aa-bb-cc-dd-64","Name":"PersonName64","Properties":[{"Key":"Locale","Value":"fr"},{"Key":"Age","Value":"74"},{"Key":"Sex","Value":"Female"},{"Key":"PersonID","Value":"00064"}]},{"Active":true,"Id":"aa-bb-cc-dd-65","Name":"PersonName65","Properties":[{"Key":"Height","Value":"3.25"},{"Key":"Locale","Value":"en"},{"Key":"Age","Value":"75"},{"Key":"Sex","Value":"Male"},{"Key":"PersonID","Value":"00065"}]},{"Active":true,"Id":"aa-bb-cc-dd-66","Name":"PersonName66","Properties":[{"Key":"Age","Value":"76"},{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00066"}]},{"Active":true,"Id":"aa-bb-cc-dd-67","Name":"PersonName67","Properties":[{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00067"}]},{"Active":true,"Id":"aa-bb-cc-dd-68","Name":"PersonName68","Properties":[{"Key":"Locale","Value":"fr"},{"Key":"Age","Value":"78"},{"Key":"Sex","Value":"Female"},{"Key":"PersonID","Value":"00068"}]},{"Active":true,"Id":"aa-bb-cc-dd-69","Name":"PersonName69","Properties":[{"Key":"Age","Value":"79"},{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00069"}]},{"Active":true,"Id":"aa-bb-cc-dd-70","Name":"PersonName70","Properties":[{"Key":"Height","Value":"3.5"},{"Key":"Locale","Value":"en"},{"Key":"Age","Value":"80"},{"Key":"Sex","Value":"Male"},{"Key":"PersonID","Value":"00070"}]},{"Active":true,"Id":"aa-bb-cc-dd-71","Name":"PersonName71","Properties":[{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00071"}]},{"Active":true,"Id":"aa-bb-cc-dd-72","Name":"PersonName72","Properties":[{"Key":"Locale","Value":"fr"},{"Key":"Age","Value":"82"},{"Key":"Sex","Value":"Female"},{"Key":"PersonID","Value":"00072"}]},{"Active":true,"Id":"aa-bb-cc-dd-73","Name":"PersonName73","Properties":[{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00073"}]},{"Active":true,"Id":"aa-bb-cc-dd-74","Name":"PersonName74","Properties":[{"Key":"Sex","Value":"Undeclared"},{"Key":"PersonID","Value":"00074"}]},{"Active":true,"Id":"aa-bb-cc-dd-75","Name":"PersonName75","Properties":[{"Key":"Height","Value":"3.75"},{"Key":"Locale","Value":"en"},{"Key":"Age","Value":"85"},{"Key":"Sex","Value":"Male"},{"Key":"PersonID","Value":"00075"}]},{"Active":true,"Id":"aa-bb-cc-dd-76","Name":"PersonName76","Properties":[{"Key":"Locale","Value":"fr"},{"Key":"Age","Value":"86"},{"Key":"Sex","Value":"Female"},{"Key":"PersonID","Value":"00076"}]},{"Active":true,"Id":"aa-bb-cc-dd-77","Name":"PersonName77","Properties":[{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00077"}]},{"Active":true,"Id":"aa-bb-cc-dd-78","Name":"PersonName78","Properties":[{"Key":"Age","Value":"88"},{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00078"}]},{"Active":true,"Id":"aa-bb-cc-dd-79","Name":"PersonName79","Properties":[{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00079"}]},{"Active":true,"Id":"aa-bb-cc-dd-80","Name":"PersonName80","Properties":[{"Key":"Height","Value":"4"},{"Key":"Locale","Value":"en"},{"Key":"Age","Value":"90"},{"Key":"Sex","Value":"Male"},{"Key":"PersonID","Value":"00080"}]},{"Active":true,"Id":"aa-bb-cc-dd-81","Name":"PersonName81","Properties":[{"Key":"Age","Value":"91"},{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00081"}]},{"Active":true,"Id":"aa-bb-cc-dd-82","Name":"PersonName82","Properties":[{"Key":"Sex","Value":"Undeclared"},{"Key":"PersonID","Value":"00082"}]},{"Active":true,"Id":"aa-bb-cc-dd-83","Name":"PersonName83","Properties":[{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00083"}]},{"Active":true,"Id":"aa-bb-cc-dd-84","Name":"PersonName84","Properties":[{"Key":"Locale","Value":"fr"},{"Key":"Age","Value":"94"},{"Key":"Sex","Value":"Female"},{"Key":"PersonID","Value":"00084"}]},{"Active":true,"Id":"aa-bb-cc-dd-85","Name":"PersonName85","Properties":[{"Key":"Height","Value":"4.25"},{"Key":"Locale","Value":"en"},{"Key":"Age","Value":"95"},{"Key":"Sex","Value":"Male"},{"Key":"PersonID","Value":"00085"}]},{"Active":true,"Id":"aa-bb-cc-dd-86","Name":"PersonName86","Properties":[{"Key":"Sex","Value":"Undeclared"},{"Key":"PersonID","Value":"00086"}]},{"Active":true,"Id":"aa-bb-cc-dd-87","Name":"PersonName87","Properties":[{"Key":"Age","Value":"97"},{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00087"}]},{"Active":true,"Id":"aa-bb-cc-dd-88","Name":"PersonName88","Properties":[{"Key":"Locale","Value":"fr"},{"Key":"Age","Value":"98"},{"Key":"Sex","Value":"Female"},{"Key":"PersonID","Value":"00088"}]},{"Active":true,"Id":"aa-bb-cc-dd-89","Name":"PersonName89","Properties":[{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00089"}]},{"Active":true,"Id":"aa-bb-cc-dd-90","Name":"PersonName90","Properties":[{"Key":"Height","Value":"4.5"},{"Key":"Locale","Value":"en"},{"Key":"Age","Value":"100"},{"Key":"Sex","Value":"Male"},{"Key":"PersonID","Value":"00090"}]},{"Active":true,"Id":"aa-bb-cc-dd-91","Name":"PersonName91","Properties":[{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00091"}]},{"Active":true,"Id":"aa-bb-cc-dd-92","Name":"PersonName92","Properties":[{"Key":"Locale","Value":"fr"},{"Key":"Age","Value":"102"},{"Key":"Sex","Value":"Female"},{"Key":"PersonID","Value":"00092"}]},{"Active":true,"Id":"aa-bb-cc-dd-93","Name":"PersonName93","Properties":[{"Key":"Age","Value":"103"},{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00093"}]},{"Active":true,"Id":"aa-bb-cc-dd-94","Name":"PersonName94","Properties":[{"Key":"Sex","Value":"Undeclared"},{"Key":"PersonID","Value":"00094"}]},{"Active":true,"Id":"aa-bb-cc-dd-95","Name":"PersonName95","Properties":[{"Key":"Height","Value":"4.75"},{"Key":"Locale","Value":"en"},{"Key":"Age","Value":"105"},{"Key":"Sex","Value":"Male"},{"Key":"PersonID","Value":"00095"}]},{"Active":true,"Id":"aa-bb-cc-dd-96","Name":"PersonName96","Properties":[{"Key":"Locale","Value":"fr"},{"Key":"Age","Value":"106"},{"Key":"Sex","Value":"Female"},{"Key":"PersonID","Value":"00096"}]},{"Active":true,"Id":"aa-bb-cc-dd-97","Name":"PersonName97","Properties":[{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00097"}]},{"Active":true,"Id":"aa-bb-cc-dd-98","Name":"PersonName98","Properties":[{"Key":"Sex","Value":"Undeclared"},{"Key":"PersonID","Value":"00098"}]},{"Active":true,"Id":"aa-bb-cc-dd-99","Name":"PersonName99","Properties":[{"Key":"Age","Value":"109"},{"Key":"Sex","Value":"Unknown"},{"Key":"PersonID","Value":"00099"}]}]
-saige-
Premium Content
You need an Expert Office subscription to comment.Start Free Trial