MSPBots WIKI : QuickBooks Time TSheets Public Datasets
Here are the published or Alpha version QuickBooks Time TSheets datasets that you can use to create the widgets and dashboards
In total, there are 6 publish/alpha Datasets
Name | Description | Created Date | Last updated | Fields |
---|---|---|---|---|
TSheets Timesheets - API | ODS Dataset which generated from TSheets Timesheets | Jan 06, 2022 | Jan 10, 2022 | ["id", "tenant_code", "sheet_id", "sheet_user_id", "created_by_user_id", "last_modified", "notes", "start_time", "end_time", "one_day", "duration", "sync_time", "on_the_clock", "tz", "update_time", "create_time"] |
TSheets Users - API | ODS Dataset which generated from TSheets Users | Jan 06, 2022 | Jan 10, 2022 | ["id", "tenant_code", "sheet_user_id", "sync_time", "first_name", "last_name", "email", "username", "creator", "created", "last_modified", "last_active", "active"] |
TSheets Time In and Out Details | This dataset will return 30 days' worth of data. It will show you the total duration per user and their status (In and Out) | Aug 31, 2022 | Dec 10, 2022 | ["full_name", "first_name", "last_name", "email", "username", "last_active", "active", "sheet_user_id", "one_day", "start_time", "end_time", "duration_mins", "duration_hrs", "status", "log_count"] |
TSheets Effective Settings - API | ODS Dataset which generated from TSheets Effective Settings | Feb 10, 2023 | Feb 10, 2023 | ["id", "tenant_code", "sync_time", "general", "alerts", "approvals", "bar_codes", "breaks", "dcaa", "dialin", "files", "invoicing", "location_aware", "geofence", "mobile_app_integrations", "mobile_app_settings", "reminders", "oii_migration", "payrate_engine", "projects", "pto", "quickbooks", "request_for_access", "restapi", "rounding", "schedule", "sms", "sounds", "customfields", "time_entry", "time_off_requests", "toodledo", "xero", "zenpayroll"] |
TSheets Customfielditem User Filters - API | ODS Dataset which generated from TSheets Customfielditem User Filters | Feb 10, 2023 | Feb 10, 2023 | ["id", "tenant_code", "other_id", "sync_time", "type", "last_modified", "filtered_customfielditems"] |
TSheets Jobcodes - API | ODS Dataset which generated from TSheets Jobcodes | Jun 27, 2023 | Jun 27, 2023 | ["id", "tenant_code", "sync_time", "other_id", "active", "last_modified", "parent_id", "assigned_to_all", "type", "billable", "billable_rate", "short_code", "name", "created", "has_children", "required_customfields", "filtered_customfielditems", "locations", "geofence_config_id", "project_id"] |