COnvert json and retrive value

{

"files": [

{

"mimetype": null,

"fileinfolder": null,

"file": null,

"filename": null,

"properties": [

{

"value": "Note Sheet",

"name": "DocumentTitle"

{

"value": null,

"name": "PLO_SequenceNumber"

{

"value": null,

"name": "PLO_FileNumber"

{

"value": "Note Sheet",

"name": "PLO_Type"

{

"value": null,

"name": "PLO_PageNumber"

{

"value": "",

"name": "Description"

{

"value": null,

"name": "PLO_TaskID"

{

"value": "{E08BC560-0000-C91E-84E2-779FB801EEF1}",

"name": "vsid"

}

]

{

"mimetype": null,

"fileinfolder": null,

"file": null,

"filename": null,

"properties": [

{

"value": "Running Note Sheet",

"name": "DocumentTitle"

{

"value": null,

"name": "PLO_SequenceNumber"

{

"value": "DLI/ICE/MM/2018/fri5/56460",

"name": "PLO_FileNumber"

{

"value": "Running NoteSheet",

"name": "PLO_Type"

{

"value": null,

"name": "PLO_PageNumber"

{

"value": "",

"name": "Description"

{

"value": null,

"name": "PLO_TaskID"

{

"value": null,

"name": "RecordInformation"

{

"value": "56460",

"name": "PLO_ProcessId"

{

"value": "{908AC560-0000-C329-96D8-99B84D69AA75}",

"name": "vsid"

}

]

{

"mimetype": null,

"fileinfolder": null,

"file": null,

"filename": null,

"properties": [

{

"value": "saxsxs",

"name": "DocumentTitle"

{

"value": "Annexure - 2",

"name": "PLO_SequenceNumber"

{

"value": "DLI/ICE/MM/2018/fri5/56460",

"name": "PLO_FileNumber"

{

"value": "Note Sheet",

"name": "PLO_Type"

{

"value": null,

"name": "PLO_PageNumber"

{

"value": "",

"name": "Description"

{

"value": null,

"name": "PLO_TaskID"

{

"value": "{408AC560-0000-CC1A-89EC-739636328664}",

"name": "vsid"

}

]

{

"mimetype": null,

"fileinfolder": null,

"file": null,

"filename": null,

"properties": [

{

"value": "wdsx",

"name": "DocumentTitle"

{

"value": "Annexure - 1",

"name": "PLO_SequenceNumber"

{

"value": "DLI/ICE/MM/2018/fri5/56460",

"name": "PLO_FileNumber"

{

"value": "Aadhar Card",

"name": "PLO_Type"

{

"value": null,

"name": "PLO_PageNumber"

{

"value": "",

"name": "Description"

{

"value": null,

"name": "PLO_TaskID"

{

"value": "{208AC560-0000-C711-A40D-7A81A1F2B574}",

"name": "vsid"

}

]

}

"referenceId": "121",

"status": "Success",

"errorMessage": "null"

}

this is my json i get i want to store vsid and PLO_SequenceNumber and show it .please help how i desearlise and store in any data table or array or dataset.

You can use below piece of code:

public class afiles
{
public afile[] files { get; set; }
public String referenceId { get; set; }
public String status { get; set; }
public String errorMessage { get; set; }
}
public class afile
{
public String mimetype { get; set; }
public String fileinfolder { get; set; }
public String file { get; set; }
public String filename { get; set; }
public property[] properties { get; set; }
}
public class property
{
public String name { get; set; }
public String value { get; set; }
}
//---
afiles Files = JsonConvert.DeserializeObject(YourJsonString);
foreach (afile af in Files.files)
{
foreach (property p in af.properties)
{
if (p.name == "vsid" || p.name == "PLO_SequenceNumber")
Console.WriteLine(p.name + " = " + p.value);
}
}

Add a reference of Newtonsoft.Json to your project. Please refer to the following for the details:

https://ourcodeworld.com/articles/read/186/how-to-manipulate-and-use-json-with-c-sharp-and-winforms

Please do not come back and say mine is web project. It doesn't matter, it's all the same.

1 Reply

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

Nitin Sontakke8y ago
Accepted answer
You can use below piece of code:
public class afiles
{
  public afile[] files { get; set; }
  public String referenceId { get; set; }
  public String status { get; set; }
  public String errorMessage { get; set; }
}

public class afile
{
  public String mimetype { get; set; }
  public String fileinfolder { get; set; }
  public String file { get; set; }
  public String filename { get; set; }
  public property[] properties { get; set; }
}

public class property
{
  public String name { get; set; }
  public String value { get; set; }
}

//---

afiles Files = JsonConvert.DeserializeObject(YourJsonString);
foreach (afile af in Files.files)
{
  foreach (property p in af.properties)
  {
    if (p.name == "vsid" || p.name == "PLO_SequenceNumber")
      Console.WriteLine(p.name + " = " + p.value);
  }
}
Add a reference of Newtonsoft.Json to your project. Please refer to the following for the details:
https://ourcodeworld.com/articles/read/186/how-to-manipulate-and-use-json-with-c-sharp-and-winforms

Please do not come back and say mine is web project. It doesn't matter, it's all the same.