共用方式為


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
Email 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