Forum Discussion

kafreitass's avatar
kafreitass
Helper I
3 years ago
Solved

API request is not returning all lists

Hey, guys!

Can anyone help me with a doubt?
I'm using an API to get some data. I created a function, but when invoking this function, at first it brought me the 3 existing lists, now it is returning only 2 lists. Can anyone tell me what could be happening and how I could solve it?

My function fx_Produtos

(page) =>

let
    Source =  
    Json.Document(
        Web.Contents(
            "https://api.com.br/",
                [
                    RelativePath = "RelativePath ",
                    Query = 
                    [
                        token = "token",
                        formato = "json",
                        pagina = Number.ToText(page) 
                    ]
                ]
        )
    ),
    Table = Source{0}[table]
in
    Source

 

invoke function

let
    totalpages = fx_Produtos(1)[retorno][numero_paginas],
    listOfPages = List.Generate(
        () => [page = 1, data = fx_Produtos(1)],
        each [page] <= totalpages,
        each [page = [page] + 1, data = fx_Produtos([page]+1)]
    ),
    #"Converted to Table" = Table.FromList(listOfPages, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"data"}, {"data"}),
    #"Expanded data" = Table.ExpandRecordColumn(#"Expanded Column1", "data", {"retorno"}, {"retorno"}),
    #"Expanded retorno" = Table.ExpandRecordColumn(#"Expanded data", "retorno", {"produtos"}, {"produtos"}),
    #"Expanded produtos" = Table.ExpandListColumn(#"Expanded retorno", "produtos"),
    #"Expanded produtos1" = Table.ExpandRecordColumn(#"Expanded produtos", "produtos", {"produto"}, {"produto"})
in
    #"Expanded produtos1"

 Thanks