Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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.
@Pedro503 , refer if this can help
https://medium.com/@marktiedemann/how-to-do-pagination-in-power-query-430460c17c78
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!