Convert JSON to CSV or unstructured text

Question

How might you take JSON output (e.g., from http://www.kinggary.com/tools/todoist-export.php) and strip the names to yield just the values from each pair, as CSV or human-friendly text? Want a more readable, human-editable backup of my friend's data on todoist.com

Answer 1

Can you JSON decode it to an array and just iterate the array for values? A sample of the JSON output would be helpful.

Answer 2

Your example site generates XML for me, not JSON. In either case I'd probably reach for Ruby:

require 'net/http'
require 'rexml/document'

xml = Net::HTTP.get_response(URI.parse("http://www.kinggary.com/tools/todoist-export.php?completed=incomplete&retrieval=view&submit=Submit&process=true&key=MYKEY")).body

data = REXML::Document.new(xml)

data.elements.each('//task/content') do |e| 
  puts e.text 
end

Answer 3

What language? PHP has a json_decode() function that turns the JSON into an object or associative array. You could then loop through the array or get the values from the object to turn it into whatever format you like.