Power query - Use a column as url for API call

[Silviooooooo]

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 !
Silvio

[#2]

@Silviooooooo 

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...

[#3]

 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 ?