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
Select Opportunity.Fiscal, Quantity FROM OpportunityLineItem limit 2 (working as expected )
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.