Internal working of CRM connector. | Community
Skip to main content
Level 2
August 1, 2019
Solved

Internal working of CRM connector.

  • August 1, 2019
  • 5 replies
  • 3525 views

Hi all,

I am looking for 2 things:

1. Does anyone happen to know the internal working of CRM connector. What I am particularly interested in knowing is how the querying is done from the server            database and is there any involvement of "ServiceURL" in this process.

2. Does anyone know where can i find the "ServiceURL" being used in CRM connector ?

The reason behind these questions is we have been facing a crmConnector timeout error. And the client is asking for the "ServiceURL" for investigating on their part.

Any help on finding the "ServiceURL".

Kindly refer the screenshot below for the error.

Regards,

Jayesh

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jonathon_wodnicki

Hi,

MS Dynamics connector uses a variety of URL's, which can be found in crm:mscrmConnector.js, and partially in your config above. If you're debugging the calls, the easy approach is to put a mitm proxy between the wfserver and the internet and capture what's triggering the 500 response. More difficult would be to wrap the ootb request functions with logging calls and then swap them into the crm code.

Thanks,

-Jon

5 replies

Jonathon_wodnicki
Community Advisor
Community Advisor
August 1, 2019

Hi.

The URL varies on the CRM you're connecting to. That error says 'SQL timeout', with the HTTP call being a 500 error, so this doesn't sound like a connectivity issue. Which CRM is this?

Thanks,

-Jon

Level 2
August 2, 2019

Hi Jon,

PFB screenshot of the External account configuration used for CRM connector. We are using Microsoft Dynamics CRM. Can you tell me where/ how can I find the "ServiceURL"?

Regards,

Jayesh

Jonathon_wodnicki
Community Advisor
Jonathon_wodnickiCommunity AdvisorAccepted solution
Community Advisor
August 5, 2019

Hi,

MS Dynamics connector uses a variety of URL's, which can be found in crm:mscrmConnector.js, and partially in your config above. If you're debugging the calls, the easy approach is to put a mitm proxy between the wfserver and the internet and capture what's triggering the 500 response. More difficult would be to wrap the ootb request functions with logging calls and then swap them into the crm code.

Thanks,

-Jon

Level 2
August 7, 2019

Hi,

Could you give more information on the second way ("More difficult would be to wrap the ootb request functions with logging calls and then swap them into the crm code.")? What steps need to be followed to do this?

Regards,

Jayesh

Jonathon_wodnicki
Community Advisor
Community Advisor
August 7, 2019

HI,

As I said, it's the hard way:

  1. Create a custom addMethod function with the same interface as HttpSoapConnection's addMethod
  2. Have new addMethod call HttpSoapConnection's addMethod, then replace the function it creates with code that calls the replaced function while logging its inputs and outputs
  3. Change crm connector code to use instrumenting addMethod instead of old one

Thanks,

-Jon