Hello I need to create a sitemap for videos but the videos are inside a videoplayer block in contentblocks.
Each video had this schema, so I got the necessary data for the sitemap:
<script type="application/ld+json">
{
"@context": "http://schema.org",
"@type": "VideoObject",
"name": "[[+videoName]]",
"description": "[[+videoDescription]]",
"thumbnailUrl": "[[+videoThumbnailUrl]]",
"uploadDate": "[[+videoUploadDate]]",
"duration": "[[+videoDuration]]",
"contentUrl": "[[+videoUrl]]",
"embedUrl": "[[+videoEmbedUrl]]",
"interactionCount": "[[+videoCount]]"
},
"publisher": {
"@type": "Organization",
"name": "[[+site_name]]",
"logo": {
"@type": "ImageObject",
"url": "https://www.site.com/assets/img/logo/1van1man-logo.png",
"width": 200,
"height": 65
}
}
</script>
I created a div wiht the necessary data structure so I can get the data already builded to move it into the XML file.
<div class="videoSitemap" style="display: none;">
<url>
<loc>https://www.example.com/video-page</loc>
<video:video>
<video:thumbnail_loc>[[+videoThumbnailUrl]]</video:thumbnail_loc>
<video:title>[[+videoName]]</video:title>
<video:description>[[+videoDescription]]</video:description>
<video:player_loc allow_embed="yes">[[+videoEmbedUrl]]</video:player_loc>
<video:duration>[[+videoDuration]]</video:duration>
<video:publication_date>[[+videoUploadDate]]</video:publication_date>
</video:video>
</url>
</div>
The problem is that I can’t get this content directly from the database, not sure where contentblocks is saving this data. I tried to get the data in different ways but no good luck.
If anyone can give me an idea about how to do it will be good, thanks!