title: How to get the particular row by column in smartsheet api
body: <p>I am using smartsheet as a database and I want to query the smartsheet by column name equals value like in sql db for example: To get the particular row of Employee sheet where salary equal to 10000. But documentation describes only how to get list of rows and how to update and delete rows by row id.</p>
  
  <p><a href="https://smartsheet-platform.github.io/api-docs/?java" rel="nofollow noreferrer">https://smartsheet-platform.github.io/api-docs/?java</a></p>
  
  <p>What i want is to achieve without knowing id of the row. But I can do by search function by searching the salary of the employee </p>
  
  <p><a href="https://api.smartsheet.com/2.0/search?query=10000" rel="nofollow noreferrer">https://api.smartsheet.com/2.0/search?query=10000</a></p>
  
  <p>and the response of above call will have row id and again i should make a call with rowid to get that row by below call which I don't want.</p>
  
  <p>GET /sheets/{sheetId}/rows/{rowId}</p>
  
  <p>Can anyone help me out?</p>