Forum Discussion

dmartinezCJPB's avatar
dmartinezCJPB
Frequent Visitor
4 years ago
Solved

How to get data from a web that has a paginated table

Hi! Can anyone help me to get all the data from a paginated table in a web site?   I'm interested in getting data from a public institution that has the inflation index shown in a paginated table....
  • lbendlin's avatar
    4 years ago

    Looks like you need to push some form payload with start and count values

     

     

    Or you could download the entire table 

    https://www.ine.gub.uy/c/document_library/get_file?uuid=2e92084a-94ec-4fec-b5ca-42b40d5d2826&groupId=10181

     

    Unfortunately that is in .xls format which is not refreshable in the service.

    let
        Source = Excel.Workbook(Web.Contents("https://www.ine.gub.uy/c/document_library/get_file?uuid=2e92084a-94ec-4fec-b5ca-42b40d5d2826&groupId=10181"), null, true),
        #"IPC_Cua 2" = Source{[Name="IPC_Cua 1"]}[Data],
        #"Removed Top Rows" = Table.Skip(#"IPC_Cua 2",7),
        #"Promoted Headers" = Table.PromoteHeaders(#"Removed Top Rows", [PromoteAllScalars=true]),
        #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Mes y año", type text}, {"Índice", type number}, {"Mensual", type number}, {"Acum. año", type number}, {"Acum.12 meses", type number}, {"Trimestre", type number}, {"Cuatrimestre", type number}, {"Semestre", type number}, {"Column9", type text}, {"Column10", type text}}),
        #"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([Mes y año] <> null)),
        #"Removed Other Columns" = Table.SelectColumns(#"Filtered Rows",{"Mes y año", "Índice", "Mensual", "Acum. año", "Acum.12 meses", "Trimestre", "Cuatrimestre", "Semestre"})
    in
        #"Removed Other Columns"

    How to use this code: Create a new Blank Query. Click on "Advanced Editor". Replace the code in the window with the code provided here. Click "Done".