Convert JSON file to CSV
Hope this is the right place.
Freshdesk reports gives you option to export the activities for last 24hr.
This file generate as JSON file.
I build a script that download it locally. now i need to convert it from JSON to CSV automatically.
Can someone help me with this one?
You didn't say what platform / programming language you are using?
Powershell has commands to do this:
This works fine on Windows with Powershell 5.1.
I just searched the docs for PS 6.0 which is cross-platform (Mac, Linux) and there are similar utitilites.
I had this issue also.
In case you haven't solved this, I used jq, which runs on windows and linux type systems.
You can use (for example) :
<your_url_call> | jq -r ".results | [ .id ] | @csv"
Hope this helps