Do you use Alteryx in a language other than English? If so, we want to hear from you! Please help us improve the international experience of our products by participating in this 5 minute survey.

We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Connect Alteryx Designer to Excel in SharePoint in Office 365

balajilolla1
5 - Atom

I am trying to connect to an excel file in sharepoint in office 365. However, when I enter the address in Sharepoint connector in Alteryx Designer, I am getting an error "Root not found". How can I connect to an excel file on Sharepoint?

24 REPLIES 24
CharudattaChousalkar
6 - Meteoroid

Hi, Here is the workflow that I use for downloading excel files from sharepoint.

With few modifications, we can use it for uploading files as well.

I have removed some sensitive content from text input, fill those as per your API details.

At the end, dynamic input will ask for template file, provide one for the file, you want to download.

We can download multiple files as well with this workflow, need some modifications or save this workflow as macro and use it.

 

 

Beata598
5 - Atom

Hi,

 

Thank you for sharing this. I am 90% there with making it work but I keep on getting an error message just before the XML parse tool within the "Get list of files from Folder" container:

 

{"error_description":"Exception of type 'Microsoft.IdentityModel.Tokens.AudienceUriValidationFailedException' was thrown."}

 

Any idea what that means?

 

Thanks,

Beata

CharudattaChousalkar
6 - Meteoroid

Hi,

You might be using resource or scope in wrong way. Always check on Postman if you are getting 200 OK message. Postman might be helpful debugging your issue. I can't help unless I see what parameters you are passing to API download tool. Share your workflow removing sensitive information.

Beata598
5 - Atom

I checked in postman and I am getting an error message. It does not like the grant_type: client_credentials line. Is there something else I should use instead?

Beata598_0-1627034323948.png

 

CharudattaChousalkar
6 - Meteoroid

Well, the error is saying that the request must contain grant_type so i think the request is not taking what you entered. Make sure your header is all good and containg 

content-type:application/x-www-form-urlencoded or content-type:application/jason;odata=verbose
Accept:application/jason;odata=verbose

 

Labels