I'm looking for software that will convert JSON formatted data into CSV formatted data with or without header values.
I'd prefer for this software to be able to take the JSON formatted file from a file and then convert it to a CSV file that I specify which works from command line passing arguments accordingly. If there's something that only works with URLs then I'm happy to look at these as well if the formatted data can then be exported to a flat file.
Requirements
- Open source or free to use for commercial business
- Must be able to run on current Windows OSes such as Windows 10, Server 2012, etc.
- Be command line driven passing parameters in as arguments
- Preferably as a compiled executable file but instruction how to run and pass arguments accordingly from command line otherwise from Windows would work as well
I've found a few things out there on GitHub in JS but I'm having trouble compiling the code with JSC getting error, etc. so I'm not sure if those are Windows compatible or not and I'm new to compiling JS code with Visual Studio or .NET JSC.exe so I may be going about it the wrong way; or just misunderstanding the process since I'm not really an application developer.
Sample Data Unexpected Results
{
"success": true,
"devs": [
{
"id": 911911,
"name": "Test Co",
"tags": [
{
"id": 71111,
"name": "Tank1PSI",
"dataType": "Float",
"description": "",
"alarm": "",
"value": 0,
"quality": "good",
"TagId": 9
},
{
"id": 72222,
"name": "Tank2",
"dataType": "Float",
"description": "",
"alarm": "",
"value": 0,
"quality": "good",
"TagId": 1
},
{
"id": 73333,
"name": "FillTank1",
"dataType": "Bool",
"description": "",
"alarm": "",
"value": 0,
"quality": "good",
"TagId": 3
},
{
"id": 74444,
"name": "FillTank2",
"dataType": "Bool",
"description": "",
"alarm": "",
"value": 0,
"quality": "good",
"TagId": 6
},
{
"id": 75555,
"name": "Line1",
"dataType": "Bool",
"description": "",
"alarm": "",
"value": 0,
"quality": "good",
"TagId": 7
},
{
"id": 76666,
"name": "Line2",
"dataType": "Bool",
"description": "",
"alarm": "",
"value": 0,
"quality": "good",
"TagId": 5
},
{
"id": 77777,
"name": "Tank2PSI",
"dataType": "Float",
"description": "",
"alarm": "",
"value": 0,
"quality": "good",
"TagId": 8
}
],
"lastSynchroDate": "2016-11-09T03:00:00Z"
}
]
}
JSON to CSV conversion
but found notthing. Maybe you could help others by posting your egneral purpose converter to GitHub and giving ht eURL here? – Mawg says reinstate Monica Nov 14 '16 at 14:21