Open Excel URL and screenshot

Anasitani

Hi everyone,

I was wondering if it is possible to open a URL from an Excel file and then take a screenshot of the web page and upload it on a word document?

I saw something that included an "R" tag but i unfortunately don't have that.

Kind regards

Anas

BrandonB

Do you need an actual image? If you pass the URL to a download tool you are able to extract the HTML of the webpage as it is which may accomplish what you need. If you truly need an image there are a couple of approaches discussed here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Display-static-webpage/td-p/75921 

Generally speaking, Alteryx can interact with APIs via the download tool, but to truly interact with a webpage beyond just pulling HTML you would want to use a Python tool to run something like Selenium. If you want to learn more about a Python approach within a workflow you can read more here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Python-Code-Tool-Web-Scraping-Dynamic-Websites-Using-Selenium/td-p/300335 

You would be using a script like this: https://handyman.dulare.com/using-python-and-selenium-to-save-page-screenshots-to-word-document/