On This Page
QuickBooks Time, formerly known as Tsheets, is an accounting and scheduling software. With QuickBooks Time, employees can easily clock in and out time using their devices and from any location. Additionally, it allows you to track time against different job codes, to gain valuable business insights with QuickBooks Time reports. With the “Who’s Working” feature, it is easy to see where your employees are located and who’s working on what in real-time.
QuickBooks Time authenticates API requests from Hevo to access your account data with OAuth2.0.
An active QuickBooks Time account from which the data is to be ingested.
The access token is available to authenticate Hevo on your QuickBooks Time account.
You are logged in as an Admin, to create the access token. Else, you can obtain the access token from your administrator. Read team member settings and permissions to know about the different types of user accounts in QuickBooks Time.
Creating an Access Token
Perform the following steps to create the access token:
Log in to your QuickBooks Time as an Admin user.
In the QuickBooks Time home page, click Feature Add-ons and select Manage Add-ons from the drop-down.
In the Manage Add-ons page, do one of the following:
Create an access token
Scroll down to the API section and click Install.
Click + Add a new application to create the access token.
In the API application page, specify the Name, Description, and OAuth Redirect URI fields, and then click Save.
Note: OAuth Redirect URI is the site to which the user is redirected after the authorization server has successfully authorized the app.
Under the Access Tokens section, copy the token and save it securely like any other password.
Note: By default, the access token that you generate in QuickBooks Time expires after two months. However, QuickBooks Time provides you with an option to extend the access token expiry date.
Use an existing access token:
Scroll down to the API section, and click Preferences.
Click Edit Token, corresponding to the name of the access token to reveal the access token.
Copy the access token and save it securely like any other password. Use the access token while configuring your Pipeline.
Configuring QuickBooks Time as a Source
Perform the following steps to configure QuickBooks Time as the Source in your Pipeline:
Click PIPELINES in the Navigation Bar.
Click + CREATE in the Pipelines List View.
In the Select Source Type page, select QuickBooks Time.
In the Configure your QuickBooks Time Source page, specify the following:
Pipeline Name: A unique name for the Pipeline, not exceeding 255 characters.
Access Token: The access token that you copied from your QuickBooks Time account.
Click TEST & CONTINUE.
Proceed to configuring the data ingestion and setting up the Destination.
|Default Ingestion Frequency||Minimum Ingestion Frequency||Maximum Ingestion Frequency||Custom Frequency Range (Hrs)|
|1 hr||1 hr||24 hrs||1-24|
Note: You must set the custom frequency in hours as an integer value. For example, 1, 2, 3 but not 1.5 or 1.75.
- Historical Data: In the first run of the Pipeline, Hevo ingests historical data for all the objects on the basis of the historical sync duration selected at the time of creating the Pipeline and loads it to the Destination.
Schema and Primary Keys
Hevo uses the following schema to upload the records in the Destination database:
The following is the list of tables (objects) that are created at the Destination when you run the Pipeline:
|Current User||Contains details about the currently authenticated user in your Quickbooks Time account.|
|Custom Fields||Contains details about the custom fields that you have created to capture information related to custom activities other than time tracking.|
|Geofence Configs||Contains details of clock in and clock out reminders sent to workers when they enter and leave a job site.|
|Geolocations||Contains details of all employees’ real-time location using GPS, to track devices connected to your account.|
|Groups||Contains details of the employees who focus on one kind of task, or have similar job responsibilities.|
|Jobcodes||Contains details of the unique IDs assigned to various roles, such as plumber or carpenter, and tasks, such as mopping or painting.|
|Jobcode Assignments||Contains details of all the jobcodes that a user can select while tracking time.|
|Locations||Contains details of all the physical sites associated with your company.|
|Locations Maps||Contains details of the location of employees when they clock in.|
|Managed Clients||Contains details of all the clients in your QuickBooks Time account, such as the ID and name.|
|Reminders||Contains details of the notifications sent to an employee.|
|Schedule Calendars||Contains details of all the events, meetings, and tasks in your calendar.|
|Timesheets||Contains details of the actions such as completing a job, or making a site visit, and the time spent on these actions by an employee.|
|Timesheets Deleted||Contains details of all the timesheets removed for a user.|
|Time Off Requests||Contains details of all the requests sent by employees for paid or unpaid leaves.|
|Files||Contains details of the images associated with the timesheet. For example, an image which provides a visual proof of the completion of a job.|
|Users||Contains details of all the accounts associated with your company.|
Pagination: Each API response for each QuickBooks Time object fetches one page with up to 50 records.
Rate Limit: QuickBooks Time imposes a limit of a maximum of 300 API calls per 5 minutes to optimize performance.
Hevo currently does not support deletes. Therefore, any data deleted in the Source may continue to exist in the Destination.
The data is loaded in Full Load mode in each Pipeline run. As a result, you cannot load the historical data alone at any time.
Refer to the following table for the list of key updates made to this page:
|Date||Release||Description of Change|
|Sep-06-2023||NA||Updated the page for more clarity.|