Forum Discussion

soundwave123's avatar
soundwave123
Frequent Visitor
8 years ago
Solved

Get data Web API Variable URL

Hello,   I have been stuck on this for days and googled endless times with no luck on getting this to work. I'm trying to get data but cannot figure out how to pass a users column to another get da...
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    Hi soundwave123,

     

    Another way you can try is that you can create a calculated column contains those kind of URL. Please open Query Editor, create a custom column [Custom]: 

     

    ="http://********:8080/api/users/" & Text.From([UserID]) & "/queued/"  

     

    Then pass new column in Web.Contents() function to get data: 

    =Web.Contents([Custom]) 

     

     

    Best Regards,
    Qiuyun Yu

soundwave123's avatar
soundwave123
Frequent Visitor
8 years ago

So, I understand this part but the issue is I have to change the parameter to have the URL pulled for each user manually. I was looking to have a list and PowerBI be able to use the whole list to form multiple URLs based on the list then return all users queue from the list without user involvement so that the data can be gathered all at once.

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

Hi soundwave123,

 

Another way you can try is that you can create a calculated column contains those kind of URL. Please open Query Editor, create a custom column [Custom]: 

 

="http://********:8080/api/users/" & Text.From([UserID]) & "/queued/"  

 

Then pass new column in Web.Contents() function to get data: 

=Web.Contents([Custom]) 

 

 

Best Regards,
Qiuyun Yu