Help a newbie with downloading from a website
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi folks,
Im trying to create a small Proof of Concept for my department - at the moment the team download data from a number of websites to use with an internal system and I want to automate this step by having Alteryx download the data into a CSV/XLS file for them.
Im completely new to this, not being a developer! One of the websites is this: https://www.fsma.be/en/overview-ongoing-takeover-bids
I have tried using text input with the URL, going into download, then parsing the DownloadData column but this just brings down loads of other URL's and not the actual data, Im lost!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @craigja
The data is in your DownloadData. You just have to look waaaaay down the page, after the links and javascript.
Dan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
But I cant find the actual data - for example if I search for this code: GB00BYN5BY03 which is shown on the page I cant find it in the data (unless Im missing something)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I think you're missing something
Dan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Indeed, looks like I am missing something! Thanks, will go back and have a look, seems I might have what I need afterall
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Now I just need to figure out how to pull out just the table with data...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
Did you figure out how to pull out just the table with data?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
To be honest I never ended up going any further - I suppose the next step would have been to work out a regular expression to extract the data