Have you ever found yourself from situation where you have one or many json files and you want to parse specific array of data (etc. comments, movie titles, song names)? I have found myself from there multiple times and finally decided to make permantent solution instead of writing custom parser everytime this functionality is needed.
JsonExtract simply takes your file(s) as command line arguments and lets you specify array containing wanted objects and properties of the arrays. Properties are conveniently saved to csv file after extraction is complete.
Using JsonExtract is simple. To get available commands, use:
To extract properties from single file, use:
JsonExtract file.json --array=$.posts --properties=$.title,$.date,$.comment --output=out.csv
To extract properties from multiple files with same structure, use:
JsonExtract C:\comments --array=$.posts --properties=$.title,$.date,$.comment --output=out.csv
Notice that properties JSONPaths are relative to root of of the object inside specified array.
- .NET Framework 4.5
Latest builds can be found from here.