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] ))
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]])))