soap relationships

[eitrix]

Just to share with everyone, here is a solution that worked.

 $rl = array(
 
// session id from login
    'session' => $session_id,
    'set_relationship_value' => array(
 
// put here the module that shows subpanel in 1:n relationships, in this case Calls is subpanel in opportunity
    'module1' => 'Opportunities',
    'module1_id' => $resultOpId['id'],
 
// put here the other module you are relating to
    'module2' => 'Calls',
    'module2_id' => $resultCaId['id'],
    
    )
);
// call to set relationship
$resultRel = $client->call('set_relationship',$rl);
echo '<br />';
// print test results
print_r($resultRel); 
  

My working edition is sugar 6 ent and i have included in file nusoap.php from sugarcrm include/nusoap/nusoap.php

[anat]

Note that your unable to delete a relationship unless you change to the v2 of the SugarSOAP api.

Check out http://crm.yourdomain.com/service/v2/soap.php

You'll find that there's less functions but most of the ones that are there suddenly need a link_name_to_fields_array or name_value_list entries which will mean you'll have to change your code.
So far I've been setting the 'link_name_to_fields_array' to null as I can't find an explanation of what they do. I can't find one ANYWHERE. Not via Google, not via these forums, not by reading the docs, not even by reading the source code. I just don't understand what they are for


The closest I could find was the basic source code documentation at https://code.sugarcrm.com/viewvc/pub...?view=annotate

55 * @param Array $link_name_to_fields_array -- A list of link_names and for each link_name, what fields value to be returned. For ex.'link_name_to_fields_array' => array(array('name' => 'email_addresses', 'value' => array('id', 'email_address', 'opt_out', 'primary_address')))
56 * @return Array
57 * 'entry_list' -- Array - The records name value pair for the simple data types excluding link field data.
58 * 'relationship_list' -- Array - The records link field data. The example is if asked about accounts email address then return data would look like Array ( [0] => Array ( [name] => email_addresses [records] => Array ( [0] => Array ( [0] => Array ( [name] => id [value] => 3fb16797-8d90-0a94-ac12-490b63a6be67 ) [1] => Array ( [name] => email_address [value] => hr.kid.qa@example.com ) [2] => Array ( [name] => opt_out [value] => 0 ) [3] => Array ( [name] => primary_address [value] => 1 ) ) [1] => Array ( [0] => Array ( [name] => id [value] => 403f8da1-214b-6a88-9cef-490b63d43566 ) [1] => Array ( [name] => email_address [value] => kid.hr@example.name ) [2] => Array ( [name] => opt_out [value] => 0 ) [3] => Array ( [name] => primary_address [value] => 0 ) ) ) ) )

[craigotis]

Note that your unable to delete a relationship unless you change to the v2 of the SugarSOAP api.

Check out http://crm.yourdomain.com/service/v2/soap.php

You'll find that there's less functions but most of the ones that are there suddenly need a link_name_to_fields_array or name_value_list entries which will mean you'll have to change your code.
So far I've been setting the 'link_name_to_fields_array' to null as I can't find an explanation of what they do. I can't find one ANYWHERE. Not via Google, not via these forums, not by reading the docs, not even by reading the source code. I just don't understand what they are for


The closest I could find was the basic source code documentation at https://code.sugarcrm.com/viewvc/pub...?view=annotate

55 * @param Array $link_name_to_fields_array -- A list of link_names and for each link_name, what fields value to be returned. For ex.'link_name_to_fields_array' => array(array('name' => 'email_addresses', 'value' => array('id', 'email_address', 'opt_out', 'primary_address')))
56 * @return Array
57 * 'entry_list' -- Array - The records name value pair for the simple data types excluding link field data.
58 * 'relationship_list' -- Array - The records link field data. The example is if asked about accounts email address then return data would look like Array ( [0] => Array ( [name] => email_addresses [records] => Array ( [0] => Array ( [0] => Array ( [name] => id [value] => 3fb16797-8d90-0a94-ac12-490b63a6be67 ) [1] => Array ( [name] => email_address [value] => hr.kid.qa@example.com ) [2] => Array ( [name] => opt_out [value] => 0 ) [3] => Array ( [name] => primary_address [value] => 1 ) ) [1] => Array ( [0] => Array ( [name] => id [value] => 403f8da1-214b-6a88-9cef-490b63d43566 ) [1] => Array ( [name] => email_address [value] => kid.hr@example.name ) [2] => Array ( [name] => opt_out [value] => 0 ) [3] => Array ( [name] => primary_address [value] => 0 ) ) ) ) )

Have you made any progress as to the link_name_to_fields_array parameter? We recently upgraded to v2 of the SOAP API, and we're updating our client-side calls to match the new call arguments. We have no idea what the link_name parameter means, or what to set it as. Setting it to null is causing errors, and none of our queries are functioning.

[katjapflaeging]

Just check out the example in the comment for get_entry() in class SugarWebServiceImpl, service/core/SugarWebServiceImpl.php

[anat]

I've written a PHP script to output a list of available modules and their available link field names, but will have to check some of the other code that it relies on and try to make it a little more portable and public friendly before releasing it. The core code uses the get_available_modules and then get_module_fields for each module.

I was also working on a unit function test to see what you can and can't do.
At the moment I've got no issues with creating a new lead, updating a contact, or searching via email, but I'm having a hell of an issue setting relationships. Even worse is when trying to remove a relationship (as is required to subscribe a previously unsubscribed contact from a newsletter/email campaign).

These can help :
http://developers.sugarcrm.com/wordp...-web-services/

http://developers.sugarcrm.com/wordp...-web-services/

[anat]

Hi,
OK. I've uploaded the module, fields and link_fields lister script.
You can get it from http://w00t.anat.org.au/2010/11/24/s...fields-lister/
Let me know if you have any issues, or if you find this useful (I have a couple of other scripts I'm working on such as using the Wordpress CFormsII plugin with SugarCRM, and also trying to make it easy to add new leads/contacts, etc..
If you are interested then let me know and I'll try and add the others online once I've made them ready for the public.

Cheers!