Skip to main content

EntryCell

A cell represents the intersection of a row and a date, containing the actual entry data (hours/amount) and associated metadata for that specific combination.

datestringrequired

Date in F8 format (YYYYMMDD)

Possible values: Value must match regular expression ^\d{8}$

Example: 20251103
amountnumber<float>required

The entry amount for this cell:

  • For time: hours (e.g., 8.0)
  • For expense: monetary amount or mileage
  • For custom: distance
Example: 8
idsstring[]

Array of entry record IDs that contribute to this cell's total. Multiple IDs indicate multiple entries for the same row/date combination.

Example: ["time_rec_12345","time_rec_67890"]
attachments object[]

File attachments associated with this cell

  • Array [
    • uniqueidstringrequired

    Encoded unique identifier for the attachment. Used to retrieve or delete the attachment.

    This can be provided to the getAttachmentByEncodedId legacy API method to retrieve the file.

    Example: dGltZV9hdHRhY2htZW50czoxMjM0NQ==
    creatorstringrequired

    User ID of the person who uploaded the attachment

    Example: alice
    create_timestampnumber<double>required

    Unix timestamp when the attachment was uploaded

    Example: 1762196180
    notestring

    Optional description or note about the attachment

    Example: Receipt for client lunch meeting
    filenamestringrequired

    Original filename of the uploaded file

    Example: receipt_2025-11-03.pdf
    mimetypestring

    MIME type of the file

    Example: application/pdf
    sizeinteger

    File size in bytes

    Example: 524288
  • ]
    • notes object[]

    Diary notes associated with this cell

  • Array [
    • idstringrequired

    Unique identifier for the note

    Example: note_12345
    textstringrequired

    The note text content

    Example: Worked on bug fixes for the login module
    modifiedboolean

    Whether the note has been modified since creation

    Example: false
  • ]
    • locations object[]

    GPS locations recorded for entries in this cell

  • Array [
    • coords objectrequired

    Geographic coordinates

    latitudenumber<double>required

    Latitude in decimal degrees

    Example: 30.0613632
    longitudenumber<double>required

    Longitude in decimal degrees

    Example: -99.1363072
    altitudenumber<double>nullable

    Altitude in meters above sea level (when available).

    Example: null
    accuracynumber<float>

    Horizontal accuracy in meters. A geofence can have a minimum required accuracy, but different devices may have different capabilities.

    Example: 963.78847
    notesstring

    Additional notes or description for this location. This is only rarely provided / available.

    Example:
    timestampnumber<double>required

    Unix timestamp (milliseconds) when the location was captured

    Example: 1762542072875
  • ]
    • EntryCell
    {
      "date": "20251103",
      "amount": 8,
      "ids": [
        "time_rec_12345",
        "time_rec_67890"
      ],
      "attachments": [
        {
          "uniqueid": "dGltZV9hdHRhY2htZW50czoxMjM0NQ==",
          "creator": "alice",
          "create_timestamp": 1762196180,
          "note": "Receipt for client lunch meeting",
          "filename": "receipt_2025-11-03.pdf",
          "mimetype": "application/pdf",
          "size": 524288
        }
      ],
      "notes": [
        {
          "id": "note_12345",
          "text": "Worked on bug fixes for the login module",
          "modified": false
        }
      ],
      "locations": [
        {
          "coords": {
            "latitude": 30.0613632,
            "longitude": -99.1363072,
            "altitude": null,
            "accuracy": 963.78847
          },
          "notes": "",
          "timestamp": 1762542072875
        }
      ]
    }