Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am a newbie in the API space, and I am trying to pull all the paginated data from UserVoice. They have a limit of 100 results per page, and I can't use the ?limit syntax to increase the limit. I have this so far in Power Query, but it is giving me the same results over and over again. Can anybody assist?
let
url = "https://SUBSITE.uservoice.com/",
Header=[Authorization="TOKEN"],
RelativePathing = "api/v2/admin/suggestions",
Source1 = Json.Document(Web.Contents(url, [RelativePath=RelativePathing, Headers=Header])),
iterations = Source1[pagination][total_pages],
FullURL = url & RelativePathing,
FnGetOnePage =
(FullURL) as record =>
let
Source2 = Json.Document(Web.Contents(url, [RelativePath=RelativePathing, Headers=Header])),
data = try Source2[suggestions] otherwise null,
next = try Source2[pagination][cursor] otherwise null,
res = [Data=data, Next=FullURL & "?cursor=" & next]
in
res,
GeneratedList =
List.Generate(
()=>[i=0, res = FnGetOnePage(FullURL)],
each [i]<iterations and [res][Data]<>null,
each [i=[i]+1, res = FnGetOnePage([res][Next])],
each [res][Data])
in
GeneratedList
Solved! Go to Solution.
@glove80 hope this post helps.
I would 💖Kudos 🙂 if my solution helped. If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
HI @glove80,
You can also take a look at sample helper functions that shared on official documents:
Helper Functions#tablegeneratebypage
Regards,
Xiaoxin Sheng
@glove80 hope this post helps.
I would 💖Kudos 🙂 if my solution helped. If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.