Convert JSON Array to CSV

Question

Trying to convert a JSON array into a CSV file using jq but not able to succeed. Following is my JSON output from curl command:

{
  "requestID": "463aeb25-f4c3-40ba-a031-e62d698afc6e",
  "signature": {
    "id": "json",
    "ph_no": "json",
    "status": "json"
  },
  "results": [
    {
      "id": "9f34-66758813073c",
      "ph_no": "343434325",
      "status": "active"
    },
    {
      "id": "b1a2-30a14a68c576",
      "ph_no": "6767666764",
      "status": "active"
    },
    {
      "id": "9af4-5b231f05ce37",
      "ph_no": "546745435",
      "status": "active"
    },
    {
      "id": "99bd-ed67fd139074",
      "ph_no": "323246566",
      "status": "active"
    },
    {
      "id": "9ecc-8277c3ffa274",
      "ph_no": "6753643554",
      "status": "active"
    }
  ],
  "status": "success",
  "metrics": {
    "elapsedTime": "29.461027ms",
    "executionTime": "29.364961ms",
    "resultCount": 146,
    "resultSize": 13856
  }
}

I have tried using following referring to some solutions online but not working.

jq  -r '["id","ph_no","status"],(to_entries|.[]|[.key,.value.id,.value.ph_no,.value.status)|@csv'  temp.json

How should i modify the jq command to convert JSON to CSV ?

I need the values part in results which are comma, separated as below: 9f34-66758813073c,343434325,active b1a2-30a14a68c576,6767666764,active — Mayur Kadam
– Mayur Kadam, Commented Jul 23, 2020 at 11:37

Shawn · Accepted Answer · 2020-07-23 11:53:18Z

1

If you just want the results array of objects:

jq -r '(["id","ph_no","status"], (.results[] | [.id, .ph_no, .status])) | @csv' temp.json

answered Jul 23, 2020 at 11:53

Shawn

53.8k3 gold badges29 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Mayur Kadam Over a year ago

Thanks for responding but i do not see any output on console: /var/tmp/jq/jq -r '(["id","ph_no","status"], (.results[] | [.id, .ph_no, .status])) | @csv' test.json

Shawn Over a year ago

@MayurKadam Works for me

Mayur Kadam Over a year ago

Sorry for the late acknowledgement, but it works now. My input json had problem. Thank you so much again :)

Collectives™ on Stack Overflow

Convert JSON Array to CSV

1 Answer 1

3 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Related