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.
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:
When you write templates that access this table, follow these requirements:
Specify the Symbolic Name for the table version to use:
TableID = Photo-1.0
Specify an Intent that this table supports:
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.
[Filter] Id(ExtId) = Equals(Id1) # You can filter on literals or on variables from the [User] or [Calculated] sections.
[Filter] Id(ExtId) = In(["Id1","Id2","Id3"])
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.
|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.|
|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'.|