Forum Discussion

WillY_OneEyed's avatar
WillY_OneEyed
New Member
3 years ago
Solved

A column with Records and Lists

Hi Folks, I'm trying append all LIST register.   The code is here:   let Paginas = (Page) => let Source = Json.Document( Web.Contents("http://api.worldbank.org", [Headers ...
Need Help
  • ThxAlot's avatar
    ThxAlot
    3 years ago

     

    Make it simple,

     

    let
    Source = List.Accumulate(
        {1..6},
        {},
        (s,c) => s & Json.Document(Web.Contents("http://api.worldbank.org/v2/country?format=json&page=" & Number.ToText(c))){1}
    ),
    #"Table From Records" = Table.FromRecords(Source)
in
    #"Table From Records"

     

     

     

ThxAlot's avatar
ThxAlot
Super User
3 years ago

 

Make it simple,

 

let
    Source = List.Accumulate(
        {1..6},
        {},
        (s,c) => s & Json.Document(Web.Contents("http://api.worldbank.org/v2/country?format=json&page=" & Number.ToText(c))){1}
    ),
    #"Table From Records" = Table.FromRecords(Source)
in
    #"Table From Records"