Forum Discussion
dmartinezCJPB
4 years agoFrequent Visitor
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....
- 4 years ago
Looks like you need to push some form payload with start and count values
Or you could download the entire table
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".
dmartinezCJPB
4 years agoFrequent Visitor
Thank you, bro!