Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hey there,
I've been trying to paginate an API from World Bank, but it does not work. Basically, I list how many pages are to be listed in the final table (which by default loads only 50 rows), but as the custom function is invoked, the following error message pops up:
DataFormat.Error: We found an unexpected character in the JSON input.
Details:
Value=<
Position=0
Does anyone know what I'm doing wrong and how to make it work?
Solved! Go to Solution.
Simple enough
let
Source = Xml.Tables(Web.Contents("http://api.worldbank.org/v2/country"))[#"Attribute:pages"]{0},
Pages = Table.FromList({"1"..Source}, Splitter.SplitByNothing(), {"Page"}),
#"API Call" = Table.AddColumn(Pages, "API Call", each Xml.Tables(Web.Contents("http://api.worldbank.org/v2/country?page="&[Page])))
in
#"API Call"
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LeanAndPractise(Everyday) ) |
Simple enough
let
Source = Xml.Tables(Web.Contents("http://api.worldbank.org/v2/country"))[#"Attribute:pages"]{0},
Pages = Table.FromList({"1"..Source}, Splitter.SplitByNothing(), {"Page"}),
#"API Call" = Table.AddColumn(Pages, "API Call", each Xml.Tables(Web.Contents("http://api.worldbank.org/v2/country?page="&[Page])))
in
#"API Call"
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LeanAndPractise(Everyday) ) |
Thanks a lot for your response, thxalot kkkk
It really worked out.
@Anonymous , refer if this can help
https://medium.com/@marktiedemann/how-to-do-pagination-in-power-query-430460c17c78
User | Count |
---|---|
121 | |
72 | |
71 | |
57 | |
50 |
User | Count |
---|---|
167 | |
83 | |
68 | |
66 | |
55 |