Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I'm new to this community so I hope that i got the location right..
background:
I want to build someting around the webAPI's of the task tool Nozbe. You can organize your tasks in projects. I want all the tasks and all the projects so I can see the progress of tasks done. basically just because i thing this should be able with Power BI and I want to improve my Power BI skills.
current situation:
api for projects fills my project tables (https://webapp.nozbe.com/api/projects/)
but then I have to call the taks below based on the project ID. (https://webapp.nozbe.com/api/actions/what-project/id-????/)
I ve used the combine function to combine multiple queries (taks for project x, y, z).. but that is too fixed (I don't want to change code when I make a new project)
Question:
Is it posible to use a parameter to call the taks of a project and then loop through it.
so in simplified code:
For each [projectid] in Projects do:
tablewithtasks = tablewithtasks + call: https://webapp.nozbe.com/api/actions/what-project/id-[projectid]
Thanks in advance,
Anton
Solved! Go to Solution.
It's all about getting third party data via API's
If I got your idea correctly, you could store the parameters in one column and call the API row by row. Check a simple demo below. You could check the returned json by clicking Moscow weather json.
let Source = Table.FromRecords({ [city= "Moscow",cid=524901], [city= "Paris",cid=2988507], [city= "London",cid=2643743]}), #"Changed Type" = Table.TransformColumnTypes(Source,{{"cid", type text}}), #"Added Custom" = Table.AddColumn(#"Changed Type", "responseJson", each Json.Document(Web.Contents("http://api.openweathermap.org/data/2.5/forecast/city?id="&[cid]&"&APPID=76acd9a867adb4cd9120298d16b3655f"))) in #"Added Custom"
Hey antonb,
do you built your own Visual or you want take your third party data in Power BI?
sry when i missunderstand your question.
Nice Regards
Mcburn
hi Mcburn,
It's all about getting third party data via API's
Thanks!
Anton
It's all about getting third party data via API's
If I got your idea correctly, you could store the parameters in one column and call the API row by row. Check a simple demo below. You could check the returned json by clicking Moscow weather json.
let Source = Table.FromRecords({ [city= "Moscow",cid=524901], [city= "Paris",cid=2988507], [city= "London",cid=2643743]}), #"Changed Type" = Table.TransformColumnTypes(Source,{{"cid", type text}}), #"Added Custom" = Table.AddColumn(#"Changed Type", "responseJson", each Json.Document(Web.Contents("http://api.openweathermap.org/data/2.5/forecast/city?id="&[cid]&"&APPID=76acd9a867adb4cd9120298d16b3655f"))) in #"Added Custom"
thanks.. that helped a lot!
I now have a query that starts with the projects. Than within the same query a extra column is added with the JSON request (with a variable of the projectsID).
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
25 | |
3 | |
2 | |
2 | |
2 |