SalesForce API query doesn't show custom fields

Question

I have a custom date field for accounts in SalesForce: LastCheckedDate (API Name: LastCheckedDate__c)

I'm trying to use the SalesForce Enterprise API to query accounts based on that field. It returns results, and I can use the custom field in the WHERE part of the query, but I can't get it to actually show me the value of the custom field in the results.

This PHP code should get me the ID, name, and LastCheckedDate of any account that has been checked in 2011:

$query = "SELECT Id,Name,LastCheckedDate__c FROM Account WHERE LastCheckedDate__c > 2011-01-01";
$response = $salesforceConnection->query($query);

foreach ($response->records as $record) {               
    print_r($record);
}

It correctly only returns accounts that have been checked in 2011, but the result doesn't include the value of that custom field:

stdClass Object
(
    [Id] => 0015000000abcdefgh
    [Name] => Bob's Widget Factory
)

How can I get it to include the LastCheckedDate in the results objects?

I am having the same exact problem as this. I have an update to date WSDL and I know my code is correct because it worked perfectly in TEST. Moved to Prod, updated WSDL and it just doesn't show custom fields. — Jacob Raccuia
– Jacob Raccuia, Commented Dec 6, 2013 at 17:03

kerem · Accepted Answer · 2012-08-16 12:30:39Z

7

Update your wsdl file. So You can not select or update any field that are not in the wsdl file.

answered Aug 16, 2012 at 12:30

kerem

651 silver badge2 bronze badges

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

2 Comments

Yaroslav Over a year ago

What does your answer improve on the accepted one? This should be a comment, not an answer

Svetoslav Marinov Over a year ago

Actually, it was very useful one. After I regenerated my wsdl file my custom fields started showing up not just the Ids. ref: github.com/developerforce/Force.com-Toolkit-for-PHP/issues/52

Community · Accepted Answer · 2017-05-23 11:52:46Z

4

Seems like you are having the same problem as is addressed in this question: SalesForce.com: Retrieve custom fields via PHP.

It is related to how you are parsing the returned data.

edited May 23, 2017 at 11:52

CommunityBot

11 silver badge

answered May 23, 2011 at 23:22

lnediger

1,3402 gold badges13 silver badges15 bronze badges

1 Comment

NChase Over a year ago

Ahhh...it wasn't how I was parsing the results, but that thread pointed me in the right direction - I needed to generate an updated enterprise.wsdl.xml with the new custom field. Thanks!

Collectives™ on Stack Overflow

SalesForce API query doesn't show custom fields

2 Answers 2

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related