Needs to be dynamic since the rows are dynamic. Also cannot use other 3rd party dll since application is .net 3.5. I am using JavaScriptSerializer
{
"0": {
"caseNumber": "###",
"name": "###, ###",
"birthYear": "###",
"caseLocation": "###",
"caseType": "###",
"dateFiled": "##/##/##",
"type": "",
"query": {
"firstName": "###",
"lastName": "###",
"dateOfBirth": "####-##-##",
"fileDateBegin": "####",
"fileDateEnd": "####"
},
"color": "###",
"names": [
"###, ###"
],
"rank": "###",
"s": ###
},
"1": {
"caseNumber": "###",
"name": "###, ###",
"birthYear": "###",
"caseLocation": "###",
"caseType": "###",
"dateFiled": "##/##/##",
"type": "",
"query": {
"firstName": "###",
"lastName": "###",
"dateOfBirth": "####-##-##",
"fileDateBegin": "####",
"fileDateEnd": "####"
},
"color": "###",
"names": [
"###, ###"
],
"rank": "###",
"s": ###
},
"failed": 0
}
What I have tried:
With jsonconvert. But needed to create a stand alone class since application is .net 3.5 framework and doesn't work with newer newtown.json
Tried this but did not get any rows back.
public class SearchIndex
{
public string caseNumber { get; set; }
public string name { get; set; }
public int? birthYear { get; set; }
public string caseLocation { get; set; }
public string caseType { get; set; }
public DateTime? dateFiled { get; set; }
public string type { get; set; }
public string color { get; set; }
}