Sharepoint Input tool v1.1.0 - Use as service principal configuration fail to download

Question

app-only authentication

Fail to download file
ID/Token not passed along?tried macro

I followed https://help.alteryx.com/20214/designer/sharepoint-files-input-tool to setup the Sharepoint tool.

It works now as I can Sign in using Browser, which I can download the file (xlsx) that I needed, so nothing about network security is blocking anything.

But due to the token expire time, it is recommended to use Provide Authentication Information for automation (picture 1). I have obtained Client ID, Client Secret, Tenant ID and I am able to connect. It is identical to proceed as before, but I am not able to download the file now (picture 2).

(N.B. If I select Import only list of file paths, it fails as well, so not just the file, but the general metadata request is blocked too)

After searching for answers, the suggestion is about the credential is not passed along after the sign in/connect stage (picture 3). I've tried with macro to feed in the credential values (picture 4), but it still failed.

Any suggestions? Thanks

leozhang2work · Answer

Additional note:

1: I've download v2.0.1, but not yet installed, as I am worried about different configuration will cause issue to windows sign-in which currently works. And it will require Alteryx server to be updated with new tool version as well, so I am holding off to see if there is any solution for v1.1.0 or it can only be solved by upgrade.

2: Checked Sharepoint (Microsoft Azure) app setting online, definitely selected required options as suggested by the link. Also checked all other options, seems to have ticked all the read access as well.