Curl output to CSV-BASH

Question

with this command i get JSON output:

curl -s -H "Accept: application/json" -X GET "http://192.168.253.21:4440/api/20/project/test/executions?authtoken=kH44NoX35bp1zxohgkMtsOIC9H9tw6UI" | jq -r '.|[.executions[] | select(.job.name != null) | select(.job.name|contains("JIRA_Create_Subtask")) ] | sort_by(.id) | reverse | .[0] | [.status, .job.name, ."date-started".date, ."date-ended".date, .job.project]' > /tmp/1.txt

cat /tmp/1.txt
[
  "succeeded",
  "JIRA_Create_Subtask",
  "2018-04-16T10:00:00Z",
  "2018-04-16T10:00:02Z",
  "test"
]

How to get this output in csv format:

"succeeded","JIRA_Create_Subtask","2018-04-16T10:00:00Z","2018-04-16T10:00:02Z","test"

anubhava · Accepted Answer · 2018-04-16 10:33:05Z

5

You can use @csv format in jq:

curl -s -H "Accept: application/json" -X GET "http://192.168.253.21:4440/api/20/project/test/executions?authtoken=kH44NoX35bp1zxohgkMtsOIC9H9tw6UI" |
jq -r '.|[.executions[] |
   select(.job.name != null) |
   select(.job.name|contains("JIRA_Create_Subtask")) ] |
   sort_by(.id) | reverse | .[0] |
   [.status, .job.name, ."date-started".date, ."date-ended".date, .job.project] |
   @csv'

answered Apr 16, 2018 at 10:33

anubhava

790k67 gold badges603 silver badges671 bronze badges

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

2 Comments

Alwin Jose Over a year ago

getting jq: command not found error.

anubhava Over a year ago

You need to install jq on your system.

oliv · Accepted Answer · 2018-04-16 10:48:43Z

0

If you don't have any space or square brackets in your values, you can use tr:

cat 1.txt | tr -d '[]\n '

tr deletes any [, ], cariage return or space characters.

answered Apr 16, 2018 at 10:48

oliv

13.3k30 silver badges52 bronze badges

Collectives™ on Stack Overflow

Curl output to CSV-BASH

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related