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,Bob@gmail.com 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" : "bob@gmail.com" , "words" :[ { "boundingBox" :[ 3.0212, 3.5047, 4.5837, 3.5039, 4.5769, 3.6886, 3.0129, 3.6787 ], "text" : "bob@gmail.com" , "confidence" :0.951 } ] } ] } ] } }

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?

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)

Answers

How to get values from elements in JSON without indexing?

Weyard Wiz

638

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,
};
}
}
}
}