Forum Discussion
Power BI (Query) and ASIC Company Number Search
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
3 Replies
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-bf8efe3eabf2&q=" & "Calathea_Care_Pty_Ltd"))
But if I try and make it read a company name from a column, it says that it doesn't recognise 'Name'
