But if I try and make it read a company name from a column, it says that it doesn't recognise 'Name'
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"))