title: SugarCRM: how to get all contacts for an account via REST API
body: <p>I am trying to get all contacts for a particular account (i know the account id) from SugarCRM using the v2 REST API.</p>
  
  <p>I am sending a GET request with the following parameters:</p>
  
  <pre><code>input_type =&gt; 'JSON'
  
  response_type =&gt; 'JSON'
  
  method =&gt; 'get_entry_list'
  
  rest_data =&gt; '{session:"some-valid-session-id", module_name:"Contacts", query:"contacts.account_id=some-valid-id"}'
  </code></pre>
  
  <p>I expect to get all contacts that are related to this accoutn, but instead I get an error "... MySQL error 1054: Unknown column 'contacts.account_id' in 'where clause'"</p>
  
  <p>However, when I try to get all contacts without providing any query (query='') I get all the contacts with all their properties and I can see that there is an account_id property.</p>
  
  <p>Can anyone help?</p>