Forum Discussion

papi0506's avatar
papi0506
Frequent Visitor
2 years ago
Solved

Perform function on list of items in m code

Hello,   I'm looking for the basic structure for how to take a single column from a table or list and run a function with each item in the list as parameters or variable in the function. I read a p...
Need Help
Tips and Tricks
  • ImkeF's avatar
    ImkeF
    2 years ago

    Hi papi0506 ,
    sorry, wrote if from the head. Please try the following:

    Json.Document(Web.Contents("https://api/statistics/devices/id/"  & [AccountId] ))
ImkeF's avatar
ImkeF
Community Champion
2 years ago

Hi papi0506 ,
sorry, wrote if from the head. Please try the following:

Json.Document(Web.Contents("https://api/statistics/devices/id/"  & [AccountId] ))
  • papi0506's avatar
    papi0506
    Frequent Visitor
    2 years ago

    Thank you, your suggestion looks to have helped the call progress but the results mention that we cannnot convert a value of record type to number. I had to use text.from to help pass a previous error to the current results.
    still get a tablereturns a record, but wants to convert it to a number?

    • papi0506's avatar
      papi0506
      Frequent Visitor
      2 years ago

      ImkeFThank you, very much. after clearing some cache and results, I was able to get a 404, so the command is working properly I just need to work on the call and why its returning 404, not a power querie issue.

      Thank you so much.

      same call and worked 🙂
      #"Added Custom" = Table.AddColumn(AccountListAsTable, "Results", each Json.Document(Web.Contents("https://api/statistics/devices/id/" & Text.From([IDS] as any),[Headers = [#"Authorization" = Auth2]])))