• jasonz
  • NEWBIE
  • 0 Points
  • Member since 2006

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 2
    Questions
  • 2
    Replies
I have this problem with salesforce API access from java based on partner WSDL, salesforce support guys cannot resolve this :-(
Really appreciated if anyone can help.

Person Account is a quite new feature from salesforce, and we want to be able to get PersonContactId value from a Person Account based on account ID.  Here is the query which is executed from Java:

QueryResult qr = binding.query("select Id,Name,PersonContactId from Account where id='xxxxxxxxxxxxxxxx'");

And it returned error:

INVALID_FIELD:
select Id,Name,PersonContactId from Account where
^
ERROR at Row:1:Column:16
No such column 'PersonContactId' on entity 'Account'. If you are attempting to
use a custom field, be sure to append the '__c' after the custom field name.
Please reference your WSDL or the describe call for the appropriate names.

But the funny thing is it works if the query is executed from Apex Exlorer 8, i.e., it returned correct PersonContactId value based on account ID.

I also ran describeSObjects() on Account object with java code, and it returns the following fields (Note: it doesn't have any fields when IsPersonAccount = true, including PersonContactId).

############ Account #################
Field name=Id
Field name=Name
Field name=Type
Picklist values =
Item: Prospect
Item: Customer - Direct
Item: Customer - Channel
Item: Channel Partner / Reseller
Item: Installation Partner
Item: Technology Partner
Item: Other
Field name=RecordTypeId
Field references the following objects:
RecordType
Field name=ParentId
Field references the following objects:
Account
Field name=BillingStreet
Field name=BillingCity
Field name=BillingState
Field name=BillingPostalCode
Field name=BillingCountry
Field name=ShippingStreet
Field name=ShippingCity
Field name=ShippingState
Field name=ShippingPostalCode
Field name=ShippingCountry
Field name=Phone
Field name=Fax
Field name=AccountNumber
Field name=Website
Field name=Sic
Field name=Industry
Picklist values =
Item: Agriculture
Item: Apparel
Item: Banking
Item: Biotechnology
Item: Chemicals
Item: Communications
Item: Construction
Item: Consulting
Item: Education
Item: Electronics
Item: Energy
Item: Engineering
Item: Entertainment
Item: Environmental
Item: Finance
Item: Food & Beverage
Item: Government
Item: Healthcare
Item: Hospitality
Item: Insurance
Item: Machinery
Item: Manufacturing
Item: Media
Item: Not For Profit
Item: Recreation
Item: Retail
Item: Shipping
Item: Technology
Item: Telecommunications
Item: Transportation
Item: Utilities
Item: Other
Field name=AnnualRevenue
Field name=NumberOfEmployees
Field name=Ownership
Picklist values =
Item: Public
Item: Private
Item: Subsidiary
Item: Other
Field name=TickerSymbol
Field name=Description
Field name=Rating
Picklist values =
Item: Hot
Item: Warm
Item: Cold
Field name=Site
Field name=OwnerId
Field references the following objects:
User
Field name=CreatedDate
Field name=CreatedById
Field references the following objects:
User
Field name=LastModifiedDate
Field name=LastModifiedById
Field references the following objects:
User
Field name=SystemModstamp
Field name=LastActivityDate
Field name=NumberofLocations__c
Field name=SLAExpirationDate__c
Field name=UpsellOpportunity__c
Picklist values =
Item: Maybe
Item: No
Item: Yes
Field name=SLASerialNumber__c
Field name=SLA__c
Picklist values =
Item: Gold
Item: Silver
Item: Bronze
Item: Platinum
Field name=CustomerPriority__c
Picklist values =
Item: High
Item: Low
Field name=Active__c
Picklist values =
Item: No
Item: Yes
############ Account #################
  • February 11, 2008
  • Like
  • 0
My appology if this has been questioned and answered before.  I'd like to know if apache Axis version 1.4 has been officially supported or not.

From what I read from AppExchange API v7.0 documentation, it supports Axis 1.3 and JDK 5.0.

Thanks

jason


  • September 19, 2006
  • Like
  • 0
I have this problem with salesforce API access from java based on partner WSDL, salesforce support guys cannot resolve this :-(
Really appreciated if anyone can help.

Person Account is a quite new feature from salesforce, and we want to be able to get PersonContactId value from a Person Account based on account ID.  Here is the query which is executed from Java:

QueryResult qr = binding.query("select Id,Name,PersonContactId from Account where id='xxxxxxxxxxxxxxxx'");

And it returned error:

INVALID_FIELD:
select Id,Name,PersonContactId from Account where
^
ERROR at Row:1:Column:16
No such column 'PersonContactId' on entity 'Account'. If you are attempting to
use a custom field, be sure to append the '__c' after the custom field name.
Please reference your WSDL or the describe call for the appropriate names.

But the funny thing is it works if the query is executed from Apex Exlorer 8, i.e., it returned correct PersonContactId value based on account ID.

I also ran describeSObjects() on Account object with java code, and it returns the following fields (Note: it doesn't have any fields when IsPersonAccount = true, including PersonContactId).

############ Account #################
Field name=Id
Field name=Name
Field name=Type
Picklist values =
Item: Prospect
Item: Customer - Direct
Item: Customer - Channel
Item: Channel Partner / Reseller
Item: Installation Partner
Item: Technology Partner
Item: Other
Field name=RecordTypeId
Field references the following objects:
RecordType
Field name=ParentId
Field references the following objects:
Account
Field name=BillingStreet
Field name=BillingCity
Field name=BillingState
Field name=BillingPostalCode
Field name=BillingCountry
Field name=ShippingStreet
Field name=ShippingCity
Field name=ShippingState
Field name=ShippingPostalCode
Field name=ShippingCountry
Field name=Phone
Field name=Fax
Field name=AccountNumber
Field name=Website
Field name=Sic
Field name=Industry
Picklist values =
Item: Agriculture
Item: Apparel
Item: Banking
Item: Biotechnology
Item: Chemicals
Item: Communications
Item: Construction
Item: Consulting
Item: Education
Item: Electronics
Item: Energy
Item: Engineering
Item: Entertainment
Item: Environmental
Item: Finance
Item: Food & Beverage
Item: Government
Item: Healthcare
Item: Hospitality
Item: Insurance
Item: Machinery
Item: Manufacturing
Item: Media
Item: Not For Profit
Item: Recreation
Item: Retail
Item: Shipping
Item: Technology
Item: Telecommunications
Item: Transportation
Item: Utilities
Item: Other
Field name=AnnualRevenue
Field name=NumberOfEmployees
Field name=Ownership
Picklist values =
Item: Public
Item: Private
Item: Subsidiary
Item: Other
Field name=TickerSymbol
Field name=Description
Field name=Rating
Picklist values =
Item: Hot
Item: Warm
Item: Cold
Field name=Site
Field name=OwnerId
Field references the following objects:
User
Field name=CreatedDate
Field name=CreatedById
Field references the following objects:
User
Field name=LastModifiedDate
Field name=LastModifiedById
Field references the following objects:
User
Field name=SystemModstamp
Field name=LastActivityDate
Field name=NumberofLocations__c
Field name=SLAExpirationDate__c
Field name=UpsellOpportunity__c
Picklist values =
Item: Maybe
Item: No
Item: Yes
Field name=SLASerialNumber__c
Field name=SLA__c
Picklist values =
Item: Gold
Item: Silver
Item: Bronze
Item: Platinum
Field name=CustomerPriority__c
Picklist values =
Item: High
Item: Low
Field name=Active__c
Picklist values =
Item: No
Item: Yes
############ Account #################
  • February 11, 2008
  • Like
  • 0
My appology if this has been questioned and answered before.  I'd like to know if apache Axis version 1.4 has been officially supported or not.

From what I read from AppExchange API v7.0 documentation, it supports Axis 1.3 and JDK 5.0.

Thanks

jason


  • September 19, 2006
  • Like
  • 0