Understanding Job Data from Jobber - Adhesion Connect Guide

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 information in your integrations and automations.

Job

A detailed contract of work which a service provider uses to schedule work for a Client

Fields

arrival_window

Description: The time window during which the service provider can arrive at the Job

  1. start

Field Type: date (date & time in ISO8601)
Description: The start time of the arrival window.

  1. end

Field Type: date (date & time in ISO8601)
Description: The end time of the arrival window.

  1. duration

Field Type: integer
Description: The duration of the arrival window.

billing_type

Field Type: select(fixed_price, visit_based)
Description: Invoicing strategy selected for the Job

booking_confirmation_sent_at

Field Type: date (date & time in ISO8601)
Description: The time when booking confirmation for the Job was sent.

client

Description: The Client associated with the Job.

  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 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 of the Client.
  1. address
Field Type: string (text, numbers, and/or special characters stored as text)
Description: The email address as stored.
  1. primary
Field Type: boolean (true/false)
Description: Identifies if this is the primary email address.

  1. phones

Description: The list of phone numbers of the Client.
  1. number
Field Type: string (text, numbers, and/or special characters stored as text)
Description: The phone number as it is stored in Jobber.
  1. id
Field Type: string (text, numbers, and/or special characters stored as text)
Description: The unique identifier from Jobber for the number.

client_automatically_charged

Field Type: boolean (true/false)
Description: Identifies if the client will be automatically charged. 

completed_at

Field Type: date (date & time in ISO8601)
Description: The completion date of the Job.

created_at

Field Type: date (date & time in ISO8601)
Description: The time the Job was created.

custom_fields

Field Type: multiple
Description: Your custom fields represented as key:value pairs.
Example: 
{
"custom field label 1": "custom field value 1",
"custom field label 2": "custom field value 2"
}

default_title

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The default title for new Visits

end_at

Field Type: date (date & time in ISO8601)
Description: End date of the Job.

instructions

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

job_costing

Description: The job costing fields representing the profitability of the Job.

  1. expense_cost

Field Type: decimal
Description: Total expense cost associated with this Job.

  1. labor_cost

Field Type: decimal
Description: Total labor cost associated with this Job.

  1. labor_duration

Field Type: integer
Description: Total labor duration in seconds of the Job.

  1. line_item_cost

Field Type: decimal
Description: Total line item cost associated with this Job.

  1. profit_amount

Field Type: decimal
Description: Total profit amount associated with this Job.

  1. profit_percentage

Field Type: decimal
Description: Total profit percentage associated with this Job.

  1. total_cost

Field Type: decimal
Description: Total cost associated with this Job.

  1. total_revenue

Field Type: decimal
Description: Total revenue associated with this Job.

number

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

status

Field Type: select (requires invoicing, archived, late, today, upcoming, action required, on hold, unscheduled, active)
Description: The status of the Job.

type

Field Type: select (one off, recurring)
Description: The type of Job.

jobber_url

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The URL for the Job record in Jobber Online

line_items

Description: The line items associated with the Job

  1. created_at

Field Type: date (date & time in ISO8601)
Description: The date and time the line item was created.

  1. category

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

  1. name

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

  1. quantity

Field Type: decimal
Description: The quantity of the line item.

  1. taxable

Field Type: boolean (true/false)
Description: Identifies if the line item is taxable.

  1. unit_cost

Field Type: decimal
Description: The unit cost of the line item.

  1. unit_price

Field Type: decimal
Description: The unit price of the line item.

  1. total_cost

Field Type: decimal
Description: The total cost of the line item.

  1. total_price

Field Type: decimal
Description: The total price of the line item.

  1. updated_at

Field Type: date (date & time in ISO8601)
Description: The last date and time the line item was updated.

property

Description: The Property related to the Job.

  1. id

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

  1. address

Description: The address of the Property
  1. street
Field Type: string (text, numbers, and/or special characters stored as text)
Description: The complete street component of this address.
  1. street_1
Field Type: string (text, numbers, and/or special characters stored as text)
Description: The first line of this address.
  1. street_2
Field Type: string (text, numbers, and/or special characters stored as text)
Description: The second line of this address.
  1. city
Field Type: string (text, numbers, and/or special characters stored as text)
Description: The city for this address.
  1. province_state
Field Type: string (text, numbers, and/or special characters stored as text)
Description: The province/state for this address.
  1. postal_code
Field Type: string (text, numbers, and/or special characters stored as text)
Description: The zip or postal code for this address.
  1. country
Field Type: string (text, numbers, and/or special characters stored as text)
Description: The country for this address.

quote

Description: The Quote related to the Job

  1. id

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

  1. number

Field Type: string (text, numbers, and/or special characters stored as text)
Description: A non-unique number assigned to the Quote by a Service Provider.

request

Description: The Request related to the Job

  1. id

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

start_at

Field Type: date (date & time in ISO8601)
Description: Start date of the Job.

time_sheet_entries

Description: A list of all timesheet entries for this Job.

  1. id

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

  1. approved

Field Type: boolean (true/false)
Description: Identifies whether the time sheet entry is approved.

  1. user

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

  1. start_at

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

  1. end_at

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

  1. duration

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

  1. label

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

  1. labor_rate

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The labor rate associated with the Time Sheet entry.

  1. ticking

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

title

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

total

Field Type: decimal
Description: The total chargeable amount for the Job.

updated_at

Field Type: date (date & time in ISO8601)
Description: The last time the Job was updated.

visit_schedule

Description: A list of all visits for this Job.

  1. start_time

Field Type: date (date & time in ISO8601)
Description: Start time of the visit.

  1. end_time

Field Type: date (date & time in ISO8601)
Description: End time of the visit.

  1. assigned_to

Field Type: string (text, numbers, and/or special characters stored as text)
Description: Users assigned at time of job creation. This may differ from users assigned to the job's visits

visits_info

Description: Information about the Job's visits.

  1. future

Field Type: integer
Description: The total of incomplete scheduled and unscheduled visits.

  1. incomplete

Field Type: integer
Description: The total number of incomplete visits.

  1. past

Field Type: integer
Description: The number of past incomplete visits on the job up until the end of the current day.

  1. scheduled

Field Type: integer
Description: The number of scheduled visits that are incomplete.

  1. unscheduled

Field Type: integer
Description: The number of unscheduled visits.

event_type

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





    • Related Articles

    • 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 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 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 ...

    • 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 Invoice Data

      To help you understand the Invoice 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 ...