Getting actual images from URL Binary.ToText(Web.Contents([URL]) RRS feed

  • Question

  • Hi there!

    I'm getting images URLs from a query. I'd like to show the actual images in the resulting table in Excel. I have played about and almost got there, but I'm missing the last step, I'm afraid.

    As you can see, I'm getting the "photo" field which contains the URL. Then created a custom column that decodes to text, which gives the right Base64 encoding. 

    ="data:image/jpeg;base64, " & Binary.ToText(Web.Contents([photo]), BinaryEncoding.Base64)

    But then I've transformed the column in binary and didn't work ("Error: Invalid binary encoding."). Of course it also didn't work with just 


    Any ideas?

    Thank you!


    Friday, January 4, 2019 5:00 PM


All replies