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