Can someone offer advice our point me to some documentation
Im trying to retrieve a contact and there related account details, I dont want to retreive everything as I only need selected fields and also want to reduce overheads. I can get this doing an sql request but wanted to understand more how to do things with beanFactory
I have the following
$contactBean = BeanFactory::retrieveBean('Contacts', $args['ID']);
if ($contactBean) {
if ($contactBean->load_relationship('accounts')) {
$accountBean = $contactBean->accounts->getBeans();
}
$helper = new SugarBeanApiHelper($api);
$result['success'] = true;
$result['records'] = $helper->formatForApi($contactBean, array('id', 'name', 'portaluser_c'));
return $result;
}
$result['errors'] = "Contact details not found.";
return $result;
The relationship is working but Im stuck on how i then include the accounts details i want with $helper->formatForApi
Do i need to crate a new bean for the account? or am i going about this the wrong way?