Hi,
I'm getting the following error when I try to bulk validate image URLs.
What's causing this issue?
Kevin
How are you doing the "bulk" part?
I meant a range of cells containing image URLs.
Range of cells are not supported. You need to use Formula mode for one image URL, then expand the formula to the rest of the list.
Thanks.
What valid values does the formula take?
ImageProperties(imageUrl,fields,excludeHeaderInResult)
imageURL is pretty self-explanatory. For fields, should I use the properties exactly as they are listed here: https://seotoolsforexcel.com/imageproperties/?
Lastly, what do I put in for excludeHeaderInResult?
You can experiment with the formula settings from the ImageProperties taskpane (found in HTTP tab):
Here, you can chose the fields and other arguments. In the example, I've used brackets around A2 which is a shortcut to insert the cell reference in the formula.
Thank you!
I used the formula to validate image load status. For most, the returned status was ok, but for some, I got #VALUE!.
For example - https://assethub-pro-us-standard-cache.s3.amazonaws.com/hp%2Fba57152e80717158aaceb17ff5f2d43ffa28eb9d
The link is public and you can paste the URL into the browser to see the image, but the formula is returning #VALUE!. Why is that happening?
FYI, the formula is =ImageProperties(s420,FileName,TRUE)
Hi!
Just following up on my question. Actually, I'm not even sure if you are a support staff or just a very friendly community member, but I'm appreciative nonetheless!
Can you please take a look at my question and tell me what the issue might be?
Kevin
Hi Kevin,
Thanks for noticing this. I haven't solved it yet but working on it.
1 Like
Identified and fixed the error. The fix will be included in the next release (hopefully out in 1-2 months).
Do you have other examples of image urls which resulted in errors?
Thanks for the update!
Here are a few more.
Thanks
Thanks, all images worked 
Hi!
Has this been fully resolved with the update? There are still some image URLs that are returning error.
For example...
https://store.hp.com/CanadaStore/Html/Merch/Images/c05714247_1750x1285.jpg
https://store.hp.com/CanadaStore/Html/Merch/Images/c05101508_1750x1285.jpg
https://store.hp.com/CanadaStore/Html/Merch/Images/c05101719_1750x1285.jpg
The formula I'm using is
=Dump(ImageProperties('SEO Optimized Feed - NO PAPER'!U26,"FileName",TRUE))
Thanks,
Kevin
Hi Kevin,
We have not released the new build yet but if you email me (victor@seotoolsforexcel.com) I can send it to you. Those images returns 'forbidden' and the same is true for the DownloadFile function. Will need to look into why.
Update: Issue has been fixed