Hi all
I've trying to download data from a url which isn't available from the API but am struggling - once the URL below opens, I need to select an option on the page to export the data as csv - can I automate this activity somehow by passing additional commands (i've included a screenshot of the code from the page where the download happens)
Hi @BecclesBen
To access the page to begin the download you must login before, click on some buttons, right?
If this is the case, i solved some problems like this one (mimic final user and access page, log in, click on some buttons and export data) using the python component with the Selenium or BeautifulSoap library. They are built specifically for webscrapping.
I am afraid that based on what i understood (you have to login, click on some buttons, etc) Alteryx will not be able to handle this task without some codding. Another way to do this more easily is using RPA`s like UiPath or Automation Anywhere, if your company have these softwares.
If you want to take the Selenium path for solving this, i can provide you one example with Alteryx + Python component until tomorrow.
If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)
Thanks.
Hi - thanks for replying - yeah, I have to log in first.
I was just looking at a web scraping tool (parsehub) so maybe that's the answer..
Thanks for your guidance!
Ok, this tool is designed for this job, so it will be a better option for sure.
Good luck with that!