I have been working for days on getting the CRM Input/Output tools to work. I am finally able to connect but when I run a simple workflow that pulls data from one table and displays it in a Browse tool I'm getting the error below. I have tried running this in Designer on my own computer and posting it the the Server and running it there.
Traceback (most recent call last): File "C:\ProgramData\Alteryx\Tools\dynamics_crm_input_v1.0.2\dynamics_crm_input\engine.py", line 161, in pi_push_all_records for result in query: File "C:\ProgramData\Alteryx\Tools\dynamics_crm_input_v1.0.2\odata\query.py", line 70, in __iter__ data = self.connection.execute_get(url, options) File "C:\ProgramData\Alteryx\Tools\dynamics_crm_input_v1.0.2\odata\connection.py", line 107, in execute_get response = self._do_get(url, params=params, headers=headers) File "C:\ProgramData\Alteryx\Tools\dynamics_crm_input_v1.0.2\odata\connection.py", line 18, in inner return fn(*args, **kwargs) File "C:\ProgramData\Alteryx\Tools\dynamics_crm_input_v1.0.2\odata\connection.py", line 50, in _do_get return self.session.get(*args, **kwargs) File "C:\ProgramData\Alteryx\Tools\dynamics_crm_input_v1.0.2\Lib\site-packages\requests\sessions.py", line 555, in get return self.request('GET', url, **kwargs) File "C:\ProgramData\Alteryx\Tools\dynamics_crm_input_v1.0.2\Lib\site-packages\requests_oauthlib\oauth2_session.py", line 319, in request raise InsecureTransportError() oauthlib.oauth2.rfc6749.errors.InsecureTransportError: (insecure_transport) OAuth 2 MUST utilize https. (Tool Id: 1)
Hello @krempp
Looking at the error message you included "in request raise InsecureTransportError() oauthlib.oauth2.rfc6749.errors.InsecureTransportError: (insecure_transport) OAuth 2 MUST utilize https."
It looks like there was an issue with receiving the data.
I would recommend checking out the help document for the CRM Input tool to make sure your setting are correct.
https://help.alteryx.com/current/designer/dynamics-crm-input-tool
If you are still encountering issues, please include a screenshot of your tools setup so that the Community can investigate further!
Thanks,
TrevorS