Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Integration: Querying Salesforce Native Fields Fails

in Configure Price Quote 4 comments

Summary:

We are trying to query the Salesforce Opportunity Field Territory2, which is a lookup field to the Territory object. However, it’s failing with this error when I do the Preview Query Result:

  • INVALID_FIELD: No such relation 'Territory2' on entity 'Opportunity'. 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.

It’s not a custom field so the __c that is suggested also errors.

If I try to append __r to reference the relationship I get this error:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!