Why doesn't BeanFactory("module name", id) return the record from the db?

Question

Hello World,

So I have an api call that is working. That is I can put in the url and some argument and print out that argument. I want to get some data using beans, I know that I am clearly doing something wrong because nothing is return what I expect it to. For example I have this code:

$accountID = '1d53d7c0-5783-9a99-09a6-555e943c52cb';

$accountBean = BeanFactory::getBean("Accounts",$accountID);

//Shouldn't this return the record the db?

return $accountBean;

According to the documentation on the developer site when you add the ID of the bean you want the bean factory should return the record from the db. Correct?

https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_7.5/API/Classes/BeanFactory/#Retrieving…

This is the value from the db:

So shouldn't I expect to see a bean representing that record with that data that have a name property of Internal testing Team?

When I test the code using postman I get this instead:

As you can see I can search for the name value but nothing is there. It appears to just be the definition of the object that I returned and not the record from the database.

Why is this? Can someone please shed light on my problem.

Best Regards

James Palmisano

James Palmisano · Accepted Answer

So this code ended up working: //create db instance $db = DBManagerFactory :: getInstance (); $query = "select min(in_l.install_date) install_date from in_locations in_l "; $query .= " join in_customers_in_locations_c relTable on "; $query .= " relTable.in_customers_in_locationsin_locations_idb = in_l.id "; $query .= " join in_customers on relTable.in_customers_in_locationsin_customers_ida "; $query .= " = in_customers.id where in_customers.id ='customers_117' "; $query .= " and in_l.install_date is not null "; $return_value = 'No exception'; try { $result = $GLOBALS [ 'db' ]-> query ( $query ); $result = $db -> getOne ( $query ); if ( $result != null ) { $return_value = $result; } else { $return_value = 'Result is null'; } } catch ( Exception $e ) { $return_value = "Exception raised: " . $e -> getMessage (); } return $return_value;