+ Start a Discussion
atidevatidev 

sobject not supported

Hi,

  I have this query which I am running from .NET using Salesforce web service . I get the error that sObject type 'OpportunityLineItem' is not supported. I checked the WSDL and the opbject name does exist in that. 

SELECT Opportunity.Owner.Name, Opportunity.Territory.Name, Opportunity.Account.Market__c, Opportunity.Name, Opportunity.ID, OOpportunity.Account.Name, Opportunity.Probability,  totalprice,  FROM OpportunityLineItem.

Wondering if anyone has faced the issue.

Thanks,

SrikanthKuruvaSrikanthKuruva

did you try the same query from apex explorer?

cloudcodercloudcoder

you have some syntax problems in your query. I have highlighted them in red. aside from the typo with OOpportunity, the cause of your error is the comma after total price. You don't need it.

 

SELECT Opportunity.Owner.Name, Opportunity.Territory.Name, Opportunity.Account.Market__c, Opportunity.Name, Opportunity.ID, OOpportunity.Account.Name, Opportunity.Probability,  totalprice,  FROM OpportunityLineItem.