soap api connecting two tables

[sugarcare]

Hi

I am trying to access records from multiple tables that are formed with a relationship.

say contact and case. I have contact ID. How to access the cases that have this contact ID. I am able to run a sql query, but acheiving via SOAP API is brain teaser!!!

for instance:

session value is okay,
what is module name?
what is Query will be ?
I need to select some columns in both tables/modules. How do i do this?
what is the offset in this regard?

[vietha]

Has anyone figured this problem out?

[stevec]

Have you tried querying the contacts_cases table via SOAP with the contact_id to obtain the case_ids, then query the cases table with these ids to get the case recrods you want?

Not as neat as a single query but it will achieve what you want.

[Scott_Savage]

In a somewhat related question is it possible to access the relationship tables through the SOAP interface? I have tried the "set_entry" method with module "calls_contacts", however there is no module. However if I just do the calls update it doesn't update the corresponding relationship table?

[Scott_Savage]

Is this actually a bug? I think that the SOAP function should know that if a call is related to a contact then it also needs to make an entry into the calls_contacts table?

[Scott_Savage]

Alright I am filing this as a defect bug, or rather adding a note to an existing defect bug.

See the details for Bug 6494

This bug was filed back in May though, so don't like my chances of it getting fixed soon...