Understanding Timesheet Data from Jobber - Adhesion Connect Guide

Understanding Time Sheet Data

To help you understand the Timesheet information available through Adhesion Connect for Jobber we've put together the following outline. Each data component includes the field type and a description below it to help you understand how to best use the information in your integrations and automations.

Time Sheet

A Time Sheet which a User has entered in Jobber to log the hours which they have worked.

Fields

approved

Field Type: boolean (true/false)
Description: Indicates whether this Time Sheet entry is approved.

approved_by

Description: The User that approved this Time Sheet entry.

  1. name

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The name of the User.

  1. email

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The email of the User.

client

Description: The Client associated with the Job linked to the Time sheet entry.

  1. id

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The unique identifier from Jobber for the Client.

  1. name

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The primary name of the Client.

  1. first_name

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The first name of the Client.

  1. last_name

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The last name of the Client.

  1. emails

Description: The email addresses belonging to the Client.
  1. address
Field Type: string (text, numbers, and/or special characters stored as text)
Description: The email address as stored in Jobber.
  1. primary
Field Type: boolean (true/false)
Description: Identifies whether the email address is marked as the primary email address.
  1. id
Field Type: string (text, numbers, and/or special characters stored as text)
Description: The unique identifier from Jobber for the email address.

created_at

Field Type: date (date & time in ISO8601)
Description: The date and time the Time Sheet entry was created.

end_at

Field Type: date (date & time in ISO8601)
Description: The date and time the Time Sheet entry was completed.

final_duration

Field Type: integer
Description: Duration of a stopped time sheet entry in seconds (resolves to 0 for ticking entries).

id

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The unique identifier from Jobber for the Time Sheet entry.

job

Description: The Job associated with the Time Sheet entry.

  1. id

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The unique identifier from Jobber for the Job.

  1. job_number

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The number from Jobber for the Job.

  1. title

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The title associated with the Job.

label

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The label on the Time Sheet entry.

labor_rate

Field Type: decimal
Description: The labor rate associated with the Time Sheet entry.

note

Field Type: string (text, numbers, and/or special characters stored as text)
Description: A note associated with the Time Sheet entry.
Description: The User that marked this Time Sheet entry as paid.

  1. name

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The User's name.

  1. email

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The User's email address.

start_at

Field Type: date (date & time in ISO8601)
Description: The date and time the Time Sheet entry was started.

ticking

Field Type: boolean (true/false)
Description: Identifies whether the timer is actively running or not.

updated_at

Field Type: date (date & time in ISO8601)
Description: The date and time the Time Sheet entry was last updated.

user

Description: The user that this Time Sheet entry belongs to.

  1. name

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The name of the User.

  1. email

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The email of the User.

visit

Description: The Visit linked to the Time Sheet entry.

  1. title

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The title of the scheduled Visit.

  1. start_at

Field Type: date (date & time in ISO8601)
Description: The start date and time of the scheduled Visit. An unscheduled Visit is represented by both start_at and end_at being null.

  1. end_at

Field Type: date (date & time in ISO8601)
Description: The end date and time of the scheduled Visit. An unscheduled Visit is represented by both start_at and end_at being null.

  1. id

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The unique identifier from Jobber for the Visit.

visit_duration_total

Field Type: integer
Description: Total duration in seconds the user worked on the related Visit.

event_type

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The Jobber event that happened (Time Sheet Create/Time Sheet Update).


    • Related Articles

    • Understanding Visit Data

      To help you understand the Timesheet information available through Adhesion Connect for Jobber we've put together the following outline. Each data component includes the field type and a description below it to help you understand how to best use the ...

    • Understanding Job Data

      To help you understand the Job information available through Adhesion Connect for Jobber we've put together the following outline. Each data component includes the field type and a description below it to help you understand how to best use the ...

    • Understanding Payment Data

      To help you understand the Payment information available through Adhesion Connect for Jobber we've put together the following outline. Each data component includes the field type and a description below it to help you understand how to best use the ...

    • Understanding Expense Data

      To help you understand the Expense information available through Adhesion Connect for Jobber we've put together the following outline. Each data component includes the field type and a description below it to help you understand how to best use the ...

    • Understanding Quote Data

      To help you understand the Quote information available through Adhesion Connect for Jobber we've put together the following outline. Each data component includes the field type and a description below it to help you understand how to best use the ...