SharePoint Files Input tool error - Python Packages

Question

Hi!!

I was wondering if I could get a little help as my python "skills" leave a lot to be desired.

When using the "SharePoint Files Input" tool I am receiving the below error on the tool.

Error: SharePoint Files Input (4): Traceback (most recent call last):
File "C:\Users\username\AppData\Roaming\Alteryx\Tools\SharePointFiles_v2.3_venv\Lib\site-packages\ayx_python_sdk\providers\e1_provider\e1_plugin_proxy.py", line 123, in pi_init
self.update_sys_path()
File "C:\Users\username\AppData\Roaming\Alteryx\Tools\SharePointFiles_v2.3_venv\Lib\site-packages\ayx_python_sdk\providers\e1_provider\e1_plugin_proxy.py", line 272, in update_sys_path
install_metadata = self.tool_config_loader.get_tool_install_metadata()
File "C:\Users\username\AppData\Roaming\Alteryx\Tools\SharePointFiles_v2.3_venv\Lib\site-packages\ayx_python_sdk\providers\e1_provider	ool_config_loader.py", line 71, in get_tool_install_metadata
tool_path, install_type = self._get_tool_path()
File "C:\Users\username\AppData\Roaming\Alteryx\Tools\SharePointFiles_v2.3_venv\Lib\site-packages\ayx_python_sdk\providers\e1_provider	ool_config_loader.py", line 81, in _get_tool_path
tools_path, install_type = self._get_tools_location()
File "C:\Users\username\AppData\Roaming\Alteryx\Tools\SharePointFiles_v2.3_venv\Lib\site-packages\ayx_python_sdk\providers\e1_provider	ool_config_loader.py", line 110, in _get_tools_location
raise RuntimeError("Tool is not located in Alteryx install locations.")
RuntimeError: Tool is not located in Alteryx install locations.

The tool does connect using the "Provide Client ID and Secret, and Tenant ID" , however once connected on the "Site" dropdown, it just shows "Loading..." and the circle spins endlessly.

Any help on this issue would be greatly appreciated.

leofrancia · Answer

Have a look at this article: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/How-to-set-up-SharePoint-Sites-Selected/ta-p/1005385

It says using Service Principal requires Sites.All permission. I have not used Service Principal before so we may need input from the community for this.

AORay · Answer

Due to security we have to sign in using the "App Sign In (Use Service principal)" 
Yes I am using Designer Desktop V2022.3.1.450 (not Server)
On SharePoint I have site Owner role, so I should have the permissions needed to read a file.

leofrancia · Answer

Can you confirm if you are using Designer Desktop (not Server) and that you are using Browser Sign-in as below? If yes, it may be due to you not having sufficient authorizations.