Getting from CSV to JSON is pretty easy[Reading Time: < 1 minute]
This is a short reminder for myself, but could be helpfull for someone else out there. Nothing new!
I often look for easy solution, that resolve “easy” problems. This is one: “Convert something to something”.
After looking arround in the outer spheres of Internet, I realize, that OoB tools can do the job better or at least without any dependencies or such things.
So, how to convert a regular CSV to JSON? Take PowerShell!
Get-Content -Path $csvPath | ConvertFrom-Csv -Delimiter "`t" | ConvertTo-Json | Set-Content -Path $jsonPath -Encoding UTF8
It’s easy, isnt’it 🙂