We use SharePoint 365 and can access files on the site by using this account. It requires the Alteryx workflow to make a call to the authorization service to get an access token, then passing that token along to another with the request to SharePoint. I can provide more info if it is something that may work for you.