Click or drag to resize
Photo table
Print this page

The Photo table provides access to Photo data within Fleet, allowing forms and reports to include image files. The Photo table holds data associated with image files that are captured as part of performing and completing jobs. The information includes the photo's file properties and location as well as metadata about when and where it was captured.

Note Note

Photo support is specific to adding images to Mobile forms, not driver profiles. You can manage driver profile photos from the Fleet platform.

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 = Photo-1.0

  2. Specify an Intent that this table supports:

    • Retrieve
    • Create
    • Update
    • CreateOrUpdate
    • Delete

  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 requires the use of a fetcher. The following fetchers are available 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"])
Photo column descriptions

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

Note Note
If a column of data type Id is a primary key OR if it refers to other tables (Id <OtherTable>), then you can map it to an external key or, in some cases, a Telogis key.
Column Data Type Description
Id Id (primary key) The GUID of the photo.
Name Text (Telogis key) The name of the image file, which must be unique. If the extension is not specified, browser clients derive it from the content type.
Path Text User-specified categorization for photo files, for retrieving photos by kind.
FullImageUrl Text (read-only) The URL string for requesting or updating the binary bitmap data.
CaptureTime Timestamp The time when the photo was taken.
CaptureAddress Address The location where the photo was taken.
PixelWidth Number (read-only) For aspect ratio as x:y, the photo's width (x) in pixels.
PixelHeight Number (read-only) For aspect ratio as x:y, the photo's height (y) in pixels.
SizeInBytes Number (read-only) The size of the image file, in bytes.
ContentType Text (read-only) The MIME Content-Type (file format) that was uploaded. Typical values: 'image/jpeg', 'image/png'.

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.