Code for retrieving Lead

[Benjamin C. B.]

Hello,

i need to retrieve a lead from its id, using the PHP Lead class. Here's what I've done so far :

content of test.php :

 <?php
 
if(!defined('sugarEntry'))define('sugarEntry', true);
 
require_once('include/entryPoint.php');
require_once 'modules/Leads/Lead.php';
 
$lead = new Lead();
$lead->retrieve($_GET["leadid"]);
echo 'retrieving '.$_GET["leadid"].'<br>';
foreach ($lead as $a => $b)
        echo($a." : ".$b."<br>");
?>  

and using this URL :

https://mysugarcrm/test.php?leadid=260549b3-4cdc-4097-4199-4e5e2a510e42

with 2605[...]10e42 being the record id I want to retrieve, which I can find in a SugarCRM URL like this :

https://mysugarcrm/index.php?module=Leads&[...]&record=260549b3-4cdc-4097-4199-4e5e2a510e42

This code doesn't work, I get this :

retrieveing 260549b3-4cdc-4097-4199-4e5e2a510e42
field_name_map : Array
id :
date_entered :
[...]

all the fields being empty.

Can someone tell me what I did wrong ?

By the way, can someone point me to the API documentation ? sugardev.net being down, I couldn't find another resource, and the developer guide available at sugarcrm.com doesn't help...

thanks !

[Benjamin C. B.]

Nobody can help me ?

[eitrix]

it should be:
$lead = $lead->retrieve($_GET["leadid"]);

since retrieve return an object you want

[Benjamin C. B.]

Thanks for your reply. I found in modules/Leads.php the following code int the converted_lead function :

 $lead = new Lead();
$lead->retrieve($leadid);
$lead->status='Converted';
$lead->save(); 
  

which is why I thought my code was correct.

Though I still can't make it work. Here is what I have now :

 <?php
if(!defined('sugarEntry'))define('sugarEntry', true);
 
require_once('include/entryPoint.php');
require_once 'modules/Leads/Lead.php';
 
$lead = new Lead();
$lead=$lead->retrieve($_GET["leadid"]);
echo 'retrieveing '.$_GET["leadid"].'<br>';
var_dump($lead);
?>  

which displays :
retrieveing 260549b3-4cdc-4097-4199-4e5e2a510e42
NULL

Could it be that the leadid value is wrong ? I use the value that can be found in the record parameter in standard SugarCRM URLs.

Thanks again for your help !

[Benjamin C. B.]

Can't somebody help me ? Too bad...

[Benjamin C. B.]

come on people, I need this ! doesn't someone have a hint of what's wrong with my code ?

[Benjamin C. B.]

Last attempt. can't someone help me ? Maybe it's a security issue. Isn't it required to identify before using the API ?

[citapinc]

Ben:

I'm not a PHP programmer (well, not yet), but I did notice something odd. Look at your require_once statements. On the top statement you have the values surrounded with () while the second one does not. Will that make a difference?

Also do you need to pad the leadid with spaces or remove spaces to make it a fixed size so it can find the record?

Just some thoughts...

[Benjamin C. B.]

thanks for your reply
I don't think require_once needs parenthesis. I tried adding them, though, and it didn"t change anything.
About padding the id, I don't see why it should be needed, since it's exatly the same size as standard id in the database...