Skip to main content
Topics#IntegrationQuestion de Mohsin Patel
Mohsin Patel (Intuit) a posé une question dans #Integration
9 oct. 2020, 17:42

Getting a soql error on OpportunityLineItems - Please Help!

This is happening to a couple of customers and not for everyone we tried to reproduce this issue on a dozen test account with no luck.

Note: all the objects and fields in this soql are standard salesforce objects and fields.

hosturl=https://na139.salesforce.com/services/data/v46.0/query/?q=SELECT+Id,Name,Amount,CloseDate,Description,Type,StageName,accountid,account.name,account.website,account.phone,account.BillingStreet,account.BillingCity,account.BillingState,account.BillingPostalCode,account.BillingCountry,account.ShippingStreet,account.ShippingCity,account.ShippingState,account.ShippingPostalCode,account.ShippingCountry,OwnerId,owner.name,(SELECT+IsPrimary,Role,ContactId,contact.name,contact.email,contact.fax,contact.MobilePhone+FROM+OpportunityContactRoles),(SELECT+Product2.Name,Product2.Description,Description,ListPrice,ProductCode,Quantity,TotalPrice,UnitPrice+FROM+OpportunityLineItems)from+opportunity+where+StageName+=+'Closed+Won'+AND+CloseDate+%3E%3D2020-09-22, hostRequest=null, hostResponse=[{"message":"\nQuantity,TotalPrice,UnitPrice FROM OpportunityLineItems)from opportunity\n ^\nERROR at Row:1:Column:595\nDidn't understand relationship 'OpportunityLineItems' in FROM part of query call. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names.","errorCode":"INVALID_TYPE"}]}
2 réponses
  1. Shirisha Pathuri (salesforce.com)
    9 oct. 2020, 18:20
    Hi Mohsin,

    Greetings!

    I just wanted to know,if this was working fine or new implementation.If this is new implementation then I would suggest you to try by removing the below part from the query:

     

    hostRequest=null, hostResponse=[{"message":"\nQuantity,TotalPrice,UnitPrice FROM OpportunityLineItems)from opportunity\n

    Kindly mark it as best answer if it helps so that it can help others in the future.

    Warm Regards,

    Shirisha Pathuri

     
Rédiger une réponse...
0/9000