
Provided knowledge and individual mentoring to team members as neededĪmong top 3% overall in terms of contribution on Stack Overflow (~2.3 million people reached my posts). Specialises in problem identification and proposal of alternative solutions. NET frameworkĮxperienced and skilled Agile Developer with a strong record of excellent teamwork, successful coding & project management. Microsoft Certified Professional (MCP) with over 12+ years of software industry experience including development, implementation & deployment of applications in the. NET Professional | Microsoft Certified Professional | DZone’s Most Valuable Blogger | Web Developer | Author | Bloggerĭoctorate in Computer Science and Engineering

"Desc": "Hyundai Verna S Plus Diesel Sample Desc",

"Desc": "Hyundai Verna S Plus Sample Desc", "Desc": "Hyundai Creta SX Opt Diesel AT Sample Desc", "Name": "Hyundai Creta SX Opt Diesel AT", "Desc": "Hyundai Creta SX Executive Sample Desc", $outputJSONFile = “D:\CSV to Json Sample\SampleDataCarInfo.json” Step 3: Execute PowerShell script to convert CSV Data to Complex Nested JSON $inputCSVFile = “D:\CSV to Json Sample\SampleDataCarInfo.csv” $toJSON = import-csv $inputCSVFile | Group-Object -Property Make, MakeDescription | ForEach-Object | Out-File $outputJSONFile -Force $outputJSONFile = "D:\CSV to Json Sample\SampleDataCarInfo.json" Step 2: PowerShell script to convert CSV Data to Complex Nested JSONĬSVToJson.ps1 PowerShell script content: $inputCSVFile = "D:\CSV to Json Sample\SampleDataCarInfo.csv" Refer for PowerShell script to convert Complex Nested JSON to CSV file format Step 1: Sample Input CSV Data In this post, I will be sharing how we can convert CSV to Complex Nested JSON using a PowerShell script.

So, recently I was working on creating a PowerShell script that can convert CSV data to Complex Nested JSON as per requirements. Doing that manually is both error prone & tedious task. Frequently, we get raw data in the form of excel or csv format and for writing test cases or for testing APIs, we need to convert that data to JSON format.
