SugarCRM: how to get all contacts for an account via REST API

sugarcrm
babbata picture babbata · Sep 27, 2012 · Viewed 8.8k times · Source

I am trying to get all contacts for a particular account (i know the account id) from SugarCRM using the v2 REST API.

I am sending a GET request with the following parameters:

input_type => 'JSON'

response_type => 'JSON'

method => 'get_entry_list'

rest_data => '{session:"some-valid-session-id", module_name:"Contacts", query:"contacts.account_id=some-valid-id"}'

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'"

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.

Can anyone help?

Answer

air4x picture air4x · Sep 27, 2012

Try query:"accounts.id=some-valid-id".

It has worked for me in the past with the SOAP API.

Related questions

php file automatically renamed to php.suspected

Since last 4 days, we are facing strange issue on our Production server (AWS EC2 instance) specific to only one site which is SugarCRM. Issue is /home/site_folder/public_html/include/MassUpdate.php file is renamed automatically to /home/site_…

Read More
Creating a simple custom view in SugarCRM

I am trying to use the MVC architecture of sugarcrm to add a new action and with that a new view. I have managed to create a controller with the action and also a class view, the only thing I …

Read More
SugarCRM- How to get POPUP when click on Save button?

I want when click Save in Edit View of some module (example Contact) to get pop up with some message (later I will get options OK and Cancel on that pop up.). My function YAHOO.SUGAR.MessageBox.show({msg: 'Foo'} ); …

Read More