I've got a JSON service and need to create a script to export data to CSV files. Does anyone have a method or library you can suggest to migrate JSON to CSV format?
Here's an example format though I expect to have to retro-fit the solution to work with it:
{"service_name":
{ key : value, key : value....}
}
or:
{"service_name":
[
{ key : value, key : value....},
...
]
}
i generally agree with the commenters, but if you're data is prepared this way, isn't this pseudo-code all you need?
$json_str = "{'aintlist':[4,3,2,1], 'astringlist':['str1','str2']}";
$json_obj = json_decode ($json_str);
$fp = fopen('file.csv', 'w');
foreach ($json_obj as $fields) {
fputcsv($fp, $fields);
}
fclose($fp);