DEV Community: Saddam H

DEV Community: Saddam H The latest articles on DEV Community by Saddam H (@thedevsaddam). https://dev.to/thedevsaddam https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F125426%2Fcefadc65-c759-4a2f-a69a-28e082d50060.jpg DEV Community: Saddam H https://dev.to/thedevsaddam en How to access deeply nested JSON data using Go (lang)? Saddam H Wed, 02 Jan 2019 12:22:10 +0000 https://dev.to/thedevsaddam/how-to-access-deeply-nested-json-data-using-go-lang-5560 https://dev.to/thedevsaddam/how-to-access-deeply-nested-json-data-using-go-lang-5560 <p><a href="https://res.cloudinary.com/practicaldev/image/fetch/s--7Emfp-rk--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://thepracticaldev.s3.amazonaws.com/i/y8gz394f3ye9131vz399.jpeg" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--7Emfp-rk--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://thepracticaldev.s3.amazonaws.com/i/y8gz394f3ye9131vz399.jpeg" alt="gojsonq"></a><br> Most often developer needs to consume JSON data from other service and query over them. Querying JSON document is little time-consuming. For the last few days, I was working on a package for Golang to query JSON data easily. The idea and inspiration come from PHP-JSONQ by Nahid Bin Azhar.</p> <p>Let's take a sample JSON data to start with:</p> <div class="highlight"><pre class="highlight json"><code><span class="p">{</span><span class="w"> </span><span class="s2">"name"</span><span class="p">:</span><span class="s2">"computers"</span><span class="p">,</span><span class="w"> </span><span class="s2">"description"</span><span class="p">:</span><span class="s2">"List of computer products"</span><span class="p">,</span><span class="w"> </span><span class="s2">"vendor"</span><span class="p">:{</span><span class="w"> </span><span class="s2">"name"</span><span class="p">:</span><span class="s2">"Star Trek"</span><span class="p">,</span><span class="w"> </span><span class="s2">"email"</span><span class="p">:</span><span class="s2">"info@example.com"</span><span class="p">,</span><span class="w"> </span><span class="s2">"website"</span><span class="p">:</span><span class="s2">"www.example.com"</span><span class="p">,</span><span class="w"> </span><span class="s2">"items"</span><span class="p">:[</span><span class="w"> </span><span class="p">{</span><span class="s2">"id"</span><span class="p">:</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="s2">"name"</span><span class="p">:</span><span class="s2">"MacBook Pro 13 inch retina"</span><span class="p">,</span><span class="s2">"price"</span><span class="p">:</span><span class="mi">1350</span><span class="p">},</span><span class="w"> </span><span class="p">{</span><span class="s2">"id"</span><span class="p">:</span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="s2">"name"</span><span class="p">:</span><span class="s2">"MacBook Pro 15 inch retina"</span><span class="p">,</span><span class="w"> </span><span class="s2">"price"</span><span class="p">:</span><span class="mi">1700</span><span class="p">},</span><span class="w"> </span><span class="p">{</span><span class="s2">"id"</span><span class="p">:</span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span class="s2">"name"</span><span class="p">:</span><span class="s2">"Sony VAIO"</span><span class="p">,</span><span class="w"> </span><span class="s2">"price"</span><span class="p">:</span><span class="mi">1200</span><span class="p">},</span><span class="w"> </span><span class="p">{</span><span class="s2">"id"</span><span class="p">:</span><span class="mi">4</span><span class="p">,</span><span class="w"> </span><span class="s2">"name"</span><span class="p">:</span><span class="s2">"Fujitsu"</span><span class="p">,</span><span class="w"> </span><span class="s2">"price"</span><span class="p">:</span><span class="mi">850</span><span class="p">},</span><span class="w"> </span><span class="p">{</span><span class="s2">"id"</span><span class="p">:</span><span class="mi">5</span><span class="p">,</span><span class="w"> </span><span class="s2">"name"</span><span class="p">:</span><span class="s2">"HP core i5"</span><span class="p">,</span><span class="w"> </span><span class="s2">"price"</span><span class="p">:</span><span class="mi">850</span><span class="p">,</span><span class="w"> </span><span class="s2">"key"</span><span class="p">:</span><span class="w"> </span><span class="mi">2300</span><span class="p">},</span><span class="w"> </span><span class="p">{</span><span class="s2">"id"</span><span class="p">:</span><span class="mi">6</span><span class="p">,</span><span class="w"> </span><span class="s2">"name"</span><span class="p">:</span><span class="s2">"HP core i7"</span><span class="p">,</span><span class="w"> </span><span class="s2">"price"</span><span class="p">:</span><span class="mi">950</span><span class="p">},</span><span class="w"> </span><span class="p">{</span><span class="s2">"id"</span><span class="p">:</span><span class="kc">null</span><span class="p">,</span><span class="w"> </span><span class="s2">"name"</span><span class="p">:</span><span class="s2">"HP core i3 SSD"</span><span class="p">,</span><span class="w"> </span><span class="s2">"price"</span><span class="p">:</span><span class="mi">850</span><span class="p">}</span><span class="w"> </span><span class="p">],</span><span class="w"> </span><span class="s2">"prices"</span><span class="p">:[</span><span class="w"> </span><span class="mi">2400</span><span class="p">,</span><span class="w"> </span><span class="mi">2100</span><span class="p">,</span><span class="w"> </span><span class="mi">1200</span><span class="p">,</span><span class="w"> </span><span class="mf">400.87</span><span class="p">,</span><span class="w"> </span><span class="mf">89.90</span><span class="p">,</span><span class="w"> </span><span class="mf">150.10</span><span class="w"> </span><span class="p">]</span><span class="w"> </span><span class="p">}</span><span class="w"> </span><span class="p">}</span><span class="w"> </span></code></pre></div> <p>Let's find a deeply nested property and handle error properly, in this case, we'll try to access <code>name</code> from the second element of <code>items</code> array, note: <code>items</code> is a property of <code>vendor</code> object. See the example below:</p> <div class="highlight"><pre class="highlight go"><code><span class="k">package</span><span class="x"> </span><span class="n">main</span><span class="x"> </span><span class="k">import</span><span class="x"> </span><span class="p">(</span><span class="x"> </span><span class="s">"fmt"</span><span class="x"> </span><span class="s">"log"</span><span class="x"> </span><span class="s">"github.com/thedevsaddam/gojsonq"</span><span class="x"> </span><span class="p">)</span><span class="x"> </span><span class="k">func</span><span class="x"> </span><span class="n">main</span><span class="p">()</span><span class="x"> </span><span class="p">{</span><span class="x"> </span><span class="n">jq</span><span class="x"> </span><span class="o">:=</span><span class="x"> </span><span class="n">gojsonq</span><span class="o">.</span><span class="n">New</span><span class="p">()</span><span class="o">.</span><span class="n">File</span><span class="p">(</span><span class="s">"./sample-data.json"</span><span class="p">)</span><span class="x"> </span><span class="n">res</span><span class="x"> </span><span class="o">:=</span><span class="x"> </span><span class="n">jq</span><span class="o">.</span><span class="n">Find</span><span class="p">(</span><span class="s">"vendor.items.[1].name"</span><span class="p">)</span><span class="x"> </span><span class="k">if</span><span class="x"> </span><span class="n">jq</span><span class="o">.</span><span class="n">Error</span><span class="p">()</span><span class="x"> </span><span class="o">!=</span><span class="x"> </span><span class="no">nil</span><span class="x"> </span><span class="p">{</span><span class="x"> </span><span class="n">log</span><span class="o">.</span><span class="n">Fatal</span><span class="p">(</span><span class="n">jq</span><span class="o">.</span><span class="n">Errors</span><span class="p">())</span><span class="x"> </span><span class="p">}</span><span class="x"> </span><span class="n">fmt</span><span class="o">.</span><span class="n">Println</span><span class="p">(</span><span class="n">res</span><span class="p">)</span><span class="x"> </span><span class="p">}</span><span class="x"> </span></code></pre></div> <p>Yahooooo! Very simple right? It looks like working with <code>ORM</code> of JSON data. Let's see some more example to query over the sample data.</p> <h3> Example 1 </h3> <p>Query: <code>select * from vendor.items where price > 1200 or id null</code></p> <p>Using <a href="https://github.com/thedevsaddam/gojsonq">gojsonq</a> we can do the query like:</p> <div class="highlight"><pre class="highlight go"><code><span class="k">package</span><span class="x"> </span><span class="n">main</span><span class="x"> </span><span class="k">import</span><span class="x"> </span><span class="p">(</span><span class="x"> </span><span class="s">"fmt"</span><span class="x"> </span><span class="s">"github.com/thedevsaddam/gojsonq"</span><span class="x"> </span><span class="p">)</span><span class="x"> </span><span class="k">func</span><span class="x"> </span><span class="n">main</span><span class="p">()</span><span class="x"> </span><span class="p">{</span><span class="x"> </span><span class="n">jq</span><span class="x"> </span><span class="o">:=</span><span class="x"> </span><span class="n">gojsonq</span><span class="o">.</span><span class="n">New</span><span class="p">()</span><span class="o">.</span><span class="n">File</span><span class="p">(</span><span class="s">"./sample-data.json"</span><span class="p">)</span><span class="x"> </span><span class="n">res</span><span class="x"> </span><span class="o">:=</span><span class="x"> </span><span class="n">jq</span><span class="o">.</span><span class="n">From</span><span class="p">(</span><span class="s">"vendor.items"</span><span class="p">)</span><span class="o">.</span><span class="n">Where</span><span class="p">(</span><span class="s">"price"</span><span class="p">,</span><span class="x"> </span><span class="s">">"</span><span class="p">,</span><span class="x"> </span><span class="m">1200</span><span class="p">)</span><span class="o">.</span><span class="n">OrWhere</span><span class="p">(</span><span class="s">"id"</span><span class="p">,</span><span class="x"> </span><span class="s">"="</span><span class="p">,</span><span class="x"> </span><span class="no">nil</span><span class="p">)</span><span class="o">.</span><span class="n">Get</span><span class="p">()</span><span class="x"> </span><span class="n">fmt</span><span class="o">.</span><span class="n">Println</span><span class="p">(</span><span class="n">res</span><span class="p">)</span><span class="x"> </span><span class="c">// output: [map[price:1350 id:1 name:MacBook Pro 13 inch retina] map[id:2 name:MacBook Pro 15 inch retina price:1700] map[id:<nil> name:HP core i3 SSD price:850]]</span><span class="x"> </span><span class="p">}</span><span class="x"> </span></code></pre></div> <h3> Example 2 </h3> <p>Query: <code>select name, price from vendor.items where price > 1200 or id null</code></p> <p>Using <a href="https://github.com/thedevsaddam/gojsonq">gojsonq</a> we can do the query like:</p> <div class="highlight"><pre class="highlight go"><code><span class="k">package</span><span class="x"> </span><span class="n">main</span><span class="x"> </span><span class="k">import</span><span class="x"> </span><span class="p">(</span><span class="x"> </span><span class="s">"fmt"</span><span class="x"> </span><span class="s">"github.com/thedevsaddam/gojsonq"</span><span class="x"> </span><span class="p">)</span><span class="x"> </span><span class="k">func</span><span class="x"> </span><span class="n">main</span><span class="p">()</span><span class="x"> </span><span class="p">{</span><span class="x"> </span><span class="n">jq</span><span class="x"> </span><span class="o">:=</span><span class="x"> </span><span class="n">gojsonq</span><span class="o">.</span><span class="n">New</span><span class="p">()</span><span class="o">.</span><span class="n">File</span><span class="p">(</span><span class="s">"./sample-data.json"</span><span class="p">)</span><span class="x"> </span><span class="n">res</span><span class="x"> </span><span class="o">:=</span><span class="x"> </span><span class="n">jq</span><span class="o">.</span><span class="n">From</span><span class="p">(</span><span class="s">"vendor.items"</span><span class="p">)</span><span class="o">.</span><span class="n">Where</span><span class="p">(</span><span class="s">"price"</span><span class="p">,</span><span class="x"> </span><span class="s">">"</span><span class="p">,</span><span class="x"> </span><span class="m">1200</span><span class="p">)</span><span class="o">.</span><span class="n">OrWhere</span><span class="p">(</span><span class="s">"id"</span><span class="p">,</span><span class="x"> </span><span class="s">"="</span><span class="p">,</span><span class="x"> </span><span class="no">nil</span><span class="p">)</span><span class="o">.</span><span class="n">Only</span><span class="p">(</span><span class="s">"name"</span><span class="p">,</span><span class="x"> </span><span class="s">"price"</span><span class="p">)</span><span class="x"> </span><span class="n">fmt</span><span class="o">.</span><span class="n">Println</span><span class="p">(</span><span class="n">res</span><span class="p">)</span><span class="x"> </span><span class="c">// output: [map[name:MacBook Pro 13 inch retina price:1350] map[name:MacBook Pro 15 inch retina price:1700] map[name:HP core i3 SSD price:850]]</span><span class="x"> </span><span class="p">}</span><span class="x"> </span></code></pre></div> <h3> Example 3 </h3> <p>Query: <code>select sum(price) from vendor.items where price > 1200 or id null</code></p> <p>Using <a href="https://github.com/thedevsaddam/gojsonq">gojsonq</a> we can do the query like:</p> <div class="highlight"><pre class="highlight go"><code><span class="k">package</span><span class="x"> </span><span class="n">main</span><span class="x"> </span><span class="k">import</span><span class="x"> </span><span class="p">(</span><span class="x"> </span><span class="s">"fmt"</span><span class="x"> </span><span class="s">"github.com/thedevsaddam/gojsonq"</span><span class="x"> </span><span class="p">)</span><span class="x"> </span><span class="k">func</span><span class="x"> </span><span class="n">main</span><span class="p">()</span><span class="x"> </span><span class="p">{</span><span class="x"> </span><span class="n">jq</span><span class="x"> </span><span class="o">:=</span><span class="x"> </span><span class="n">gojsonq</span><span class="o">.</span><span class="n">New</span><span class="p">()</span><span class="o">.</span><span class="n">File</span><span class="p">(</span><span class="s">"./sample-data.json"</span><span class="p">)</span><span class="x"> </span><span class="n">res</span><span class="x"> </span><span class="o">:=</span><span class="x"> </span><span class="n">jq</span><span class="o">.</span><span class="n">From</span><span class="p">(</span><span class="s">"vendor.items"</span><span class="p">)</span><span class="o">.</span><span class="n">Where</span><span class="p">(</span><span class="s">"price"</span><span class="p">,</span><span class="x"> </span><span class="s">">"</span><span class="p">,</span><span class="x"> </span><span class="m">1200</span><span class="p">)</span><span class="o">.</span><span class="n">OrWhere</span><span class="p">(</span><span class="s">"id"</span><span class="p">,</span><span class="x"> </span><span class="s">"="</span><span class="p">,</span><span class="x"> </span><span class="no">nil</span><span class="p">)</span><span class="o">.</span><span class="n">Sum</span><span class="p">(</span><span class="s">"price"</span><span class="p">)</span><span class="x"> </span><span class="n">fmt</span><span class="o">.</span><span class="n">Println</span><span class="p">(</span><span class="n">res</span><span class="p">)</span><span class="x"> </span><span class="c">// output: 3900</span><span class="x"> </span><span class="p">}</span><span class="x"> </span></code></pre></div> <h3> Example 4 </h3> <p>Query: <code>select price from vendor.items where price > 1200</code></p> <p>Using <a href="https://github.com/thedevsaddam/gojsonq">gojsonq</a> we can do the query like:</p> <div class="highlight"><pre class="highlight go"><code><span class="k">package</span><span class="x"> </span><span class="n">main</span><span class="x"> </span><span class="k">import</span><span class="x"> </span><span class="p">(</span><span class="x"> </span><span class="s">"fmt"</span><span class="x"> </span><span class="s">"github.com/thedevsaddam/gojsonq"</span><span class="x"> </span><span class="p">)</span><span class="x"> </span><span class="k">func</span><span class="x"> </span><span class="n">main</span><span class="p">()</span><span class="x"> </span><span class="p">{</span><span class="x"> </span><span class="n">jq</span><span class="x"> </span><span class="o">:=</span><span class="x"> </span><span class="n">gojsonq</span><span class="o">.</span><span class="n">New</span><span class="p">()</span><span class="o">.</span><span class="n">File</span><span class="p">(</span><span class="s">"./sample-data.json"</span><span class="p">)</span><span class="x"> </span><span class="n">res</span><span class="x"> </span><span class="o">:=</span><span class="x"> </span><span class="n">jq</span><span class="o">.</span><span class="n">From</span><span class="p">(</span><span class="s">"vendor.items"</span><span class="p">)</span><span class="o">.</span><span class="n">Where</span><span class="p">(</span><span class="s">"price"</span><span class="p">,</span><span class="x"> </span><span class="s">">"</span><span class="p">,</span><span class="x"> </span><span class="m">1200</span><span class="p">)</span><span class="o">.</span><span class="n">Pluck</span><span class="p">(</span><span class="s">"price"</span><span class="p">)</span><span class="x"> </span><span class="n">fmt</span><span class="o">.</span><span class="n">Println</span><span class="p">(</span><span class="n">res</span><span class="p">)</span><span class="x"> </span><span class="c">// output: [1350 1700]</span><span class="x"> </span><span class="p">}</span><span class="x"> </span></code></pre></div> <h3> Example 5 </h3> <p>Query: <code>select * from vendor.items order by price</code></p> <p>Using <a href="https://github.com/thedevsaddam/gojsonq">gojsonq</a> we can do the query like:</p> <div class="highlight"><pre class="highlight go"><code><span class="k">package</span><span class="x"> </span><span class="n">main</span><span class="x"> </span><span class="k">import</span><span class="x"> </span><span class="p">(</span><span class="x"> </span><span class="s">"fmt"</span><span class="x"> </span><span class="s">"github.com/thedevsaddam/gojsonq"</span><span class="x"> </span><span class="p">)</span><span class="x"> </span><span class="k">func</span><span class="x"> </span><span class="n">main</span><span class="p">()</span><span class="x"> </span><span class="p">{</span><span class="x"> </span><span class="n">jq</span><span class="x"> </span><span class="o">:=</span><span class="x"> </span><span class="n">gojsonq</span><span class="o">.</span><span class="n">New</span><span class="p">()</span><span class="o">.</span><span class="n">File</span><span class="p">(</span><span class="s">"./sample-data.json"</span><span class="p">)</span><span class="x"> </span><span class="n">res</span><span class="x"> </span><span class="o">:=</span><span class="x"> </span><span class="n">jq</span><span class="o">.</span><span class="n">From</span><span class="p">(</span><span class="s">"vendor.items"</span><span class="p">)</span><span class="o">.</span><span class="n">SortBy</span><span class="p">(</span><span class="s">"price"</span><span class="p">)</span><span class="o">.</span><span class="n">Get</span><span class="p">()</span><span class="x"> </span><span class="n">fmt</span><span class="o">.</span><span class="n">Println</span><span class="p">(</span><span class="n">res</span><span class="p">)</span><span class="x"> </span><span class="c">// output: [map[id:<nil> name:HP core i3 SSD price:850] map[id:4 name:Fujitsu price:850] map[id:5 name:HP core i5 price:850 key:2300] map[id:6 name:HP core i7 price:950] map[id:3 name:Sony VAIO price:1200] map[id:1 name:MacBook Pro 13 inch retina price:1350] map[id:2 name:MacBook Pro 15 inch retina price:1700]]</span><span class="x"> </span><span class="p">}</span><span class="x"> </span></code></pre></div> <h3> Example 6 </h3> <p>Using <a href="https://github.com/thedevsaddam/gojsonq">gojsonq</a> You can handle errors properly, see the code snippet below:</p> <div class="highlight"><pre class="highlight go"><code><span class="x"> </span><span class="k">package</span><span class="x"> </span><span class="n">main</span><span class="x"> </span><span class="k">import</span><span class="x"> </span><span class="p">(</span><span class="x"> </span><span class="s">"log"</span><span class="x"> </span><span class="s">"github.com/thedevsaddam/gojsonq"</span><span class="x"> </span><span class="p">)</span><span class="x"> </span><span class="k">func</span><span class="x"> </span><span class="n">main</span><span class="p">()</span><span class="x"> </span><span class="p">{</span><span class="x"> </span><span class="n">jq</span><span class="x"> </span><span class="o">:=</span><span class="x"> </span><span class="n">gojsonq</span><span class="o">.</span><span class="n">New</span><span class="p">()</span><span class="o">.</span><span class="n">File</span><span class="p">(</span><span class="s">"./invalid-file.xjsn"</span><span class="p">)</span><span class="x"> </span><span class="n">err</span><span class="x"> </span><span class="o">:=</span><span class="x"> </span><span class="n">jq</span><span class="o">.</span><span class="n">Error</span><span class="p">()</span><span class="x"> </span><span class="k">if</span><span class="x"> </span><span class="n">err</span><span class="x"> </span><span class="o">!=</span><span class="x"> </span><span class="no">nil</span><span class="x"> </span><span class="p">{</span><span class="x"> </span><span class="n">log</span><span class="o">.</span><span class="n">Fatal</span><span class="p">(</span><span class="n">err</span><span class="p">)</span><span class="x"> </span><span class="c">// 2018/06/25 00:48:58 gojsonq: open ./invalid-file.xjsn: no such file or directory</span><span class="x"> </span><span class="c">// exit status 1</span><span class="x"> </span><span class="p">}</span><span class="x"> </span><span class="p">}</span><span class="x"> </span></code></pre></div> <h3> Example 7 </h3> <p>Let's assume we have a JSON document like this one </p> <div class="highlight"><pre class="highlight json"><code><span class="p">{</span><span class="w"> </span><span class="s2">"users"</span><span class="p">:[</span><span class="w"> </span><span class="p">{</span><span class="w"> </span><span class="s2">"id"</span><span class="p">:</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="s2">"name"</span><span class="p">:{</span><span class="w"> </span><span class="s2">"first"</span><span class="p">:</span><span class="s2">"John"</span><span class="p">,</span><span class="w"> </span><span class="s2">"last"</span><span class="p">:</span><span class="s2">"Ramboo"</span><span class="w"> </span><span class="p">}</span><span class="w"> </span><span class="p">},</span><span class="w"> </span><span class="p">{</span><span class="w"> </span><span class="s2">"id"</span><span class="p">:</span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="s2">"name"</span><span class="p">:{</span><span class="w"> </span><span class="s2">"first"</span><span class="p">:</span><span class="s2">"Ethan"</span><span class="p">,</span><span class="w"> </span><span class="s2">"last"</span><span class="p">:</span><span class="s2">"Hunt"</span><span class="w"> </span><span class="p">}</span><span class="w"> </span><span class="p">},</span><span class="w"> </span><span class="p">{</span><span class="w"> </span><span class="s2">"id"</span><span class="p">:</span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span class="s2">"name"</span><span class="p">:{</span><span class="w"> </span><span class="s2">"first"</span><span class="p">:</span><span class="s2">"John"</span><span class="p">,</span><span class="w"> </span><span class="s2">"last"</span><span class="p">:</span><span class="s2">"Doe"</span><span class="w"> </span><span class="p">}</span><span class="w"> </span><span class="p">}</span><span class="w"> </span><span class="p">]</span><span class="w"> </span><span class="p">}</span><span class="w"> </span></code></pre></div> <p>We want to run a query like this:</p> <p>Query: <code>select * from users where name.first=John</code></p> <p>Using the package you can do the query easily, see the code snippet below:</p> <div class="highlight"><pre class="highlight go"><code><span class="k">package</span><span class="x"> </span><span class="n">main</span><span class="x"> </span><span class="k">import</span><span class="x"> </span><span class="p">(</span><span class="x"> </span><span class="s">"fmt"</span><span class="x"> </span><span class="s">"github.com/thedevsaddam/gojsonq"</span><span class="x"> </span><span class="p">)</span><span class="x"> </span><span class="k">func</span><span class="x"> </span><span class="n">main</span><span class="p">()</span><span class="x"> </span><span class="p">{</span><span class="x"> </span><span class="n">jq</span><span class="x"> </span><span class="o">:=</span><span class="x"> </span><span class="n">gojsonq</span><span class="o">.</span><span class="n">New</span><span class="p">()</span><span class="o">.</span><span class="n">File</span><span class="p">(</span><span class="s">"./data.json"</span><span class="p">)</span><span class="x"> </span><span class="n">res</span><span class="x"> </span><span class="o">:=</span><span class="x"> </span><span class="n">jq</span><span class="o">.</span><span class="n">From</span><span class="p">(</span><span class="s">"users"</span><span class="p">)</span><span class="o">.</span><span class="n">WhereEqual</span><span class="p">(</span><span class="s">"name.first"</span><span class="p">,</span><span class="x"> </span><span class="s">"John"</span><span class="p">)</span><span class="o">.</span><span class="n">Get</span><span class="p">()</span><span class="x"> </span><span class="n">fmt</span><span class="o">.</span><span class="n">Println</span><span class="p">(</span><span class="n">res</span><span class="p">)</span><span class="x"> </span><span class="c">//output: [map[id:1 name:map[first:John last:Ramboo]] map[id:3 name:map[first:John last:Doe]]]</span><span class="x"> </span><span class="p">}</span><span class="x"> </span></code></pre></div> <p>You can access <strong>nested</strong> level property using DOT (.) for methods like <code>Where/GroupBy/SortBy etc</code></p> <h4> Note: There are some other useful methods to make life easier! If you like the package do not forget to share with your community and star the repository </h4> <h2> Repo link: <a href="https://github.com/thedevsaddam/gojsonq">gojsonq</a> </h2> <p>Thank you very much for reading this article and don't forget to give your feedback on comment :)</p> jsonq gojsonq golangjsonquery