SalesForce.com custom Query operation issue

, ,
1

Hello,

i am new to SalesForce adapter, as per my business requierment i need to fetch data from different salesForce schema objects, for which i am using Custom Query operation.
The issue is while, executing SOQL (Sales force Query language) in WM from custom query operation, not able to access parent level attributes which are at 2 level in hierarchy of child-parent relationship

Example:-

  1. Select Opportunity.Fiscal, Quantity FROM OpportunityLineItem limit 2 (working as expected )

  2. Select Opportunity.Account.Name, Opportunity.Fiscal, Quantity FROM OpportunityLineItem limit 2 (working, but Account node is coming as null, not able to access accountName)

As per SOQL documents both above queries are valid and we can traverse upto 5 level in this relationship.
It would be quite helpful, if anyone have idea how to traverse these attributes in webMethods.

Thanks
Ashish