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

Question

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:

IDFirst NameSecond NameDOB 123aaaabbbb01/Jan/2004 234bbbbcccc02/Feb/2005 345ccccdddd06/Feb/2005 456ddddeeee23/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 :

IDFirst NameSecond NameDOBGroupingLocation123aaaabbbb01/Jan/2004X234NSW234bbbbcccc02/Feb/2005Y502VIC345ccccdddd06/Feb/2005Z304NSW456ddddeeee23/Feb/2008X234NSW

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

Thanks,

Bala

balakumar_C · Answer

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

Gawa · Answer

@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.