I had a SharePoint portal which was on premise and I was able to connect to it using the input data tool and the Download tool to extract excel files successfully. On the other hand, for a client SharePoint Online Office 365 account, I am not able to do the same thing. I keep getting the error "File not found" in the input tool and "403 FORBIDDEN" in the download tool. I tested by making a trial account of SharePoint online myself to confirm access issue due to not being in the client environment, it is not the case. Please help.
What alternative can I have? Can I map the SharePoint Online drive to my local system and then connect it to Alteryx?