How to get values from elements in JSON without indexing?

I have the following code that extracts json elements values and outputs to csv:

public static void Json_to_Csv(string jsonInputFile, string csvFile) {
using(var p = new ChoJSONReader(jsonInputFile).WithJSONPath("$..readResults")) //
"readResults": [{
using(var w = new ChoCSVWriter(csvFile).WithFirstLineHeader()) {
w.Write(p.Select(r1 =>{
var lines = (dynamic[]) r1.lines;
return new {
FileName = jsonInputFile,
Page = r1.page,
PracticeName = lines[2].text,
OwnerFullName = lines[4].text,
OwnerEmail = lines[6].text,
};
}
}
}
}

csv output:

File Name,Page,Practice Name,Owner Full Name,Owner Email

file1.json,1,Some Practice Name,Bob Lee,[email protected]

Currently there is no other contextual information on each item to reference them so the only way is by indexing, e.g. lines[2]

This works for now but I may have other JSON files that have an extra field, therefore the values pulled will be wrong.

In order to address this scenario, how can i pull the values contextually instead of indexing the lines?

Ive tried PracticeName = lines["Practice Name"].text,, but i get Cannot implicitly convert type string to int error

file1.json sample:

{
"status":"succeeded",
"createdDateTime":"2020-10-22T19:35:35Z",
"lastUpdatedDateTime":"2020-10-22T19:35:36Z",
"analyzeResult":{
"version":"3.0.0",
"readResults":[
{
"page":1,
"angle":0,
"width":8.5,
"height":11,
"unit":"inch",
"lines":[
{
"boundingBox":[
0.5016,
1.9141,
2.5726,
1.9141,
2.5726,
2.0741,
0.5016,
2.0741
],
"text":"Account Information",
"words":[
{
"boundingBox":[
0.5016,
1.9345,
1.3399,
1.9345,
1.3399,
2.0741,
0.5016,
2.0741
],
"text":"Account",
"confidence":1
},
{
"boundingBox":[
1.3974,
1.9141,
2.5726,
1.9141,
2.5726,
2.0741,
1.3974,
2.0741
],
"text":"Information",
"confidence":1
}
]
},
{
"boundingBox":[
1.7716,
2.4855,
2.8793,
2.4855,
2.8793,
2.6051,
1.7716,
2.6051
],
"text":"Practice Name",
"words":[
{
"boundingBox":[
1.7716,
2.4855,
2.3803,
2.4855,
2.3803,
2.6051,
1.7716,
2.6051
],
"text":"Practice",
"confidence":1
},
{
"boundingBox":[
2.4362,
2.4948,
2.8793,
2.4948,
2.8793,
2.6051,
2.4362,
2.6051
],
"text":"Name",
"confidence":1
}
]
},
{
"boundingBox":[
2.9993,
2.5257,
4.7148,
2.5257,
4.7148,
2.714,
2.9993,
2.714
],
"text":"Some Practice Name",
"words":[
{
"boundingBox":[
3.0072,
2.5385,
3.6546,
2.5284,
3.6516,
2.7131,
3.0105,
2.712
],
"text":"Some",
"confidence":0.984
},
{
"boundingBox":[
3.6887,
2.5281,
4.2112,
2.5262,
4.2028,
2.7159,
3.6854,
2.7132
],
"text":"Parctice",
"confidence":0.986
},
{
"boundingBox":[
4.2453,
2.5263,
4.7223,
2.5297,
4.7091,
2.72,
4.2366,
2.7161
],
"text":"Name",
"confidence":0.986
}
]
},
{
"boundingBox":[
1.6116,
2.9999,
2.8816,
2.9999,
2.8816,
3.1158,
1.6116,
3.1158
],
"text":"Owner Full Name",
"words":[
{
"boundingBox":[
1.6116,
3.0039,
2.1026,
3.0039,
2.1026,
3.1157,
1.6116,
3.1157
],
"text":"Owner",
"confidence":1
},
{
"boundingBox":[
2.1541,
2.9999,
2.3784,
2.9999,
2.3784,
3.1158,
2.1541,
3.1158
],
"text":"Full",
"confidence":1
},
{
"boundingBox":[
2.4384,
3.0052,
2.8816,
3.0052,
2.8816,
3.1155,
2.4384,
3.1155
],
"text":"Name",
"confidence":1
}
]
},
{
"boundingBox":[
2.9993,
3.0242,
3.6966,
3.0242,
3.6966,
3.2125,
2.9993,
3.2014
],
"text":"Bob Lee",
"words":[
{
"boundingBox":[
3.0063,
3.0303,
3.3439,
3.0349,
3.3461,
3.2125,
3.007,
3.2081
],
"text":"Bob",
"confidence":0.987
},
{
"boundingBox":[
3.3788,
3.0349,
3.6931,
3.0326,
3.697,
3.2121,
3.3813,
3.2125
],
"text":"Lee",
"confidence":0.983
}
]
},
{
"boundingBox":[
1.945,
3.5063,
2.8748,
3.5063,
2.8748,
3.6261,
1.945,
3.6261
],
"text":"Owner Email",
"words":[
{
"boundingBox":[
1.945,
3.5143,
2.4359,
3.5143,
2.4359,
3.6261,
1.945,
3.6261
],
"text":"Owner",
"confidence":1
},
{
"boundingBox":[
2.4874,
3.5063,
2.8748,
3.5063,
2.8748,
3.6259,
2.4874,
3.6259
],
"text":"Email",
"confidence":1
}
]
},
{
"boundingBox":[
3.0104,
3.5005,
4.6042,
3.5005,
4.6042,
3.6888,
3.0104,
3.6777
],
"text":"[email protected]",
"words":[
{
"boundingBox":[
3.0212,
3.5047,
4.5837,
3.5039,
4.5769,
3.6886,
3.0129,
3.6787
],
"text":"[email protected]",
"confidence":0.951
}
]
}
]
}
]
}
}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Weyard Wiz5y ago
Hi @Mageshwaran R

Thnks for your reply. The JSON format you have is very different than what i have provided in the post...

could you demonstrate how i can index contextually into the JSON format I have since the attributes/values have no connection?
Mageshwaran R5y ago
Hi Wiz,
please try this code,
var k={
   "responseObject": {
   "name": "ObjectName",
   "fields": [
   {
     "fieldName": "refId",
     "value": "2170gga35511"
   },
   {
     "fieldName": "telNum",
     "value": "4541885881"
   }]
}};
value1=k.responseObject.fields.find(
function(i)
{return (i.fieldName=="telNum")}).value;
console.log(value1)