Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Real time data from web page with .zip files

I am trying to create a real time report from the following website.  The website updates data every hour by generating a new .zip file at the bottom of the list. The difficulty is twofold: the ....
Dataflow
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    I solved this problem with python.

    Please check this reply. 

    Cheers

v-luwang-msft's avatar
v-luwang-msft
Community Support
4 years ago

Hi Anonymous ，

Test  M code as below:

let
Source = Web.Contents("http://res1104.se.gob.ar/adjuntos/precios_eess_2013_en_adelante.zip",[Headers=[#"Accept-Encoding"="gzip"]]),
Decompress = Binary.Decompress(Source, Compression.GZip)
in
Decompress

 

To learn more details ,refer:

 

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hello, Lucien

Thanks for the reply.

The problem with the solution provided is that the file path changes periodically whilst the code from your solution treats the file path as fixed.