Power query - Use a column as url for API call

New Contributor

Hello all,

First of all, thank you for your time in helping people like me who need help.

I have been banging my head on my desk since monday on this issue. I am an author on a website that write novels and I built a dashboard with the Excel Power Query tool.

There is still one thing I can't do though, I am trying to use a text string contained in a column as argument to make an API call.

The function is the following :


When I use it with a direct text string, it works like a charm as you can see in the "Personnalisé" column below:


The only issue is that in each line of my table, i want to use a different argument (= use a different url for my API request).


I tried to use a column as argument, but after several days of hardship, i come here to ask your help. Here is what I get so far…



Thank you all very much for your help.
Have a great day !


2 Replies


You can't combine dynamic parameter directly with URL string. Use RelativePart parameter instead, it's explained for example here https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-i...

 Thank you for your suggestion @Sergei Baklan,
I tried to use the RelativePath parameter in my query, as shown in the blog you provided but I had no luck. The function i used was the below:


However this still returns this error message when i try to give the Column as argument in the RelativePath option :



Could it be related to the fact that the error message indicates that the " character are replaced by %22 in the url ?