{"id":1365,"date":"2019-06-30T11:56:32","date_gmt":"2019-06-30T16:56:32","guid":{"rendered":"http:\/\/blog.ls-al.com\/?p=1365"},"modified":"2019-06-30T11:57:24","modified_gmt":"2019-06-30T16:57:24","slug":"restic-json-output-and-jq","status":"publish","type":"post","link":"https:\/\/blog.ls-al.com\/restic-json-output-and-jq\/","title":{"rendered":"Restic json output and jq"},"content":{"rendered":"\n<p>Restic has the ability to show output in json.  Here is how I used it for some CSV type reporting I needed on backup jobs.<\/p>\n\n\n\n<p>Example json output.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; title: ; notranslate\" title=\"\">\n# restic -r rclone:s3_phx:\/restic-backup backup \/root --json | jq -r &#039;select(.message_type==&quot;summary&quot;)&#039;\n{\n  &quot;message_type&quot;: &quot;summary&quot;,\n  &quot;files_new&quot;: 0,\n  &quot;files_changed&quot;: 0,\n  &quot;files_unmodified&quot;: 761,\n  &quot;dirs_new&quot;: 0,\n  &quot;dirs_changed&quot;: 0,\n  &quot;dirs_unmodified&quot;: 0,\n  &quot;data_blobs&quot;: 0,\n  &quot;tree_blobs&quot;: 0,\n  &quot;data_added&quot;: 0,\n  &quot;total_files_processed&quot;: 761,\n  &quot;total_bytes_processed&quot;: 251861194,\n  &quot;total_duration&quot;: 1.118076434,\n  &quot;snapshot_id&quot;: &quot;09d1a6b9&quot;\n}\n<\/pre><\/div>\n\n\n<p>With @csv filter.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; title: ; notranslate\" title=\"\">\n# restic -r rclone:s3_phx:\/restic-backup backup \/root --json | jq -r &#039;select(.message_type==&quot;summary&quot;) | &#x5B;.files_new,.files_changed,.files_unmodified,.dirs_new,.dirs_changed,.dirs_unmodified,.data_blobs,.tree_blobs,.data_added,.total_files_processed,.total_bytes_processed,.total_duration,.snapshot_id] | @csv&#039;\n0,0,764,0,0,0,0,0,0,764,251918381,1.037043765,&quot;3a55b3b3&quot;\n<\/pre><\/div>\n\n\n<p>I needed double quotes and could not figure out how to tell @csv filter to quote so below workaround for now.  This was then usable in my bash script.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; title: ; notranslate\" title=\"\">\n# restic -r rclone:s3_phx:\/restic-backup backup \/root --json | jq -r &#039;select(.message_type==&quot;summary&quot;) | &quot;\\&quot;\\(.files_new)\\&quot;,\\&quot;\\(.files_changed)\\&quot;,\\&quot;\\(.files_unmodified)\\&quot;,\\&quot;\\(.dirs_new)\\&quot;,\\&quot;\\(.dirs_changed)\\&quot;,\\&quot;\\(.dirs_unmodified)\\&quot;,\\&quot;\\(.data_blobs)\\&quot;,\\&quot;\\(.tree_blobs)\\&quot;,\\&quot;\\(.data_added)\\&quot;,\\&quot;\\(.total_files_processed)\\&quot;,\\&quot;\\(.total_bytes_processed)\\&quot;,\\&quot;\\(.total_duration)\\&quot;,\\&quot;\\(.snapshot_id)\\&quot;&quot;&#039;\n&quot;0&quot;,&quot;3&quot;,&quot;761&quot;,&quot;0&quot;,&quot;0&quot;,&quot;0&quot;,&quot;3&quot;,&quot;1&quot;,&quot;2901845&quot;,&quot;764&quot;,&quot;251920790&quot;,&quot;2.035211002&quot;,&quot;fb9d780b&quot;\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"<p>Restic has the ability to show output in json. Here is how I used it for some CSV type reporting<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[106,99],"tags":[],"class_list":["post-1365","post","type-post","status-publish","format-standard","hentry","category-json","category-restic"],"_links":{"self":[{"href":"https:\/\/blog.ls-al.com\/wp-json\/wp\/v2\/posts\/1365","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ls-al.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ls-al.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ls-al.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ls-al.com\/wp-json\/wp\/v2\/comments?post=1365"}],"version-history":[{"count":0,"href":"https:\/\/blog.ls-al.com\/wp-json\/wp\/v2\/posts\/1365\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.ls-al.com\/wp-json\/wp\/v2\/media?parent=1365"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ls-al.com\/wp-json\/wp\/v2\/categories?post=1365"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ls-al.com\/wp-json\/wp\/v2\/tags?post=1365"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}