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

[dmartinezCJPB]

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. Is there any trick you could share with me?

The web site is this:

https://www.ine.gub.uy/indicadores?indicadorCategoryId=11421 

[dmartinezCJPB]

Thank you, bro!

[lbendlin · Accepted solution]

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...

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".