{"id":11130,"date":"2013-12-13T12:50:17","date_gmt":"2013-12-13T07:20:17","guid":{"rendered":"http:\/\/www.tothenew.com\/blog\/?p=11130"},"modified":"2016-12-19T15:07:28","modified_gmt":"2016-12-19T09:37:28","slug":"how-to-parse-json-by-command-line-in-linux","status":"publish","type":"post","link":"https:\/\/www.tothenew.com\/blog\/how-to-parse-json-by-command-line-in-linux\/","title":{"rendered":"How to parse JSON by command Line in Linux"},"content":{"rendered":"

Java development is often challenging, especially when you need to parse JSON from the command line. In my recent\u00a0Java development project<\/a>\u00a0I had\u00a0<\/span>parse JSON from the command line\u00a0<\/strong>and I explored\u00a0available options one-by-one to find a close fit solution which can be implemented quickly.\u00a0<\/span><\/p>\n

Requirements<\/strong><\/span><\/p>\n

To parse json from the command line you’ll need a software called jq<\/a>\u00a0which is a command line JSON processor.<\/p>\n

Installation<\/strong><\/span><\/p>\n

Step1: <\/strong>Download jq<\/em> Binary<\/p>\n

For 64-bit linux OS: \u00a0wget http:\/\/stedolan.github.io\/jq\/download\/linux64\/jq<\/p>\n

For 32-bit linux OS : wget <\/p>\n

Step 2:<\/strong> chmod +x .\/jq <\/span><\/span><\/p>\n

Step 3:<\/strong> sudo cp jq \/usr\/bin<\/span><\/span><\/p>\n

In this blog, I will explain things with the help of Demo.json <\/span><\/span>or demo.txt<\/span><\/span><\/em><\/p>\n

[js]
\n{
\n &quot;OwnerId&quot;: &quot;xyz&quot;,
\n &quot;ReservationId&quot;: &quot;abc&quot;,
\n &quot;Groups&quot;: [],
\n &quot;State&quot;: {
\n &quot;Code&quot;: 0,
\n &quot;Name&quot;: &quot;pending&quot;
\n },
\n &quot;Instances&quot;: [
\n {
\n &quot;Monitoring&quot;: {
\n &quot;State&quot;: &quot;disabled&quot;
\n },
\n &quot;SecurityGroups&quot;: [
\n {
\n &quot;GroupName&quot;: &quot;default&quot;,
\n &quot;GroupId&quot;: &quot;sg-xxxx&quot;
\n }
\n ],
\n &quot;NetworkInterfaces&quot;: [
\n {
\n &quot;PrivateIpAddresses&quot;: [
\n {
\n &quot;PrivateDnsName&quot;: &quot;ip-xx-xx-yy-yyy&quot;,
\n &quot;Primary&quot;: true,
\n &quot;PrivateIpAddress&quot;: &quot;xx.xx.yy.yyy&quot;
\n }
\n ],
\n &quot;PrivateDnsName&quot;: &quot;ip-xxx-xx-yy-yyy&quot;
\n }
\n ]
\n }
\n ]
\n}
\n[\/js]<\/p>\n

Some of the frequently used use-cases have been discussed below with Command and their respective output:<\/p>\n

1 : To parse a JSON object:<\/strong><\/p>\n

Command :<\/p>\n

[js]cat Demo.json | jq ‘.OwnerId'[\/js]<\/p>\n

Output :<\/p>\n

[js]&quot;xyz&quot;[\/js]<\/p>\n

2: To parse a nested JSON object:<\/strong><\/p>\n

Command :<\/p>\n

[js]cat Demo.json | jq ‘.State.Name'[\/js]<\/p>\n

Output :<\/p>\n

[js]&quot;pending&quot;[\/js]<\/p>\n

3: To extract specific fields from a JSON object:<\/strong><\/p>\n

Command :<\/p>\n

[js]cat Demo.json | jq ‘.State | { Code , Name}'[\/js]<\/p>\n

Output :<\/p>\n

[js]{
\n&quot;Name&quot;: &quot;pending&quot;,
\n&quot;Code&quot;: 0
\n}[\/js]<\/p>\n

4: To parse a JSON array:<\/strong><\/p>\n

Command :<\/p>\n

[js]cat Demo.json | jq ‘.Instances[0].Monitoring'[\/js]<\/p>\n

Output :<\/p>\n

[js]{
\n&quot;State&quot;: &quot;disabled&quot;
\n}[\/js]<\/p>\n

Command :<\/p>\n

[js]cat Demo.json | jq ‘.Instances[0].Monitoring.State'[\/js]<\/p>\n

Output :<\/p>\n

[js]&quot;disabled&quot;[\/js]<\/p>\n

Command :<\/p>\n

[js]cat Demo.json | jq ‘.Instances[0].NetworkInterfaces[0].PrivateIpAddresses[0].PrivateDnsName'[\/js]<\/p>\n

Output :<\/p>\n

[js]&quot;ip-xxx-xx-yy-yyy&quot;[\/js]<\/p>\n

In cases where you only need the value; you have to remove the \u201c\u201d by using pipeline in linux<\/em><\/p>\n

Command :<\/p>\n

[js]cat Demo.json | jq ‘.OwnerId’ | cut -d &quot;\\&quot;&quot; -f 2[\/js]<\/p>\n

Output :<\/p>\n

[js]xyz[\/js]<\/p>\n

Hope you will be able to parse JSON by command line for your next project.<\/p>\n","protected":false},"excerpt":{"rendered":"

Java development is often challenging, especially when you need to parse JSON from the command line. In my recent\u00a0Java development project\u00a0I had\u00a0parse JSON from the command line\u00a0and I explored\u00a0available options one-by-one to find a close fit solution which can be implemented quickly.\u00a0 Requirements To parse json from the command line you’ll need a software called […]<\/p>\n","protected":false},"author":89,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":10},"categories":[446,1],"tags":[1249,4263,49,260,1248],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts\/11130"}],"collection":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/users\/89"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/comments?post=11130"}],"version-history":[{"count":0,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts\/11130\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/media?parent=11130"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/categories?post=11130"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/tags?post=11130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}