How to convert the simplest JSON to CSV or Text using jq?

Question

My json like this from the command like curl https://sm.ms/api/upload:

{
  "code": "error",
  "msg": "No files were uploaded."
}

Now I want to get a text like this (all values of this json):

"error", "No files were uploaded."

I use the command curl https://sm.ms/api/upload | jq -r . but I can only get the json content. The document seems like not to support this funtion.

I search for the web for a long time but there's nothing helpful, so I hope you can help me and thank you~

Possible duplicate of [How to convert arbirtrary simple JSON to CSV using jq?](https://stackoverflow.com/questions/32960857/how-to-convert-arbirtrary-simple-json-to-csv-using-jq) — Jeff Mercado, Apr 22 '18 at 18:57

score 3 · Answer 1 · answered Apr 22 '18 at 14:49

3

The output can be formatted as csv by using the --raw-output option:

jq --raw-output '"\"\(.code)\", \"\(.msg)\""'

answered Apr 22 '18 at 14:49

Cole Tierney

score 2 · Accepted Answer · answered Apr 22 '18 at 17:25

2

You might like to consider a generic solution:

jq -r '[.[]] | @csv'

answered Apr 22 '18 at 17:25

peak

2 Answers2