AnsweredAssumed Answered

How can I access the opportunities_contacts table via soap?

Question asked by Danny Tsai on Jun 12, 2014
Latest reply on Nov 16, 2016 by sunil mg
I need to get all the opportunities and the related contacts, and the opportunities_contacts table has all the details. However, I received an Access Denied error in the get_entry_list() call:

String query = "opportunities.id in (Select ocr.opportunity_id, ocr.contact_id From opportunities_contacts ocr)";
Get_entry_list_result result = binding.get_entry_list(sessionId, "Opportunities", query, "", 0, new String[] {"id"}, 1000, 0);

I read some posts saying the ability to do subqueries in the various calls has been removed.
If so, how can this be done?
Appreciate any help.


Outcomes