M Language - Need to query an API with a List of values as parameter

[Mohamed_59]

Hello guys,

I hope you're doing well.

I'm struggling about a code in Power Query.

Basically, what I want is to query an API with a list (named list_id) as a parameter.

Let's consider the following code :

It works pretty good if I put myself an ID or a list of IDs as Parameter :

But if I put directly my list of values (List_ID) as a paramater, it didn't work :

I tried several things but without any success 😕

Can you guys give me some help please ?

Thank you.

[ImkeF · Accepted solution]

Hi @Mohamed_59 ,
yes, that't to be expected.
The function is defined to be only working with text values as input.
What you have to do if you want to run this function on multiple values that currently sit in a list, do the following:
1) Transform the list into a table

2) add a custom column to that table where you call the function and reference the first column of the table as input for the function.

[Mohamed_59]

Thanks for the response ImkeF !