I love JSON-formatted data so much that… anytime I see something valuable stored in this format I really can’t resist the temptation of converting it to CSV so that I can actually browse it and\/or visually understand\/analyze some of it \ud83d\ude42<\/p>\n\n\n\n
I know, I am old-school \ud83d\ude42<\/p>\n\n\n\n
Mitre Att&ck JSON file<\/a> is a maverick on its own. Updated on regular basis, it contains so much cyberjuice that it is almost a crime not to convert it to CSV, at least some of it \ud83d\ude00<\/p>\n\n\n\n How do we go about it?<\/p>\n\n\n\n This is one of the ways… we use the following script<\/a> with the input being latest version of the Mitre Att&ck JSON file. The file’s comments include the actual link<\/a>….<\/p>\n\n\n\n Run it, and see if you like its output… Note that it uses lots of Boolean (0 or 1) output values in many of its columns – this is by design – these may help you to filter the data in Excel or Google Sheets as per your need…<\/p>\n\n\n\n And YES, I know there is jq<\/a>, I know there are JSON readers\/viewers\/beautifiers, and I recently learned of pyattck<\/a>, too. Still, when it comes to data analysis, I really like to keep my options open but also keep them close and control them a bit…<\/p>\n","protected":false},"excerpt":{"rendered":" I love JSON-formatted data so much that… anytime I see something valuable stored in this format I really can’t resist the temptation of converting it to CSV so that I can actually browse it and\/or visually understand\/analyze some of it … Continue reading