Enter details from Excel to a website and web scraping teh data from it

[balakumar_C]

Dear All,

I am relatively new to web scraping.

I have a task, The data from excel sheet needs to be entered in the website and press enter, so that the website provides few other details which i need it to be downloaded to an excel file

Example:

ID	First Name	Second Name	DOB
123	aaaa	bbbb	01/Jan/2004
234	bbbb	cccc	02/Feb/2005
345	cccc	dddd	06/Feb/2005
456	dddd	eeee	23/Feb/2008

Id, First Name, Second Name and DOB has to be entered in the website data field and the press enter, it would return few other fields (Grouping, Location).that has to be scraped to an Excel file.

The final output has to be :

ID	First Name	Second Name	DOB	Grouping	Location
123	aaaa	bbbb	01/Jan/2004	X234	NSW
234	bbbb	cccc	02/Feb/2005	Y502	VIC
345	cccc	dddd	06/Feb/2005	Z304	NSW
456	dddd	eeee	23/Feb/2008	X234	NSW

Not able to post the website link due to privacy reasons.

Thanks,

Bala

[gawa]

@balakumar_C 

It depends on that website provides API(so called REST API) or not.

If yes, you can go with Download tool and call API as per API documentation of that website.

If no, it seems difficult to interact with website with dynamic input data.

[balakumar_C]

Thanks Gawa.

I am not sure about the API of the website.

Currently, It's been processed through Power Automate which takes a lot of time and hence we want to check if any possibility with Alteryx.

Sure., I will try exploring the download tool.

Thanks,

Bala