Method:API Q&A

Re: MethodAPISelect_XMLV2 returns non-array for multiple results

furrywombat — Tue, 19 Nov 2013 14:56:43 GMT

David,

Thanks for pointing out the obvious! You would not believe how much time I spent tearing my hair out over this. How embarrassing :) Greatly appreciated.

Best,

Charles

Re: MethodAPISelect_XMLV2 returns non-array for multiple results

Method_David — Tue, 19 Nov 2013 14:46:49 GMT

Hi furrywombat,

MethodAPISelect_XMLV2 does not return a string array. It returns a string of xml. Look closer at the raw response you should see something like

<?xml version="1.0" encoding="windows-1252" ?><MethodAPI response = "Success" MaxRecords= "False"><MethodIntegration Table='Customer'><CompanyName>MyCompany</CompanyName> <RecordID>64</RecordID> </Record> <Record> <CompanyName>MyOtherCompany</CompanyName> <RecordID>66</RecordID> </Record></MethodIntegration></MethodAPI>

Dave

MethodAPISelect_XMLV2 returns non-array for multiple results

furrywombat — Tue, 19 Nov 2013 14:06:42 GMT

API call is returning a string, when it should be returning an array. Look:

object(stdClass)#2 (1) {
["MethodAPISelect_XMLV2Result"]=>
string(377) "

ACME, INC
1060

OTHER, INC
1742

"
}

Here's the code:

$soap = new SoapClient("https://www.methodintegration.com/MethodAPI/service.asmx?WSDL");

$result = $soap->MethodAPISelect_XMLV2(array(

"strCompanyAccount" => "foobar",
"strLogin" => "foobar",
"strPassword" => "foobar",
"strSessionID" => "",
"strTable" => "Customer",
"strFields" => "CompanyName,RecordID",
"strWhereClause" => "Email = 'email@address.com'"

));

echo "<code><pre>";

var_dump($result);

echo "</pre></code>";

Why am I not getting an array? I cannot work with a string like this.