XpathOnURL on Youtube video

Support
#1

Hi,

Any idea to get the content of a "itemprop name" tag on a youtube video page ?

I.E on https://www.youtube.com/watch?v=lSevHFa6T0Y in the html source code of the page we've got : <meta itemprop="name" content="GoogleCacheDate">

How to get in an Excell cell GoogleCacheDate ?

Something like this in excel generate a blank cell !

=XPathOnUrl("https://www.youtube.com/watch?v=lSevHFa6T0Y";"//meta[@itemprop='name']/@content")

which formula to get the name of the video "GoogleCacheDate" in a cell ? or the thumbnail url in <link itemprop="thumbnailUrl" href="https://i.ytimg.com/vi/lSevHFa6T0Y/maxresdefault.jpg">

Thanks a lot for your help.

regards.

#2

Try this:

=XPathOnUrl("https://www.youtube.com/watch?v=lSevHFa6T0Y";"//meta[@itemprop='name']";"content")

and:

=XPathOnUrl("https://www.youtube.com/watch?v=lSevHFa6T0Y";"//link[@itemprop='thumbnailUrl']";"href")
#3

It's perfect, thanks a lot !