• NickdJ
  • NEWBIE
  • 0 Points
  • Member since 2008

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 2
    Questions
  • 3
    Replies
Hi,

I'm having a problem getting the sforce API to return all columns through the API.  My scenario is this:-

(a) I have a custom object called "Foo Bar", hence the table name is Foo_Bar__c
(b) I have custom fields within that object, named apple, orange, banana, hence columns named apple__c orange__c and banana__c
(c) I have downloaded the freshly generated enterprise.wsdl that includes references to apple__c orange__c and banana__c etc...

Query example would be:-
"""
select apple__c, orange__c, banana__c from Foo_Bar__c
"""

Through the API I am able to retrieve some columns but not others without any appreciable logic as to why.  I've checked permissions, types, etc etc etc and I simply can't see what else I should be looking for.  Is there some kind of limit to the number of custom fields (columns) that an object can have that I'm unaware of?

Any ideas?

I'm using the sforce-phptoolkit on salesforce enterprise edition.  Please pardon my cross post here from the General Development board.

N
Hi,

I'm having a problem getting the sforce API to return some columns of data through the API.  My scenario is this:-

(a) I have a custom object called Foo Bar, hence the table name is Foo_Bar__c
(b) I have custom fields within that object, named apple, orange, banana, hence columns named apple__c orange__c and banana__c
(c) I have downloaded the freshly generated enterprise.wsdl that includes references to apple__c orange__c and banana__c etc...

Through the API I am able to retrieve some columns but not others without any appreciable logic as to why.  I've checked permissions, types, etc etc etc and I simply can't see what else I should be looking for.

Any ideas?

I'm using the sforce-phptoolkit

N



Message Edited by NickdJ on 07-24-2008 11:52 AM
Hi,

I'm having a problem getting the sforce API to return all columns through the API.  My scenario is this:-

(a) I have a custom object called "Foo Bar", hence the table name is Foo_Bar__c
(b) I have custom fields within that object, named apple, orange, banana, hence columns named apple__c orange__c and banana__c
(c) I have downloaded the freshly generated enterprise.wsdl that includes references to apple__c orange__c and banana__c etc...

Query example would be:-
"""
select apple__c, orange__c, banana__c from Foo_Bar__c
"""

Through the API I am able to retrieve some columns but not others without any appreciable logic as to why.  I've checked permissions, types, etc etc etc and I simply can't see what else I should be looking for.  Is there some kind of limit to the number of custom fields (columns) that an object can have that I'm unaware of?

Any ideas?

I'm using the sforce-phptoolkit on salesforce enterprise edition.  Please pardon my cross post here from the General Development board.

N
Hi,

I'm having a problem getting the sforce API to return some columns of data through the API.  My scenario is this:-

(a) I have a custom object called Foo Bar, hence the table name is Foo_Bar__c
(b) I have custom fields within that object, named apple, orange, banana, hence columns named apple__c orange__c and banana__c
(c) I have downloaded the freshly generated enterprise.wsdl that includes references to apple__c orange__c and banana__c etc...

Through the API I am able to retrieve some columns but not others without any appreciable logic as to why.  I've checked permissions, types, etc etc etc and I simply can't see what else I should be looking for.

Any ideas?

I'm using the sforce-phptoolkit

N



Message Edited by NickdJ on 07-24-2008 11:52 AM