Possibility of Interacting with a Website

Question

I am supposed to automate a variety of daily tasks. I am concerned that it is not possible with the capabilities of Alteryx Designer and was wondering if that was true or if there is a way to accomplish it.

The tasks (from an excel file):

- Upload the data from a cell containing a number to an input box on a website and click enter key

- Upload a corresponding number from the same row in the excel file to a different input box on the website and click enter

- Use a dropdown menu to select an option

- Add a digit in another input box

- Click an enter icon

- Much more to it than this but this is the most basic section of the automation

I wish I could be more specific about the automation but I have to be vague due to compliance, I honestly just want to know if this is doable. I assumed I would be able to accomplish this with APIs but I haven't been successful. I cannot use python, selenium, or any vbs in conjunction with my workflow.

Any ideas?

abacon · Accepted Answer

@alexanderdwaller This sounds to be more of a RPA tool's wheelhouse and not Alteryx's, especially if you can't use python or other languages in unison.

Bacon

Gaurav_Dhama_ · Accepted Answer

So this is possible using python, you can definitely do that in alteryx, but! It won’t be perfect and would require a lot of coding.

Plus, it will only run on your designer, so you will need a VM to host this designer if you want to let others run it, because based on the windows settings the position of buttons may change.

I would suggest go with power automate desktop instead, or automation anywhere.

If you can get API access of the website, then it can be an interesting build and will definitely fall under Alteryx umbrella.

Hope this helps.