Exception 'Bad Request - Error in query syntax' when calling OData Service

Description

When you call a Sequence OData service, it does not respond, and the exception Bad Request - Error in query syntax displays in Event Viewer and Fiddler. HTTP Error code 400.

Cause

The OData Service URL that contains the Lookup Query is incorrect..

Affected Versions

7.7 and later.

Solution

Check the following information in the OData service call.

  • Service URL parameter names and values.
  • Service URL value type (add explicit cast, if necessary).