Skip to main content
Before you configure the Microsoft Dataverse Connector, make sure you have the following credentials and connectivity:
  • Follow the steps in Get started.
  • Microsoft Dataverse access: An active Dataverse environment with required API permissions.
  • Network connectivity: Verify that your network routes traffic between the Dataverse environment and Grand Central iPaaS. For supported options, see Network connectivity.

Configuration guide

Follow these steps to initialize and authorize your Microsoft Dataverse Connector.

1. Establish connectivity

Share connectivity details between Grand Central and Microsoft Dataverse as described in Network connectivity.

2. Microsoft Dataverse authentication

The Microsoft Dataverse Connector uses OAuth 2.0 authentication for API access. To configure authentication, create a Secrets Operations (SOPS) secret. For more information, see How to create SOPS.
To share credentials between Microsoft Dataverse and Grand Central, consider using 1Password.

3. Environment configuration

To initialize the Microsoft Dataverse Connector, define the required environment variables in your gc-applications-live repository. These variables are stored in values.yaml for configuration common to all connectors, and in the following files for connector-specific configuration: For the full property list for each connector, including defaults and descriptions, see Reference.

Define common parameters

These variables are stored in values.yaml and are used across all Dataverse connectors: The following example shows the values.yaml configuration:
Place the values files at the following paths:

Define party outbound connector parameters

The following variables apply to outbound requests from Grand Central to Dataverse (party-v0.values.yaml): The following example shows the party v0 configuration:

Define party inbound connector parameters

Configure how Grand Central receives asynchronous updates from Dataverse for create, update, and delete events (party-inbound-v0.values.yaml): The following example shows the party inbound configuration:
Register your Grand Central inbound endpoint as a webhook in Dataverse, and filter the events to only the tables and columns you need.

Testing the connector

To access the Unified API, include your Grand Central subscription key in the request header. If you don’t have a key, contact the Grand Central team to request one. Test the API using the Postman collection.
Webhook registration: To process asynchronous updates, register your environment callback URL in your Dataverse webhook configuration.

Troubleshooting

If your connector isn’t responding as expected, check these common scenarios.
Cause: The Grand Central gateway cannot establish a handshake with the Microsoft Dataverse endpoint. This typically indicates an upstream service outage at Microsoft or a network routing failure.Solution: Verify the operational status of the Dataverse environment. Check the Microsoft status page or contact Microsoft support. If the service is operational, contact Grand Central Support.
Cause: The request to Microsoft Dataverse exceeded the configured timeout period. This may indicate performance issues at Microsoft or network latency problems.Solution: Verify the operational status of the Dataverse environment and check for any performance degradation. If the service is operational and performing normally, contact Grand Central Support.
Cause: The OAuth app credentials provided during setup are incorrect, expired, or you lack the required permissions in Dataverse.Solution: Re-verify your Dataverse app registration credentials with your Microsoft administrator, and ensure you have the required permissions. Contact the Grand Central team to update the connection credentials if needed.
Cause: The party ID (Dataverse contact ID) provided in the request is invalid or does not exist in Dataverse.Solution: Verify that the party ID is a valid Dataverse contact ID. Check that the contact exists in your Dataverse environment, and that the ID format is correct.
Cause: The number of incoming requests exceeds the defined threshold for your subscription tier. This “429 Too Many Requests” response protects the stability of the Grand Central and Microsoft Dataverse infrastructure.Solution: Review your app’s request patterns to identify unexpected spikes. If you need higher throughput, contact the Grand Central team to request a higher rate limit.

Need more help?

Contact support

Contact the Grand Central team for help with environment setup or rate limit increases.