Get All Leads

[Anonymous]

I have a User Id and Encryption key... Is it possible to pull all leads in php using SOAP? 

[Anonymous]

Yes, it is, using SOAP API's getMultiupleLeads.

In PHP you need to:

- provide User ID and Encryption key to generate the server signature and timestamp

- define a XML call in a loop to read leads in batches

SOAP API Calls returning multiple records - reading the next batch

https://community.marketo.com/MarketoArticle?id=kA050000000L6LHCA0

The article "Marketo Enterprise SOAP API"

https://community.marketo.com/MarketoArticle?id=kA050000000Kz59CAC

links to a PHP example containing the authentication method to generate the server signature and timestamp.

The generic XML call is

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:mkt="http://www.marketo.com/mktows/">

   <soapenv:Header>

      <mkt:AuthenticationHeader>

         <mktowsUserId>?</mktowsUserId>

         <requestSignature>?</requestSignature>

         <requestTimestamp>?</requestTimestamp>

         <!--Optional:-->

         <audit>?</audit>

         <!--Optional:-->

         <mode>?</mode>

      </mkt:AuthenticationHeader>

   </soapenv:Header>

   <soapenv:Body>

      <mkt:paramsGetMultipleLeads>

         <!--Optional:-->

         <leadSelector/>

         <!--Optional:-->

         <lastUpdatedAt>?</lastUpdatedAt>

         <!--Optional:-->

         <streamPosition>?</streamPosition>

         <!--Optional:-->

         <batchSize>?</batchSize>

         <!--Optional:-->

         <includeAttributes>

            <!--Zero or more repetitions:-->

            <stringItem>?</stringItem>

         </includeAttributes>

      </mkt:paramsGetMultipleLeads>

   </soapenv:Body>

</soapenv:Envelope>

A generic PHP authentication can be defined as

$signature = '';

if(isset($_POST["user"]) && isset($_POST["encryption"])){ // execute only if both are set

$request_time = date(DATE_W3C, time());

$access_key = trim($_POST["user"]);

$secret_key = trim($_POST["encryption"]);

$encrypt_input = $request_time . $access_key;

$signature = hash_hmac('sha1', $encrypt_input, $secret_key);

}

else {

$_POST["user"] = '';

$_POST["encryption"] = '';

}



and then

$attrs = array(

'mktowsUserId'     => $access_key,

'requestSignature' => $signature,

'requestTimestamp' => $request_time,

);

$header = new SoapHeader('http://www.marketo.com/mktows/', 'AuthenticationHeader', $attrs);
 

[Anonymous]

Hi,


Thanks for the reply.

Couple of doubt...

should the offsets incrment only in multiples of two?
And should the offset always start with 4?
Also i don't see where the marketo end point is used.

[Anonymous]

The offset is ncremented by the same number you would use for <batchSize>

Each getMultipleLeads function call can only return batches of 1000 leads, maximum. If this call needs to return more than 1000 leads, the result will return a start position, which should be used in subsequent calls to retrieve the next set of leads. 
Please keep in mind 1000 leads per batch is the maximum. It is always a good idea to start with a lower number (say 500 or even 250 for testing) and increase while you do not receive errors caused by PHP (server-side) memory exhaustion. 

 

[Anonymous]

The endpoint is used when you generate the server signature and timestamp.

Please review the article "Marketo SOAP API PHP client" for details and a fully working example
https://community.marketo.com/MarketoArticle?id=kA050000000Kz59CAC

[Anonymous]

this is the code i've managed to write till now... no output though... 😞 can anyone guide me please!

$signature = "xxxxx";

$user_id = "xxxx";

$encryption_key = "";

if (isset($user_id) && isset($encryption_key)) { // execute only if both are set

    $request_time = date(DATE_W3C, time());

    $access_key = trim($user_id);

    $secret_key = trim($encryption_key);

    $encrypt_input = $request_time . $access_key;

    $signature = hash_hmac('sha1', $encrypt_input, $secret_key);

} else {

    $user_id = '';

    $encryption_key = '';

}

//$client = new SoapClient(null);

$attrs = array(

    'mktowsUserId' => $access_key,

    'requestSignature' => $signature,

    'requestTimestamp' => $request_time,

);

$client = new SoapClient("http://090-BZJ-603.mktoapi.com/soap/mktows/1_2?WSDL");

$header = new SoapHeader('http://www.marketo.com/mktows/', 'AuthenticationHeader', $attrs);

$client->__setSoapHeaders($header);

$xml = '<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:mkt="http://www.marketo.com/mktows/">

   <soapenv:Header>

      <mkt:AuthenticationHeader>

         <mktowsUserId>'.$access_key.'</mktowsUserId>

         <requestSignature>'.$signature.'</requestSignature>

         <requestTimestamp>'.$request_time.'</requestTimestamp>

      </mkt:AuthenticationHeader>

   </soapenv:Header>

   <soapenv:Body>

      <mkt:paramsGetMultipleLeads>

      </mkt:paramsGetMultipleLeads>

   </soapenv:Body>

</soapenv:Envelope>';

print_r($client->__call("getMultipleLeads",$xml));

[Anonymous]

mkt:paramsGetMultipleLeads defines the database query. It is not declared yet, the reason there is no output.

lastUpdatedAt would allow to set a well define point in time or includeAttributes would allow to set a more granular filter.