Webscraping using Alteryx

Question

I have a public domain website "List of Registered FPIs / Deemed FPIs (Erstwhile FIIs and Sub Accounts)" where user goes and then select Country (e.g.: Australia) from the drop down and clicks "Go" button. It lists all Registered FPI for that country (in our case Australia). Please note that Country selection will vary from one user to another.

I want to scrap Name and address of all records for selected country into an excel format.

Is this web scraping with selection of country by user possible in Alteryx Designer?

AkimasaKajitani · Answer

You can do this task with Download tool. It seems to be a very simple website; by changing the CountryId in the following URL, you can download data for your preferred country in JSON format.

https://www.fpi.nsdl.co.in/Reports/RegisteredFIISAFPI.aspx?action=getregdata&type=0&Search=&RegNo=&CategoryId=&SubCategoryId=&CountryId=31&StatusId=

Here is the result.

OTrieger · Answer

@Tej_Singh

Potentially it should be possible.

You can create an Analytical App, and with a drop box you can create a selection of countries that the user can select.

You can use the Download Tool to web scraping the data and then transform it to the desired layout.