I use a custom query to get the show info, including VOD URL. To see if the VOD exists, I check if the "cablecast_vod_url" value is empty.
But it appears that when a VOD file is being transcoded, it inserts "http://reflect.vod.xxxx.cablecast.tv/vod/" as the URL. I noticed sometimes even the full VOD URL will get inserted before the transcoding is finished.
So might this be a bug on the Cablecast side if it's assigning the URL before the file is finished transcoding?