Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here

Question on download tool

Highlighted
8 - Asteroid

Hi All, 

 

Requesting help on how to download or extract the HTML data from a SharePoint page.

I tried using a download tool getting a message which says: Unauthorized access

I have access to the page, I can load the page on the browser.

Highlighted
12 - Quasar
12 - Quasar

It sounds like you are missing some header information. If you hit F12 and refresh the SharePoint page, you might be able to see the actual call being made so you can replicate in Alteryx (or Postman, for that matter). I've found Postman a good testing tool for making API calls, then you can translate to Alteryx after you have a successful call. 

Highlighted
8 - Asteroid

Thank you @jarrod  for the reply but I am not sure where I am going wrong. 

In the postman tool how can i identify the call. I need to ask the IT team to install the software for me. 

But if u have any example of how to identify the call and how to use them that would be great. 

Thanks in advance.

Please see screen shots below:

where field 1 is the sharepoint URL

 

Manjari_T_0-1594792833118.png

 

Manjari_T_1-1594792950152.png

 

 

Highlighted
12 - Quasar
12 - Quasar

I see. it looks like you are trying to scrape the data vs using the SharePoint API. I would suggest using the API instead because it will give you better results. The API documentation is here:

https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/complete-basic-operations-using-sharepoin...

 

you'll likely need to apply or find your api token/credentials and build a authorization token which is passed through the header. 

 

What are you trying to pull from sharepoint? 

 

 

 

Edit: one thing i noticed early but forgot to comment on is that you are using the endpoint (field1) as both the URL and a header. that will likely never be the case. for the headers, every checkbox you select will be passed through as a name/value pair. So in this instance, your header would be field1:www.sharepointurl.com/xxxxxxxx.

 

Once you get your sharepoint credentials, you can pass through the "Authorization" header as:

authorization:Bearer 892nf92ncf92f82hjf282f89

 

which, in alteryx will be a field called "authorization" and the value would be "Bearer 892nf92ncf92f82hjf282f89". you would then select that field in the "header" section. 

Highlighted
8 - Asteroid

Hi @jarrod apologies for the late reply. 

 

I am extracting a bitly link from the SharePoint page. 

Is there a way to develop bitly links for many SharePoint link using Alteryx?

 

Also I went through the link, I do not know C# and i am not sure how to use them.

Highlighted
12 - Quasar
12 - Quasar

I'm not sure what you are looking for with regards to bitly links in sharepoint. are you trying to create bitly links? 

 

as for the sharepoint api link i provided, it's just a guide to the API using C# and Javascript. you can do the same thing with the download tool/Postman. Look for keywords like "URL", "Parameter", "Header" and "Body".

URL - fed through the text input tool as a field used in the download tool 

jarrod_0-1595257449415.png

Parameter - with GET requests, can be passed through using the Headers, POST calls it should be passed through using the "Payload" tab.

Header - select the Header fields in the header tab

Body - Used on POST Requests - pass through in Payload tab.

jarrod_1-1595259590636.png

 

 

Labels