Click or drag to resize
MediaVideo table
Print this page

The MediaVideo table provides access to video data within Fleet, allowing applications to refer to Verizon Connect' and customer's video files. The MediaVideo table holds the video's file properties and URL as well as video metadata.

This topic contains the following sections:

Requirements

When you write templates that access this table, follow these requirements:

  1. Specify the Symbolic Name for the table version to use:

    Copy
    TableID = MediaVideo-1.0

  2. Specify an Intent that this table supports:

    • Retrieve

  3. Input templates: In your [Output] section, be sure to map an input value to every table column that is flagged as being a primary key or required.

  4. Retrieve templates: This table does not require the use of a fetcher. However, the following fetchers are available to optimize your query and are listed from most efficient to least:
    1. Id (Equals/In)
      Copy
      [Filter]
Id(ExtId) = Equals(Id1)   # You can filter on literals or on variables from the [User] or [Calculated] sections.
      Copy
      [Filter]
Id(ExtId) = In(["Id1","Id2","Id3"])
    2. ChannelId (Equals)
      Copy
      [Filter]
ChannelId(ExternalIdName) = Equals("ABC123")  # or use Telogis Id: ChannelId = Equals("abcd...")
MediaVideo column descriptions

This list includes each column's name, which you use in expressions to retrieve data, and data type, which defines how the data is retrieved.

Column Data Type Description
Id Id (primary key) The ID of the channel.
Name Text (Telogis key) The name of the video.
Description Text User-specified description of the video.
OriginalUrl Text The original URL to the video file.
ThumbnailUrl Text The URL to the thumbnail image of the video file.
Duration TimeInterval The duration of the video file.
LastUpdateTime Timestamp The time the video file was last edited.
ChannelId Id<MediaChannel> The GUID of the channel, if any.

Additional columns:

Column Data Type Description
CustomerId Id (read-only, all Fleet tables) The ID of the customer/owner.
CustomerFullName Text (read-only, all Fleet tables) The human-readable full name of the customer/owner.