Forum Discussion
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...
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
I hope my post makes sense if not, please let me know and I'll clarify where needed.