Hi Martin,

Yes Power Query can do this. Create a new Custom Column and for each row call your API.

So if you have a column called Postcode, in your Custom Column code would look something like 

=Web.Contents("https://www.api.com/?postcode=" & [Postcode])

That's a very simple example and your case may be more complicated.  It depends on how you have to connect to the API, what authentication you need etc.

Another way to do this is to create a function and call the function for each row.

If you can post some more info about the API and how you have to connect to it, I can provide more help.

Further info

Getting Started with API's in Power Query • My Online Training Hub

Web.Contents - PowerQuery M | Microsoft Learn

Regards

Phil

Hi Phil!

Many thanks for the quick reply - This is really helpful.

I'll check this out and may come back to you.

Cheers,

Martin

No worries.

Phil