{"id":12067,"date":"2015-03-22T23:44:00","date_gmt":"2015-03-22T22:44:00","guid":{"rendered":"http:\/\/touk.pl\/blog\/?guid=31b53e4947b4a5fcebd0a69e54a9d321"},"modified":"2022-07-27T15:58:48","modified_gmt":"2022-07-27T13:58:48","slug":"need-to-make-a-quick-json-fixes-jsonpath-for-rescue","status":"publish","type":"post","link":"https:\/\/touk.pl\/blog\/2015\/03\/22\/need-to-make-a-quick-json-fixes-jsonpath-for-rescue\/","title":{"rendered":"Need to make a quick json fixes – JSONPath for rescue"},"content":{"rendered":"

From time to time I have a need to do some fixes in my json data. In a world of flat files I do this with grep\/sed\/awk tool chain. How to handle it for JSON? Searching for a solution I came across the JSONPath<\/strong>. It quite mature tool (from 2007) but I haven’t hear about it so I decided to share my experience with others. First of all you can try it without pain online: http:\/\/jsonpath.curiousconcept.com\/<\/a>. Full syntax is described at http:\/\/goessner.net\/articles\/JsonPath\/<\/a> <\/a> But also you can download python binding and run it from command line:<\/p>\n

$ sudo apt-get install python-jsonpath-rw\n$ sudo apt-get install python-setuptools\n$ sudo easy_install -U jsonpath<\/span><\/pre>\n
After that you can use inside python or with simple cli wrapper:<\/p>\n
#!\/usr\/bin\/python\n<\/span>import<\/span> sys, json, jsonpath\n\npath = sys.argv[<\/span>1<\/span>]\n\nresult = jsonpath.jsonpath(json.load(sys.stdin), path)\n<\/span>print<\/span> json.dumps(result, indent=<\/span>2<\/span>)<\/span><\/pre>\n
\u2026 you can use it in your shell e.g. for json:<\/p>\n
{\n  <\/span>\"store\"<\/span>: {\n    <\/span>\"book\"<\/span>: [\n      {\n        <\/span>\"category\"<\/span>: <\/span>\"reference\"<\/span>,\n        <\/span>\"author\"<\/span>: <\/span>\"Nigel Rees\"<\/span>,\n        <\/span>\"title\"<\/span>: <\/span>\"Sayings of the Century\"<\/span>,\n        <\/span>\"price\"<\/span>: <\/span>8.95\n<\/span>      },\n      {\n        <\/span>\"category\"<\/span>: <\/span>\"fiction\"<\/span>,\n        <\/span>\"author\"<\/span>: <\/span>\"Evelyn Waugh\"<\/span>,\n        <\/span>\"title\"<\/span>: <\/span>\"Sword of Honour\"<\/span>,\n        <\/span>\"price\"<\/span>: <\/span>12.99\n<\/span>      },\n      {\n        <\/span>\"category\"<\/span>: <\/span>\"fiction\"<\/span>,\n        <\/span>\"author\"<\/span>: <\/span>\"Herman Melville\"<\/span>,\n        <\/span>\"title\"<\/span>: <\/span>\"Moby Dick\"<\/span>,\n        <\/span>\"isbn\"<\/span>: <\/span>\"0-553-21311-3\"<\/span>,\n        <\/span>\"price\"<\/span>: <\/span>8.99\n<\/span>      },\n      {\n        <\/span>\"category\"<\/span>: <\/span>\"fiction\"<\/span>,\n        <\/span>\"author\"<\/span>: <\/span>\"J. R. R. Tolkien\"<\/span>,\n        <\/span>\"title\"<\/span>: <\/span>\"The Lord of the Rings\"<\/span>,\n        <\/span>\"isbn\"<\/span>: <\/span>\"0-395-19395-8\"<\/span>,\n        <\/span>\"price\"<\/span>: <\/span>22.99\n<\/span>      }\n    ],\n    <\/span>\"bicycle\"<\/span>: {\n      <\/span>\"color\"<\/span>: <\/span>\"red\"<\/span>,\n      <\/span>\"price\"<\/span>: <\/span>19.95\n<\/span>    }\n  }\n}<\/span><\/pre>\n
You can print only book nodes with price lower than 10 by:<\/p>\n
$ jsonpath '$..book[?(@.price < 10)]' < books.json<\/span><\/pre>\n
Result:<\/p>\n
[\n  {\n    <\/span>\"category\"<\/span>: <\/span>\"reference\"<\/span>,\n    <\/span>\"price\"<\/span>: <\/span>8.95<\/span>,\n    <\/span>\"title\"<\/span>: <\/span>\"Sayings of the Century\"<\/span>,\n    <\/span>\"author\"<\/span>: <\/span>\"Nigel Rees\"\n<\/span>  },\n  {\n    <\/span>\"category\"<\/span>: <\/span>\"fiction\"<\/span>,\n    <\/span>\"price\"<\/span>: <\/span>8.99<\/span>,\n    <\/span>\"title\"<\/span>: <\/span>\"Moby Dick\"<\/span>,\n    <\/span>\"isbn\"<\/span>: <\/span>\"0-553-21311-3\"<\/span>,\n    <\/span>\"author\"<\/span>: <\/span>\"Herman Melville\"\n<\/span>  }\n]<\/span><\/pre>\n
Have a nice JSON hacking!<\/p>\n","protected":false},"excerpt":{"rendered":"From time to time I have a need to do some fixes in my json data. In a world of flat files I do this with grep\/sed\/awk tool chain. How to handle it for JSON? Searching for a solution I came across the JSONPath. It quite mature tool (from 2007) but I haven’t hear about it so I decided to share my experience with others.\nFirst of all you can try it without pain online: http:\/\/jsonpath.curiousconcept.com\/. Full syntax is described at http:\/\/goessner.net\/articles\/JsonPath\/\n\nBut also you can download python binding and run it from command line:\n$ sudo apt-get install python-jsonpath-rw$ sudo apt-get install python-setuptools$ sudo easy_install -U jsonpath\nAfter that you can use inside python or with simple cli wrapper:\n#!\/usr\/bin\/pythonimport sys, json, jsonpathpath = sys.argv[1]result = jsonpath.jsonpath(json.load(sys.stdin), path)print json.dumps(result, indent=2)\n… you can use it in your shell e.g. for json:\n{\"store\": {\"book\": [      {\"category\": \"reference\",\"author\": \"Nigel Rees\",\"title\": \"Sayings of the Century\",\"price\": 8.95      },      {\"category\": \"fiction\",\"author\": \"Evelyn Waugh\",\"title\": \"Sword of Honour\",\"price\": 12.99      },      {\"category\": \"fiction\",\"author\": \"Herman Melville\",\"title\": \"Moby Dick\",\"isbn\": \"0-553-21311-3\",\"price\": 8.99      },      {\"category\": \"fiction\",\"author\": \"J. R. R. Tolkien\",\"title\": \"The Lord of the Rings\",\"isbn\": \"0-395-19395-8\",\"price\": 22.99      }    ],\"bicycle\": {\"color\": \"red\",\"price\": 19.95    }  }}\nYou can print only book nodes with price lower than 10 by:\n$ jsonpath '$..book[?(@.price \nResult:\n[  {\"category\": \"reference\",\"price\": 8.95,\"title\": \"Sayings of the Century\",\"author\": \"Nigel Rees\"  },  {\"category\": \"fiction\",\"price\": 8.99,\"title\": \"Moby Dick\",\"isbn\": \"0-553-21311-3\",\"author\": \"Herman Melville\"  }]\nHave a nice JSON hacking!From time to time I have a need to do some fixes in my json data. In a world of flat files I do this with grep\/sed\/awk tool chain. How to handle it for JSON? Searching for a solution I came across the JSONPath. It quite mature tool (from 2007) but I haven’t hear about it so I decided to share my experience with others.\n","protected":false},"author":28,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[283,537,107],"class_list":{"0":"post-12067","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-development-design","7":"tag-json","8":"tag-shell","9":"tag-xml"},"_links":{"self":[{"href":"https:\/\/touk.pl\/blog\/wp-json\/wp\/v2\/posts\/12067","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/touk.pl\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/touk.pl\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/touk.pl\/blog\/wp-json\/wp\/v2\/users\/28"}],"replies":[{"embeddable":true,"href":"https:\/\/touk.pl\/blog\/wp-json\/wp\/v2\/comments?post=12067"}],"version-history":[{"count":9,"href":"https:\/\/touk.pl\/blog\/wp-json\/wp\/v2\/posts\/12067\/revisions"}],"predecessor-version":[{"id":14624,"href":"https:\/\/touk.pl\/blog\/wp-json\/wp\/v2\/posts\/12067\/revisions\/14624"}],"wp:attachment":[{"href":"https:\/\/touk.pl\/blog\/wp-json\/wp\/v2\/media?parent=12067"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/touk.pl\/blog\/wp-json\/wp\/v2\/categories?post=12067"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/touk.pl\/blog\/wp-json\/wp\/v2\/tags?post=12067"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}