PowerShell vs a really huge JSON file

I had to face a log file in a JSON format, which managed to grow over 700MB with 1 million plus entries in it, and my regular code wasn't able to process it any more. So I was in trouble.


I turned to a search engine and started looking for a solution, and I run into this awesome article from 2014 from the Happy SysAdmin Reading large text files with PowerShell, and the [System.IO.File]::ReadAllLines() code look really promising.


Using this standard .NET method it was easy, and really fast to get the content of the file into the memory. But I still had to convert it into [PSCustomObject[]] and I knew that I cannot simply pass over a 1o million plus lines of text to ConvertFrom-JSON because PowerShell would probably just laugh into my face. And it did.

How to deal with 10 millions of lines of JSON code?

I was lucky, I knew that all entries in my JSON structure look the same, 9 properties, always. And it was a well formatted file, so I could iterate over the lines and parse it by the number of lines. And this Get-JsonContentX was born.

David Sass

David Sass

David is a highly skilled SharePoint Guy who is focusing on Automation, Compliance, Security, Operational Excellence, Quality Assurance and hacking the unexpected out of the technology stack.