Power BI (Query) and ASIC Company Number Search

[1793aib]

I'm stuck trying to search Company Numbers (ACNs) from the web.

I've connected my BI to a database of clients, one column is the Company Number (ACN).

I want to take that ACN, pass it to this website 

https://      data.gov.au/dataset/ds-dga-7b8656f9-606d-4337-af29-66b89b2eeefb/details?q=asic

https://      data.gov.au/data/api/1/util/snippet/api_info.html?resource_id=5c3914e6-413e-4a2c-b890-bf8efe3eabf2

And the produce a table of the returned data - row per company.

I've tried to Web.Contents, etc.. but I just cannot get it to work.

These are some sample ACNs:

Company Number

[1793aib]

But if I try and make it read a company name from a column, it says that it doesn't recognise 'Name'

[1793aib]

I could get it to add a column and search if I hard code the name into the Power Query Line

= Table.AddColumn( #"Replaced Value1","ACNCheck", each Web.Contents("https://data.gov.au/data/api/3/action/datastore_search?resource_id=5c3914e6-413e-4a2c-b890-bf8efe3ea..." & "Calathea_Care_Pty_Ltd"))

[KT_Bsmart2gethe]

Hi @1793aib ,

try the link below: 

It works for me.

Regards

KT