Remove JSON objects from a large file

Question

I have a JSON file that I want to be able to amend in C#. I want to be able to delete a set of data.

[
{
    "ID": "ID0000001",
    "Name": "ABCD",
    "Std": "4"
},
{
    "ID": "ID5335355",
    "Name": "JKLM",
    "Std": "6"
},
{
    "ID": "ID53534535",
    "Name": "XYZ",
    "Std": "12"
}
]

how to remove the one id,name and std. like this :

{
    "ID": "ID0000001",
    "Name": "ABCD",
    "Std": "4"
}

after delete this json file like this :

[    
{
    "ID": "ID5335355",
    "Name": "JKLM",
    "Std": "6"
},
{
    "ID": "ID53534535",
    "Name": "XYZ",
    "Std": "12"
}
]

I will need to perform one by one delete operations on the Json file. The Json file could contain thousands of results and I really need the most performant way possible.

Any help greatly appreciated.

I think you need to convert JSON to list of objects, remove and serialize it back to JSON — Aleksej Vasinov
– Aleksej Vasinov, Commented Jun 23, 2015 at 11:01
Can these one-by-one operations be batched, or do they have to be performed in isolation? — WiseGuyEh
– WiseGuyEh, Commented Jun 23, 2015 at 11:19
Maybe you should look into BSON format. It will be quicker to parse it — Aleksej Vasinov
– Aleksej Vasinov, Commented Jun 23, 2015 at 11:37

Daniel B · Accepted Answer · 2018-11-28 23:12:06Z

2

You can use Json.NET to deserialize the string into objects. Then use Linq to select the wanted items, and then use Json.NET again to get the JSON string.

public class Item
{
   public int ID {get; set;}
   public string Name{get;set;}
   public int Std {get; set;}
}

var items = JsonConvert.DeserializeObject<List<Item>>(JsonString);

var newJsonString = JsonConvert.SerializeObject(items.Where(i => i.ID != "ID0000001"));

edited Nov 28, 2018 at 23:12

Daniel B

3,2152 gold badges38 silver badges48 bronze badges

answered Jun 23, 2015 at 11:13

yohannist

4,2143 gold badges38 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Mukesh Kumar Over a year ago

I am not able to understand where is the code for deletion, please suggest.

yohannist Over a year ago

items.Where(i => i.ID != "ID0000001") returns all Items except for the one with the id of "ID0000001".

Collectives™ on Stack Overflow

Remove JSON objects from a large file

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related