Dataverse Input Tool and Microsoft Dynamics

Hello,

I'm trying to use the dataverse input component to connect to Microsoft Dynamics.

For my first test, I have used Service Principal method (cf. image "First test.jpg). With this method, I managed to retrieve metadata (tables and columns). But when I launched the workflow, impossible to retrieve the data. In the Designer results, I had these informations :

Dataverse Input tool initialized.

DCM.E : No connection ID is available.

Plugin class successfully loaded

And then the workflow was blocked. I had to stop it manually.

For my second test, I have tried to use DCM with Authentication Method "Microsoft Dataverse Service".

With this method, it was also OK to retrieve metadata. This time, the workflow finished with the following error : "Connection to platform was not successful".

If someone has an idea why I can retrieve metadata but not data, it would be really great.

Thanks.

First test.jpg

Settings

Accepted answers

PatPli

Hello,

Just to close this case, I have never managed to use Dataverse Input Tool without errors.

Finally, I have checked how to use cURL to retrieve Dynamics Data with API and with Download tool everything is OK.

All comments

thomas598brown

@PatPli wrote:
Hello,
I'm trying to use the dataverse input component to connect to Microsoft Dynamics.
For my first test, I have used Service Principal method (cf. image "First test.jpg). With this method, I managed to retrieve metadata (tables and columns). But when I launched the workflow, impossible to retrieve the data. In the Designer results, I had these informations :
Dataverse Input tool initialized.
DCM.E : No connection ID is available.
Plugin class successfully loaded
And then the workflow was blocked. I had to stop it manually.
For my second test, I have tried to use DCM with Authentication Method "Microsoft Dataverse Service".
With this method, it was also OK to retrieve metadata. This time, the workflow finished with the following error : "Connection to platform was not successful".
If someone has an idea why I can retrieve metadata but not data, it would be really great.
Thanks.

Hello,

It sounds like you're encountering connection issues with the Dataverse Input component. Here are a few suggestions:

Check Connection ID: Ensure that the connection ID is properly configured and accessible.
Verify Permissions: Make sure the Service Principal has the necessary permissions to access the data.
Retry Workflow: Sometimes, transient issues can cause failures. Try rerunning the workflow.
Review Logs: Check the Designer results and logs for more detailed error messages.

If the problem persists, consider reaching out to Microsoft support for further assistance.

Hope this helps!

Best regards,
Thomas Brown

PatPli

Thank you Thomas.

I will see with Dynamics administrator for point 2 and for Microsoft assistance.

Ivan_F

Hello,

According to most common issues, this could be due to a few reasons.

First, if you’re using the Service Principal method, check if it has permission to access the data. It needs read access. Without this, you can only see metadata but not the actual data.

In your second test with Microsoft Dataverse Service authentication, the error Connection to platform was not successful may mean there's a problem with your login details. Make sure your tenant ID, client ID, and secret are all correct. Also, check that your Azure Active Directory app has the right permissions. Missing or wrong info can stop you from getting the data, even if you can see the metadata.

Another thing to consider is API rate limits. If you’re sending too many requests, the system might be throttling you and blocking data retrieval. Look for any rate-limit alerts in your logs.

Lastly, think about network connectivity. If you’re on a blocked network or behind a firewall, it could stop the data from coming through. Make sure your connection to Dataverse is solid.

PatPli

Hello @Ivan_F ,

Thank you very much for all these detailed information. I will check all these points with Dynamics administrators.

PatPli

Hello,

Just to close this case, I have never managed to use Dataverse Input Tool without errors.

Finally, I have checked how to use cURL to retrieve Dynamics Data with API and with Download tool everything is OK.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703