function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Sento_Dev.ax33Sento_Dev.ax33 

ERROR querying contact businessPhone using perl toolkit

I can query the firstName, lastName, and email from contacts, but get an error anytime I try to query the businessPhone. The perl toolkit version salesforce-0.51 is being used, which was downloaded from majordojo.com (?) Compression is turned on, and soap::lite is in debug mode. Below is the request built by the perl toolkit in debug mode, and the response from sforce. Any help is appreciated.

SOAP::Transport::HTTP::Client::send_receive: POST https://na1-api.salesforce.com/services/Soap/u/2.5
Accept: text/xml
Accept: multipart/*
Accept-Encoding: deflate
Content-Length: 866
Content-Type: text/xml; charset=utf-8
SOAPAction: ""





mcvxVjIskN8m4F000ljUzESVe8JKXvnDFkT5hMcM_vzU2kqUrVW5__Mj7_FfGOiBiN.V38H2iIIBuuZgF9S5lfbtzKggVlhL








select firstName, lastName, email, businessPhone, id from contact where lastModifiedDate > 2004-02-15




SOAP::Transport::HTTP::Client::send_receive: HTTP/1.1 500 Internal Server Error
Date: Tue, 17 Feb 2004 17:23:44 GMT
Server: Resin/2.1.s030924
Content-Type: text/xml; charset=utf-8
Client-Date: Tue, 17 Feb 2004 17:23:45 GMT
Client-Response-Num: 1
Client-SSL-Cert-Issuer: /O=VeriSign Trust Network/OU=VeriSign, Inc./OU=VeriSign International Server CA - Class 3/OU=www.verisign.com/CPS Incorp.by Ref. LIABILITY LTD.(c)97 VeriSign
Client-SSL-Cert-Subject: /C=US/ST=California/L=San Francisco/O=Salesforce.com, Inc./OU=Applications/OU=Terms of use at www.verisign.com/RPA (c)01/CN=na1-api.salesforce.com
Client-SSL-Cipher: DES-CBC3-SHA
Client-SSL-Warning: Peer certificate not verified
Client-Transfer-Encoding: chunked





soapenv:Server
INVALID_FIELD: Invalid name: businessphone in Contact


INVALID_FIELD
Invalid name: businessphone in Contact





adamgadamg
BuinessPhone is not a valid (default) field name. If it is a custom field, then try businessphone__c, if not, try phone.
Sento_Dev.ax33Sento_Dev.ax33

Thanks for the reply. Phone works...the weird thing is that businessPhone is listed in the contact describe, but does not have the cf_xxxxxx format. It does not have xxxx_c either. Here's what I see from the describe (using 2.0 api)

- <value xsi:type="tns:map">
- <display xsi:type="tns:map">
  <type xsi:type="xsd:string">phone</type>
  </display>
  <type xsi:type="xsd:string">string</type>
  <label xsi:type="xsd:string">Business Phone</label>
  <length xsi:type="xsd:int">40</length>
  <field xsi:type="xsd:string">businessPhone</field>
  </value>
 
Regardless, thanks for the help!