Search results by user ID 6147

Re: Strange behavior of Customer.BillAddressAddr1 when adding via MethodAPIInsert

dbornet — Sun, 20 Oct 2013 17:18:31 GMT

I tried this. Had to remove "EntityType" which is a field that doesn't support Add. Then it worked fine.

Re: Strange behavior of Customer.BillAddressAddr1 when adding via MethodAPIInsert

dbornet — Sun, 20 Oct 2013 17:06:12 GMT

Ah! That makes sense, thanks.

No, what I put into Addr1 didn't move to Addr2, I was testing with Addr1 and Addr2, Addr1 disappeared (or sometimes got replaced by CompanyName) and Addr2 stayed put.

Perhaps you can just advise me on how to do what I need to do.

Via the API, what I'm trying to add is a Lead, not a Customer.

The lead has a name (first/last), a company name, an address (two lines thereof plus city, state and zip), phone number, email, website and a couple of other datums. This all comes from a form that was filled in on our website.

Other than the two lines of address, here are the fields I've populated: Name, FirstName, LastName, CompanyName, BillAddressCity, BillAddressState, BillAddressPostalCode, Phone, Email, Website, AltPhone and AssignedTo.

I've had no trouble with all of the various pieces except for the two lines of address, and how to flag that this record is a lead and not a customer.

Based on records already in Method that I exported and looked at, and based on what you wrote, I'm thinking (haven't tested this yet) that I should put the lead name into Addr1, my two lines of address into Addr2 and Addr3, set IsLeadStatusOnly to true, set EntityType to 'Customer Lead' and set LeadStatus to 'Open'.

Is that correct, or do you advise something else?

Thanks for your help!

Strange behavior of Customer.BillAddressAddr1 when adding via MethodAPIInsert

dbornet — Fri, 18 Oct 2013 02:46:21 GMT

I can duplicate this at will.

It goes like this (in all examples below, assume additional fields for valid strCompanyAccount, strLogin and strPassword, also assume that my actual code syntax is correct with all proper quotes and so on):

I use MethodAPIInsert to insert a record into the Customer table, with the following field/values:

Name = Daria Test1
FirstName = Daria
CompanyName = MyCompany
BillAddressAddr1 = "1 Main St".

I then (in the same code, immediately afterwards) use MethodAPISelect_XML with the following field/values

strTable = Customer
strFields = Name, FirstName, CompanyName, BillAddressAddr1
strWhereClause = "FirstName = 'Daria'"
strGroupByClause, strHaving and strOrderBy are empty.

IOW I pull all records where the first name is Daria.

It returns the following. This is correct.

<Record>
<Name>Daria Test1</Name>
<FirstName>Daria</FirstName>
<CompanyName>TheCompany</CompanyName>
<BillAddressAddr1>1 Main St</BillAddressAddr1>
</Record>

NOW I take the same code and change the insert field values as follows:

Name = Daria Test2
BillAddressAddr1 = "2 Main St".

other fields stay the same as they were.

I then run all this again (which does another insert and select, so there should now be two records with first name of Daria).

What it gives me is this:

<Record>
<Name>Daria Test1</Name>
<FirstName>Daria</FirstName>
<CompanyName>TheCompany</CompanyName>
<BillAddressAddr1 />
</Record>
<Record>
<Name>Daria Test2</Name>
<FirstName>Daria</FirstName>
<CompanyName>TheCompany</CompanyName>
<BillAddressAddr1>2 Main St</BillAddressAddr1>
</Record>

Take a good look at the first record. What happened to the address?

This repeats - if I add a 3rd record, it keeps its address but the 2nd record loses it.

If I now go into Method CRM and look at the records I created (any of them), the address is missing. And, having done so, if I now do just a select using the API function, the address is gone from all the records.

Is there something special about Addr1 that it should not be used?

Please advise...

Re: Unable to get a response for some V2 API methods using PHP (some work fine)

dbornet — Fri, 18 Oct 2013 02:04:00 GMT

Thanks I had missed that the strSessionId parameter was required. The documentation states

"If you know the unique current SessionID of a signed in user, you can pass this instead of strPassword", which makes it sound like an optional parameter, whereas in fact it has to be passed always, at least as an empty string.

I added the parameter as an empty string and all is now well, thanks.

Unable to get a response for some V2 API methods using PHP (some work fine)

dbornet — Tue, 15 Oct 2013 22:35:57 GMT

Hi,

I am using PHP to access the API webservice.

First attempt:

$soap = new SoapClient("https://www.methodintegration.com/MethodAPI/service.asmx?WSDL", array('trace' => true));

$result = $soap->MethodAPITableListV2(array( "strCompanyAccount" => "mycompany", "strLogin" => "mylogin", "strPassword" => "mypassword" ));

Result: This works perfectly. In $result it returns a nice XML with a response of "Success" and all the tables.

Second attempt:

$soap = new SoapClient("https://www.methodintegration.com/MethodAPI/service.asmx?WSDL", array('trace' => true));

$result = $soap->MethodAPIFieldListV2(array( "strCompanyAccount" => "mycompany", "strLogin" => "mylogin", "strPassword" => "mypassword", "strTable" => "Customer" ));

Result: Nothing. No response. It never returns. No error, it just hangs. Stops dead.

Third attempt:

$soap = new SoapClient("https://www.methodintegration.com/MethodAPI/service.asmx?WSDL", array('trace' => true));

$result = $soap->MethodAPIFieldList(array( "strCompanyAccount" => "mycompany", "strLogin" => "mylogin", "strPassword" => "mypassword", "strTable" => "Customer" ));

The only thing I changed here was to remove the "V2" from function name.

Result: Works perfectly.

Since the API manual only lists the V2 functions and not the plain (without "V2") functions, and since the Table one works fine in V2 but the FieldList one doesn't, it looks like there are some issues with the V2 vs plain functions.

FYI.