Web scraping - GST registration details

[rparwal]

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.

ABN

68615432838

45147003449

91174241413

87904367991

[Raj]

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

[rparwal]

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?

[rparwal]

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