Forum Discussion

dyingod's avatar
dyingod
Helper I
8 years ago
Solved

Call web API, receive ZIP, decompress multiple JSON files, Load Them

Hello everyone,   Still a noob... I have a simple question. I searched around the forums and found this discussion as the most relevant but I can't make it work and maybe my case is different so I ...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    8 years ago

    dyingod,

    Yes, File.Contents function requires path parameter.

    In addition, I haven't found any built-in decompress function that can be used to decompress .zip file. Is there any possibility that your web service return .gzip file? If so, you can use Binary.Decompress to automatically proceed this transformation.

    Regards,
    Lydia

dyingod's avatar
dyingod
Helper I
8 years ago

Hey Lydia!

 

Thanks so much for this. I had also looked into that link but couldn't manage to do anything with it.

 

I get stuck here:

 

let
    Source = File.Contents("[Full path to your zip file]"),
    Files = UnzipContents(Source)
in
    Files

 

At the [Full path to your zip file], which make me think of a place in my drive but obviously it's not as it's within Power BI so what do I put in there? I tried calling the query with the ZIP by name but that didn't work. I really am a newbie. :(

 

I think the Custom Column trick sounds amazing and I never thought that possible... but I need to get over this other obstacle first. Can I call on your awesome help again? :)

 

Thank you!


Rafa

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    dyingod,

    Is there any possiblity that you download the zip file to your computer from web?

    Regards,
    Lydia

    • dyingod's avatar
      dyingod
      Helper I
      8 years ago

      Hey Lydia,

       

      You mean outside PowerQuery? PowerQuery does download it and show it to me as a file:

       

       

      The reason I'm trying to do it all via Power Query is just so it's automated.

       

      Or maybe I am wrong in assuming that file that returns in the screenshot is the actual zip?

       

      This is the ZIP file that contains 50+ JSON files I mentioned in the title.

       

      Thanks Lydia!

       

      Rafa

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        dyingod,

        Yes, File.Contents function requires path parameter.

        In addition, I haven't found any built-in decompress function that can be used to decompress .zip file. Is there any possibility that your web service return .gzip file? If so, you can use Binary.Decompress to automatically proceed this transformation.

        Regards,
        Lydia

  • mike_honey's avatar
    mike_honey
    Memorable Member
    6 years ago

    Try changing the line:

     

    Source = File.Contents(...

     

    to:

     

    Source = Web.Contents(...