Issue

The Dynamics 365 CRM connector is succeeding in the authorization step. However, the schema page displays that an error has occurred

Environment

Connector: Microsoft Dynamics 365

Answer

To get this working, make sure you have entered the custom domain name (also known as tenant name or organization name) correctly in the Fivetran set-up form, paying attention to the formatting. That can be accessed based on the steps in Fivetran's Documentation.

Cause

This error is caused by a failed call to the Dynamics 365 API. If you open the browser's developer tools, you will see a more robust error:

ERROR fetching configuration: HTTP error 400 while standard config for <integration name> com.fivetran.setup_test_runner.client.exceptions.CustomServiceException: Unable to get standard config for integration <integration name>: Not able to get response from invoking request even after retrial

This is returned due to a failure in the API call to get the schema information which is made to the `/EntityDefinitions` endpoint.