SalesForce.com: Retrieve custom fields via PHP

Question

I have a simple custom contact object (with API name Contact__c) that I've created in my SalesForce DE site that has a single field (for testing connectivity) of Full_Name__c.

I am then trying to retrieve all of the contacts, specifically this field via PHP:

try {
  $mySforceConnection = new SforcePartnerClient();
  $mySoapClient       = $mySforceConnection->createConnection(API_PATH . '/soapclient/partner.wsdl');
  $mylogin            = $mySforceConnection->login(API_USER, API_PASS . API_SECURITY_TOKEN);

  $query = 'SELECT C.Id, C.Full_Name__c
          FROM Contact__c C'; 
  $result = $mySforceConnection->query($query);
  $sObject = new SObject($result->records[0]);
  print_r($sObject);
} catch(Exception $e) {
  print_r($e);
}

I've downloaded the latest partner.wdsl (although as a partner WSDL, it is loosely typed and does not need to be downloaded with the creation/addition of custom objects and/or updated fields, correct?). I've verified that the user can connect and see the custom fields via the ForceExplorer. But when I run the above code, it connects but returns just the following:

SObject Object ( [type] => Contact__c [fields] => [Id] => a )

I am not getting any errors, invalid field error, etc, but for the life of me can't figure out why this isn't working.

I saw this example here, but it seems to be specific to Enterprise vs Partner, and the need to download the latest enterprise.wsdl every-time you change custom fields.

Any pointers?

Unpossible · Accepted Answer · 2011-05-17 14:10:50Z

4

Figured it out I believe, the problem related to how I was parsing the data that was being returned. Instead of feeding the returned data into an SObject, I am now just accessing it directly:

try {
  $mySforceConnection = new SforcePartnerClient();
  $mySoapClient       = $mySforceConnection->createConnection(API_PATH . '/soapclient/partner.wsdl');
  $mylogin            = $mySforceConnection->login(API_USER, API_PASS . API_SECURITY_TOKEN);

  $query = 'SELECT C.Id, C.Full_Name__c
            FROM Contact__c C'; 
  $result = $mySforceConnection->query($query);

  for($i = 0; $i < count($result->records); $i++) {
    print_r($result->records[$i]->fields->Full_Name__c); 
  }
} catch(Exception $e) {
  print_r($e);
}

answered May 17, 2011 at 14:10

Unpossible

10.7k23 gold badges78 silver badges115 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jacob Raccuia Over a year ago

I'm glad this helped you, but I don't think this is the answer. I am doing a print_r of result and my custom fields don't show. The WSDL is also updated. hmmm

Jacob Raccuia Over a year ago

ini_set('soap.wsdl_cache_enabled', '0'); JUST FIXED MY PROBLEM!

Mike Walkowiak · Accepted Answer · 2014-07-28 19:29:04Z

4

ini_set('soap.wsdl_cache_enabled', '0');

It does the trick.

answered Jul 28, 2014 at 19:29

Mike Walkowiak

3912 silver badges9 bronze badges

2 Comments

Romain Over a year ago

It solves the problem of the old WSDL file (without all the new created/updated objects and fields) being cached by the system. Thanks to this, it forces the app to use the new updated WSDL file and thus allow to use new fields and objects since the last cached version.

nmjk Over a year ago

Thank you!! I spent the last 2 hours trying to figure out why certain fields could be used in the WHERE condition but weren't showing in the results. This fixed it immediately. Adding to my standard code header.

Collectives™ on Stack Overflow

SalesForce.com: Retrieve custom fields via PHP

2 Answers 2

2 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related