title: Google Sheets REST API 4 get row with specific column
body: <p>I want to get only one row that contain specific value in one column.</p>
  <p>How to make query and set something like: IF &quot;column1&quot; = '3' return that row?</p>
  <p>If i use sheets.spreadsheets.values.batchGetByDataFilter
  i don't know what to write in DataFilter (now i write only &quot;A:D&quot; to return all rows and columns)</p>
  <pre><code>POST https://sheets.googleapis.com/v4/spreadsheets/&lt;Sheet_ID&gt;/values:batchGetByDataFilter?key={YOUR_API_KEY}
   
  {
   &quot;dataFilters&quot;: [
    {
     &quot;a1Range&quot;: &quot;A:D&quot;
    }
   ]
  }
  </code></pre>