We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Download Data from URL

messi007
15 - Aurora
15 - Aurora
‎10-08-2020 02:37 AM

Dear Alteryx Comunity,

 

I want to download the table from the URL below:

 

https://www.boursier.com/indices/composition/cac-40-FR0003500008,FR.html?tri=dcapi

 

However in the data column from the dynamique read I get the message below: 

 

 

</style>
</head>
<body>
<div id="header"><h1>Server Error</h1></div>
<div id="content">
 <div class="content-container"><fieldset>
  <h2>403 - Forbidden: Access is denied.</h2>
  <h3>You do not have permission to view this directory or page using the credentials that you supplied.</h3>
 </fieldset></div>
</div>
</body>
</html>

 

Is it abouT access to the web site or I need to do some manipulations in Alteryx.

 

Attached my simple workflow.

 

Many thanks in advance for help!

 

Regards,

 

 

 

 

 

 

 

ReadDataFromURL.yxmd
Labels:
Reply

Accepted SolutionSolved! Go to Solution.

8 REPLIES 8
atcodedog05
22 - Nova
22 - Nova
‎10-08-2020 02:42 AM

Hi @messi007 

 

This is from the website. They might be having scraper blocker. Which stops from fetching webpage through tool.

Reply
0 Likes
TheOC
16 - Nebula
16 - Nebula
‎10-08-2020 04:02 AM

Hi @messi007 

I managed to get this working by adding a user-agent to the header of the request, requiring this is usually the most basic step sites take against scrapers.

I have attached a workflow of this working, with a 200 response in the DownloadHeader, and the content of the site within the DownloadData.


 

 

Have a great day!

Cheers,
TheOC
Connect with me:
LinkedIn Bulien
messi007.yxmd
Reply
atcodedog05
22 - Nova
22 - Nova
‎10-08-2020 04:05 AM

@TheOC  Sweet 😎

Reply
mceleavey
17 - Castor
17 - Castor
‎10-08-2020 05:21 AM

Nicely done @TheOC 



Bulien
Reply
messi007
15 - Aurora
15 - Aurora
‎10-12-2020 03:02 AM

Dear @TheOC ,

 

Well done.

You have been really helpful.

 

 

Many thanks,

Reply
TheOC
16 - Nebula
16 - Nebula
‎10-12-2020 05:19 AM

Hey @messi007 

So glad i could be of assistance, have a great week!

Cheers,
TheOC
Connect with me:
LinkedIn Bulien
Reply
Oussaio
7 - Meteor
‎03-26-2023 07:14 AM

Worked amazingly ! Thanks very much :) !

Reply
TheOC
16 - Nebula
16 - Nebula
‎03-27-2023 04:37 AM

Happy to help @Oussaio !

Cheers,
TheOC
Connect with me:
LinkedIn Bulien
Reply
Live Office Hours
Labels
Top Solution Authors
View All