Web scraping - GST registration details

Question

Hi All.

I want to know the GST registration (ABN) status of multiple entities in one go. The ABR website is free site to check the status. can anyone please suggest me how can i build by Alteryx workflow?

site: https://abr.business.gov.au/  ; https://abr.business.gov.au/json/

Sample ABN data that will go into Alteryx and need details for these ABNs to come into Alteryx.

ABN68615432838451470034499117424141387904367991

rparwal · Answer

@raj

Is there any way we can either run this excel macro through Alteryx? We can join the data source column in ABN/ACN column and then just run the Macro and we will get the information directly.

Thanks in advance.

ABNLookup.zip

rparwal · Answer

Hi Raj

thank you for sharing it but i tried the same approach and i am not getting data in a structured format. I just need 'Entity Name',' ABN Status' and 'Goods & Services Tax (GST)' details. Its splitting this data into thousands of line item. Is there any way we could do get the specific fields?

Raj · Answer

@rparwal 
you will need to create a macro which will read and unzip the data and transform it accourding to your requiremet
i have added a sample how you will be pulling the data from website

mark done if solved,.

550.yxmd