Salesforce Connect – OData 4.01

When using Salesforce Connect with an OData 4.01 adapter, the Validate & Sync operation may fail if the external OData service does not support a trailing slash at the end of the service root URL.

Per the OData 4.01 specification, the service root URL must terminate in a forward slash, and Salesforce sends the request accordingly.

If the external OData service is not configured to handle requests with a trailing slash, it will return a 404 error causing the sync to fail.

The external OData service must be updated to accept and respond to the service root URL with a trailing slash as required by the OData 4.01 protocol.

Reference Article(Service Root URL section): https://docs.oasis-open.org/odata/odata/v4.01/odata-v4.01-part2-url-conventions.html#_Toc31360927