Related Modules via SOAP

[MateoLeFou]

I have a couple questions about fetching entry lists and their related beans:

1) I have a field, "accound_id_c", in the contacts_cstm table, which is not being retrieved by a SOAP call on the Contacts module. I see that there is an account_id of type "relate" in the get_module_fields call, but I don't know how to use it. I have tried adding account_id, account_id_c, and `contacts_cstm`.`account_id_c` to the select_fields.

2) Is it not possible to say, get_entry_list_and_related_entry_lists( etc... ) ?
By this I mean I'd like to get Contacts and their related Account's name in a single SOAP call. As I see it, I'm going to have to get the Contacts, and loop over (severalhundred of) them with additional soap calls just to retrieve the "name" field from the associated Accounts beans.

Several hundred SOAP calls is not going to work for me.

[andopes]

Hi Mateo

You can use the SOAP method get_entry_list:

     $result = $soapclient->call(
        'get_entry_list',
        array(
            'session' => $session,
            'module_name' => 'Contacts',
            'query' => "<your_query>",
            'order_by' => '',
            'offset' => 0,
            'select_fields' => array(),
            'max_results' => 0
        )
    ); 
  

You do not need to specify the fields you are going to fetch from soap, the soap api will return the full list of fields for each record.

Cheers