• deafpanda
  • NEWBIE
  • 25 Points
  • Member since 2012

  • Chatter
    Feed
  • 1
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 2
    Replies

Hey there,

 

I'm having trouble accessing custom fields using the SOAP API with PHP.  Here's my query:

SELECT npo02__Formula_MailingAddress__c, npo02__HouseholdPhone__c, npo02__MailingCity__c, npo02__MailingCountry__c, npo02__MembershipJoinDate__c, npo02__MembershipEndDate__c FROM npo02__Household__c

 This query works fine on Force.com explorer.  Using SForceEnterpriseClient->query(), here is what the exact same query returns:

QueryResult Object
(
    [queryLocator] => 
    [done] => 1
    [records] => Array
        (
            [0] => SObject Object
                (
                    [type] => 
                    [fields] => 
                )

            [1] => SObject Object
                (
                    [type] => 
                    [fields] => 
                )

            [2] => SObject Object
                (
                    [type] => 
                    [fields] => 
                )

            [3] => SObject Object
                (
                    [type] => 
                    [fields] => 
                )
.....etc

 

Can someone explain what I'm doing wrong?  Non-custom fields are picked up fine, but I can't seem to access any custom fields through the API.

 

Thanks a lot!

Hey there,

 

I'm having trouble accessing custom fields using the SOAP API with PHP.  Here's my query:

SELECT npo02__Formula_MailingAddress__c, npo02__HouseholdPhone__c, npo02__MailingCity__c, npo02__MailingCountry__c, npo02__MembershipJoinDate__c, npo02__MembershipEndDate__c FROM npo02__Household__c

 This query works fine on Force.com explorer.  Using SForceEnterpriseClient->query(), here is what the exact same query returns:

QueryResult Object
(
    [queryLocator] => 
    [done] => 1
    [records] => Array
        (
            [0] => SObject Object
                (
                    [type] => 
                    [fields] => 
                )

            [1] => SObject Object
                (
                    [type] => 
                    [fields] => 
                )

            [2] => SObject Object
                (
                    [type] => 
                    [fields] => 
                )

            [3] => SObject Object
                (
                    [type] => 
                    [fields] => 
                )
.....etc

 

Can someone explain what I'm doing wrong?  Non-custom fields are picked up fine, but I can't seem to access any custom fields through the API.

 

Thanks a lot!