Forum Discussion

lily99's avatar
lily99
Regular Visitor
5 years ago
Solved

API call a list in M query

Hello, I want to build a Body of a REST API call using M Query in PowerBI.  I have a list of ID from a list named "UserID" that I want to use it as a variable in the body   Here is my script bod...
Need Help
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago

    lily99 , you might want to try

    body = "{""ids"":[" & Text.Combine(List.Transform(List.Distinct(UserID), each """" & _ & """"),",") & "]}"

ImkeF's avatar
ImkeF
Community Champion
5 years ago

Hi lily99 ,

if you want to pass a string into the body, you'd have to transform the list into a string as well. Meaning, concatenate the values by comma for example:

 

body = "{""ids"":" & Text.Combine(List.Distinct(UserID), ",") & "}",