Inserting image via URL - image not shown for some URLs

[ALCM]

Seeking advice on why my image via URL works for some kinds of URLs, but not others. For example, I used these to try to pull an image from the respective URLs. Note: only(XXX) are links to columns in my dataset.

1. ='https://img.pokemondb.net/sprites/black-white/normal/' & only(english_name) & '.png'
2. ='https://raw.githubusercontent.com/HybridShivam/Pokemon/master/assets/images/' & only(national_number) & '.png'//
   
3. ='https://raw.githubusercontent.com/PokeAPI/sprites/master/sprites/pokemon/' & only(national_number2) & '.png'

However, only (2) and (3) worked . Please refer to the screenshot attached - (1) is what I keyed in for the image URL under the column "english_name", while (2) and (3) were used for the columns with the images successfully shown.

What is weird is that when keying in (1) manually (example below), I can link to the webpage with the image, so it seems like the URL is working.

http://img.pokemondb.net/sprites/black-white/normal/garbodor.png

Would appreciate any advice or workarounds on this.

Thank you! 🙂

[ajaykakkar93]

Hi,
I checked in the above link, the english name should be in lowercase, you have in uppercase 
https://img.pokemondb.net/sprites/black-white/normal/bulbasaur.png
https://img.pokemondb.net/sprites/black-white/normal/muk.png
https://img.pokemondb.net/sprites/black-white/normal/ivysaur.png
https://img.pokemondb.net/sprites/black-white/normal/venusaur.png
https://img.pokemondb.net/sprites/black-white/normal/charmander.png
https://img.pokemondb.net/sprites/black-white/normal/burmy.png
https://img.pokemondb.net/sprites/black-white/normal/pikachu.png

[ALCM]

Hi!

Thanks for spotting the error! I have amended the expression to instead be lowercase, but strangely it still didnt work. Have instead tried to use the URLs directly just to experiment (e.g. https://img.pokemondb.net/sprites/black-white/normal/bulbasaur.png), but it still doesnt display as an image. Screenshot is as attached - the expression was written under the column english_name.

Have experimented with some other potential sources for images, and noticed that only those from github manage to work. Would like to seek advice on whether only certain types of URLs can be used as the source for images? If so, appreciate any thoughts on what types I should look out for.

Thanks!

[lilysophie0121]

It looks like the first URL might be blocked from direct embedding (hotlink protection), which is why it shows when opened manually but not when pulled into your dataset. Sometimes switching to repositories like PokeAPI is more reliable for sprites. If you’re using these images to plan strategies, a team builder Pokémon tool could also help by handling sprites, roles, and weaknesses automatically.