QuickBooks Time (Independent Publisher) (Preview)
Connector to read data from QuickBooks Time. QuickBooks Time formerly known as TSheets is a web-based and mobile time tracking and employee scheduling app. The service was accessed via a web browser or a mobile app. TSheets was an alternative to a paper timesheet or punch cards.
This connector is available in the following products and regions:
| Service | Class | Regions |
|---|---|---|
| Logic Apps | Standard | All Logic Apps regions except the following: - Azure Government regions - Azure China regions - US Department of Defense (DoD) |
| Power Automate | Premium | All Power Automate regions except the following: - US Government (GCC) - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
| Power Apps | Premium | All Power Apps regions except the following: - US Government (GCC) - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
| Contact | |
|---|---|
| Name | Artesian Software Technologies LLP |
| URL | https://artesian.io |
| amit.sharma@artesian.io |
| Connector Metadata | |
|---|---|
| Publisher | Artesian Software Technologies LLP |
| Website | https://quickbooks.intuit.com/time-tracking/ |
| Privacy Policy | https://www.intuit.com/privacy/ |
| Categories | Human Resources; Productivity |
Creating a connection
The connector supports the following authentication types:
| Default | Parameters for creating connection. | All regions | Not shareable |
Default
Applicable: All regions
Parameters for creating connection.
This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.
| Name | Type | Description | Required |
|---|---|---|---|
| Client Id - Your QuickBooks clientId | string | Please enter the client Id. | True |
| Client Secret | securestring | Please enter the client secret. | True |
Throttling Limits
| Name | Calls | Renewal Period |
|---|---|---|
| API calls per connection | 100 | 60 seconds |
Actions
| Retrieve Jobcodes |
Retrieves a list of all jobcodes associated with your company, with optional filters to narrow down the results. |
| Retrieve Notifications |
Retrieves a list of notifications associated with your company, with filters to narrow down the results. |
| Retrieve Projects |
Retrieves a list of projects, with optional filters to narrow down the results. |
| Retrieve Timesheets |
Retrieves a list of all timesheets associated with your company, with filters to narrow down the results. |
| Retrieve Users |
Retrieves a list of all users associated with your company, with optional filters to narrow down the results. |
Retrieve Jobcodes
Retrieves a list of all jobcodes associated with your company, with optional filters to narrow down the results.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Jobcode Ids
|
ids | string |
Comma separated list of one or more jobcode ids |
|
|
Parent Ids
|
parent_ids | string |
Comma separated list of one or more jobcode parent_ids |
|
|
Name
|
name | string |
Starts matching from the beginning of the string. |
|
|
Type
|
type | string |
One of 'regular', 'pto', 'paid_break', 'unpaid_break', or 'all'. Default is 'regular'. |
|
|
Custom Fields
|
customfields | boolean |
true or false |
|
|
Modified Before
|
modified_before | string |
in ISO 8601 format (YYYY-MM-DDThh:mm:ss±hh:mm) |
|
|
Modified Since
|
modified_since | string |
in ISO 8601 format (YYYY-MM-DDThh:mm:ss±hh:mm). |
|
|
Supplemental Data
|
supplemental_data | string |
Indicates whether supplemental data should be returned. |
|
|
Per Page
|
per_page | integer |
Represents how many results you'd like to retrieve per request. |
|
|
Page
|
page | integer |
Represents the page of results you'd like to retrieve. |
|
|
Active
|
active | string |
'yes', 'no', or 'both'. |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
jobcodes
|
results.jobcodes | object |
jobcodes |
|
more
|
more | boolean |
more |
Retrieve Notifications
Retrieves a list of notifications associated with your company, with filters to narrow down the results.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Ids
|
ids | string |
Comma separated list of one or more notification ids you'd like to filter on |
|
|
Delivery Before
|
delivery_before | string |
in ISO 8601 format (YYYY-MM-DDThh:mm:ss±hh:mm) |
|
|
Delivery After
|
delivery_after | string |
in ISO 8601 format (YYYY-MM-DDThh:mm:ss±hh:mm) |
|
|
User ID
|
user_id | integer |
Only notifications linked to this user ID will be returned |
|
|
Msg Tracking ID
|
msg_tracking_id | string |
Tracking ID string of a notification. Only the notification with this msg_tracking_id will be returned. |
|
|
Per Page
|
per_page | integer |
Represents how many results you'd like to retrieve per request |
|
|
Page
|
page | integer |
Represents the page of results you'd like to retrieve |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
notifications
|
results.notifications | object |
notifications |
|
more
|
results.more | boolean |
more |
Retrieve Projects
Retrieves a list of projects, with optional filters to narrow down the results.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Ids
|
ids | string |
Comma-separated list of project ids. |
|
|
Jobcode Ids
|
jobcode_ids | string |
Comma-separated list of jobcode ids associated with a project. |
|
|
Parent Jobcode ID
|
parent_jobcode_id | integer |
Id of a project jobcode's parent to use for filtering |
|
|
Name
|
name | string |
Starts matching from the beginning of the string |
|
|
Active
|
active | string |
'yes', 'no', or 'both'. Default is 'yes'. |
|
|
By Jobcode assignment
|
by_jobcode_assignment | boolean |
If specified, only projects with a jobcode_id the user is assigned to will be returned |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
projects
|
results.projects | object |
projects |
|
jobcodes
|
supplemental_data.jobcodes | object |
jobcodes |
|
more
|
more | boolean |
more |
Retrieve Timesheets
Retrieves a list of all timesheets associated with your company, with filters to narrow down the results.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Ids
|
ids | string |
Comma separated list of one or more timesheet ids you'd like to filter on. |
|
|
Start Date
|
start_date | string |
YYYY-MM-DD formatted date. Any timesheets with a date falling on or after this date will be returned. |
|
|
End Date
|
end_date | string |
YYYY-MM-DD formatted date. Any timesheets with a date falling on or before this date will be returned. |
|
|
Jobcode Ids
|
jobcode_ids | string |
A comma-separated string of jobcode ids. |
|
|
Payroll Ids
|
payroll_ids | string |
A comma-separated string of payroll ids. |
|
|
User Ids
|
user_ids | string |
A comma-separated list of user ids. |
|
|
Group Ids
|
group_ids | string |
A comma-separated list of group ids. |
|
|
On the clock
|
on_the_clock | string |
'yes', 'no', or 'both'. Default is 'no |
|
|
Jobcode type
|
jobcode_type | string |
Only timesheets linked to a jobcode of the given type are returned. |
|
|
Modified Before
|
modified_before | string |
in ISO 8601 format (YYYY-MM-DDThh:mm:ss±hh:mm) |
|
|
Modified Since
|
modified_since | string |
Only timesheets modified since this date/time will be returned, in ISO 8601 format (YYYY-MM-DDThh:mm:ss±hh:mm). |
|
|
Supplemental Data
|
supplemental_data | string |
yes' or 'no'. Default is 'yes'. Indicates whether supplemental data should be returned. |
|
|
Per Page
|
per_page | integer |
Represents how many results you'd like to retrieve per request. |
|
|
Page
|
page | integer |
Represents the page of results you'd like to retrieve. |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
timesheets
|
results.timesheets | object |
timesheets |
|
more
|
more | boolean |
more |
|
jobcodes
|
supplemental_data.jobcodes | object |
jobcodes |
|
users
|
supplemental_data.users | object |
users |
|
customfields
|
supplemental_data.customfields | object |
customfields |
|
files
|
supplemental_data.files | object |
files |
Retrieve Users
Retrieves a list of all users associated with your company, with optional filters to narrow down the results.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Ids
|
ids | string |
Comma separated list of one or more user ids you'd like to filter on |
|
|
Not Ids
|
not_ids | string |
Comma separated list of the user ids you'd like to exclude. |
|
|
Employee Numbers
|
employee_numbers | string |
Comma separated list of one or more employee numbers you'd like to filter on. |
|
|
Usernames
|
usernames | string |
Comma separated list of one or more usernames you'd like to filter on. |
|
|
Group Ids
|
group_ids | string |
Comma separated list of one or more group ids you'd like to filter on. |
|
|
Not Group Ids
|
not_group_ids | string |
Comma separated list of the group ids you'd like to exclude. |
|
|
Payroll Ids
|
payroll_ids | string |
A comma-separated string of payroll ids. Only users with these payroll ids will be returned. |
|
|
Active
|
active | string |
'yes', 'no', or 'both'. Default is 'yes'. |
|
|
First Name
|
first_name | string |
Starts matching from the beginning of the string. |
|
|
Last Name
|
last_name | string |
Starts matching from the beginning of the string. |
|
|
Modified Before
|
modified_before | string |
in ISO 8601 format (YYYY-MM-DDThh:mm:ss±hh:mm). |
|
|
Modified Since
|
modified_since | string |
in ISO 8601 format (YYYY-MM-DDThh:mm:ss±hh:mm). |
|
|
Supplemental Data
|
supplemental_data | string |
yes' or 'no'. Default is 'yes'. Indicates whether supplemental data should be returned. |
|
|
Per Page
|
per_page | integer |
Represents how many results you'd like to retrieve per request |
|
|
Page
|
page | integer |
Represents the page of results you'd like to retrieve |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
users
|
results.users | object |
users |
|
more
|
more | boolean |
more |
|
jobcodes
|
supplemental_data.jobcodes | object |
jobcodes |
|
groups
|
supplemental_data.groups | object |
groups |