Hi all, I am trying to connect Appian v7.9 to Microsoft Dynamics CRM using the e

olivierd over 9 years ago

Hi all, I am trying to connect Appian v7.9 to Microsoft Dynamics CRM using the existing connector. I followed the documentation example: a Third-party credentials is containing the technical username/password to connect to the CRM (attached) and I try to use the Tempo Report example to create a new account in Dynamics (usePerUserCredentials: false). As username/password field names are case sensitive I tried various combination, same on the endpoint (simple URL,REST and SOAP endpoints). In all case I get the below error: Expression evaluation error : An error occurred while attempting to store into the following variables: [local!dynCreateWriter]. Details: [[local!dynCreateWriter:Failed to connect to the external system [key=dynamicsdev]. The site-wide credentials may be incorrect. Please ask an administrator to update the credentials in the Third-Party Credentials page in the Administration Console. Connection failure details: Connection timed out]] ...

Discussion posts and replies are publicly visible

0 olivierd over 9 years ago

...For some reason Appia can't connect. Could you please advice? Thanks!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Stephane Kamga
Appian Employee
over 9 years ago

Make sure you respect the following guide on the Dynamic Configuration
forum.appian.com/.../Connectors.html
especially the credentials fields.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 olivierd over 9 years ago

Thanks, I am following the guide but still facing connection issue. Any idea of what could be causing those problems?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 rawich over 9 years ago

Can you share the code where you do the bind() with a!dynCreate() function and what you do in saveInto? You can change the hostname in the URL, but show everything else. The error seems to be about connectivity, rather than authentication.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 olivierd over 9 years ago

I tried different endpoints as mentioned. Attached my SAIL code (same as in the documentation). Do you see anything wrong there? Thanks.
SAIL.txt
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 rawich over 9 years ago

What's in your cons!DYNAMICS_ENDPOINT?

Ours is something like this:
hostname/.../web

I remember, we had to add /web at the end, to what we got from the WSDL.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 olivierd over 9 years ago

hostname/.../Organization.svc. I just tried with the "/web" but no change. What do you mean by "url_prefix" in this case?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 rawich over 9 years ago

For url_prefix, there is just another URI context in front of /XRMServices in our environment. I don't think that impact anything.

You should try to execute this service invocation via SoapUI first, to isolate the issue between Dynamics service call vs. Appian connector functions.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel