Hi,
Every now and then I see this error:
500 read failed: at Salesforce.pm line 80

recorded in my error capture file. That specific line reads:

my $r = $client->query($self->get_session_header(),
$self->get_client_header(),
SOAP:ata->name('query' => $in{'query'}),
SOAP::Header->name('QueryOptions' => \SOAP::Header->name('batchSize' => $in{'limit'})));

(I think I've slightly modified it from the original Salesforce.pm.)

Any ideas why this might be happening? It's intermittent, so it's clearly not a syntax error or something like that.

Hi,
I'm developing an application that provides several links into a customer's SFDC database. Unfortunately, I've found at least two versions of links:
https://na1.salesforce.com/... and https://ssl.salesforce.com/...

And if we provide the wrong type of link, the customer is forced to re-login for each link. Any way I can determine the right domain through the API, so I can reliably provide the right link?

Thanks!

Hi,
I'm trying to run a retrieve and finding that some of the fields are not returned. Completely stumped.

Background: I'm using Salesforce.pm and Perl. Using Data Dumper on the call and response gives:
Call:
$VAR1 = {
'fields' => 'Id,AccountId,OwnerId,email_notification__c,Languages__c,Level__c',
'ids' => [
'00330000001lzUP'
],
'type' => 'Contact'
};

Response:
$VAR1 = bless( {
'Id' => '00330000001lzUPAAY',
'AccountId' => '001300000018DA1AAM',
'OwnerId' => '00530000000cIpFAAU',
'Languages__c' => 'English',
'Level__c' => 'Primary'
}, 'Contact' );

Notice that email_notification__c is not returned. Neither is it returning a fault along the lines of "Invalid field". It just calmly returns some but not all.

Any ideas?

Hi,
Yes, that fun internationalization topic again. I'm struggling with this one.

Some background: perl script using query method from Salesforce.pm.

The query: select Id from Contact where (Email='junk@junk.com' or (FirstName='test' and LastName='Pérez'))

That last name seems to be the trouble. I get back the following fault string:
MALFORMED_QUERY: malformed query: unexpected token: (followed by what seems to be the sessionID).

And yes, I am doing:
my $last_name = Encode::encode_utf8($_[2]);
($_[2] is the last name)

If I don't use encode_utf8, I get the following Perl error:
Wide character in subroutine entry at [perl directory]/SOAP/Lite.pm line 129, which is the base64 subroutine. Poked around the web and found this:
http://cookbook.soaplite.com/#internationalization%20and%20encoding
but that didn't really seem to help. At least, I couldn't figure out how to make it help.

Any ideas? Not sure about this one, but it seems to only happen on the query. I know I have sent utf-8 characters to the update method.

Hi,
We have noticed a lot of variable times for our API calls and we are trying to determine whether this is related to just simply server load or whether it is also related to Internet traffic. e.g. if a company is headquartered in Europe, is it likely that their API servers are also in Europe? And since our API calls originate in the US West Coast, how much impact will this have on the call-response times? Is there a way to force the API to look at a US copy of the database?

The particular calls we are talking about are xml-rpc calls, but I don't think that should make a difference. Right?

Anybody else pondered this question and found any answers?

Is there a time limit as to how long a querymore locator/cursor will live even if I'm actively calling it to get additional records?

I am trying to retrieve about a million records which takes 5+ hours and am getting the error below around 5 hours in:

UNKNOWN_EXCEPTION: An unexpected error occured. Please include this ErrorId if you contact support: 1266558833-34

Thanks,
Jon

i need to assign new leads to certain queue 's using web to lead - each queue should have his own ID (such as 33, numeric value) and I should create different links for each queue.  When the queue link is clicked, that lead should be assigned to that queue.  Seems easy, but I cannot figure it out.  Any help would be greatly appreciated I feel the answer is staring me right in the face.

joe
www.eliteeservices.net

I've been having some trouble wrapping my head around this one. Hope someone can help. I'd really appreciate the help.

I want to reliably iterate ove the responses from my queries. Not sure how I'd do that when the URL for the results are different for query (//queryResponse/result/records') and querymore (//queryMoreResponse/result/records').

Can someone help me out with some sample code? I've been trying to translate the c++ code provided in the API doc to perl without any luck. This one doesnt work.

$r = $sf->query('query' => "select Id from Case" );
$numrecords = $r->valueof('//queryResponse/result')->{size};
my $done = "false";
if ( $numrecords > 0 ) {
        while ( uc($done) eq "FALSE" ) {
                foreach $elem ( $r->valueof('//queryResponse/result/records') ) {
                        print $elem->{Id}[0]."\n";
                }
                $done = $r->valueof('//queryResponse/result')->{done};
                if ( uc($done) eq "FALSE" ) {
                        $r = $sf->queryMore( 'queryLocator' => $r->valueof('//queryResponse/result')->{queryLocator} );
                        $numrecords = $r->valueof('//queryMoreResponse/result')->{size};
                        foreach $elem ( $r->valueof('//queryMoreResponse/result/records') ) {
                                print $elem->{Id}[0]."\n";
                        }
                } else {
                        $done = $r->valueof('//queryResponse/result')->{done};
                }
        }
} else {
        print "No records match criteria\n";
}

Message Edited by sk2006 on 05-23-2006 06:04 AM

Hi all,

I am wondering if the following is safe to assume always true.

http://*.salesforce.com/{Id} to reference a particular record in the database?

In my application I associate opportunities with opportunities in sales force. I would like to add a link, when the user clicks on it, I open a browser window that goes to sales force and after the user enters credentials is forwarded to that Opp. page. I know this is possible, is there a certain format for the URL link? Is there a place where I can get information for these kind of tasks?

Hi,

I'm trying to POST to WebToLead service through the servlet http://www.salesforce.com/servlet/servlet.WebToLead however I do not seem to beable to get the thing to work. The HTML generated from salesforce.com works fine, then I would presume posting the same information as in the form to http://www.salesforce.com/servlet/servlet.WebToLead would also work but no leads are generated in salesforce.com.

Has anyone got this to work from PHP? Has anyone got some working example code?

p.s. I do not want to use the API.

Thanks for your time
Tim

Does anyone know if there is a way to use the saleforce "id" value to input into salesforce instead of the "name" value (or any other value rather than the name). I want to validate a form I created with custom fields but I don't want to use the assigned number they gave to it.

For example, when a user submits the form, a pop-up box comes up and says "00N00000006pBHe is required". I'd rather it say "Your Name is required" but when I change the name value to read "your name" instead of "00N00000006pBHe" it doesn't get captured into salesforce.

Message Edited by ccutlerbrown on 02-22-2006 09:24 AM

Message Edited by ccutlerbrown on 02-22-2006 09:25 AM

Hi,

I am looking for the way to retrieve default value from Member Status Values. thanks.

regards,
sq

I just want to confirm that I can not create a Custom Object and then define a lookup relationship to that same Custom Object (to create a hierarchical relationship, for example). An example might be a Custom Object called "Folder" which has a lookup relationship called "Parent Folder" of type "Folder".

Hello,
On lead conversion : I want to map lead custom field to the custom field on Account, as well to the custom field on opprtunity. As of now I can map to only one custom field(either account or oppty). Is there a way to map to two objects/ fields?????????
I appreciate your help.

I'm running a php program that queries data from a local database and uses the API to create records in Salesforce.com. The code worked perfectly up until two days ago when I started recieving errors like this:

Error: XML error on line 1 col 4 byte 4 not well-formed (invalid token)
Error: org.xml.sax.SAXParseException: Invalid byte 2 of 2-byte UTF-8 sequence.
Error: curl_exec error 28 Operation timed out with 1276 out of -1 bytes received

I was wondering if anyone else was having problems like is?

Hi,

Is there an API available that we can use to retrieve a user's first, last names and email address?

I heard there is a contactID associated to be a primary key in the database?

Any help is appreciated!

Thanks.
Philip