MSPBots WIKI : Bamboo HR Public Datasets
Here are the published or Alpha version Bamboo HR datasets that you can use to create the widgets and dashboards
In total, there are 16 publish/alpha Datasets
| Name | Description | Created Date | Last updated | Fields |
|---|---|---|---|---|
| Bamboo HR Employees Directory - API | ODS Dataset which generated from Bamboo HR Employees Directory | Nov 02, 2022 | Nov 02, 2022 | ["id", "tenant_code", "other_id", "sync_time", "display_name", "first_name", "last_name", "preferred_name", "job_title", "work_phone", "mobile_phone", "work_email", "department", "location", "division", "linked_in", "instagram", "pronouns", "work_phone_extension", "supervisor", "photo_uploaded", "photo_url", "can_upload_photo"] |
| Bamboo HR Employees Training - API | ODS Dataset which generated from Bamboo HR Employees Training | Nov 02, 2022 | Nov 02, 2022 | ["id", "tenant_code", "other_id", "sync_time", "employee_id", "completed", "notes", "instructor", "credits", "hours", "cost", "type"] |
| Bamboo HR Users - API | ODS Dataset which generated from Bamboo HR Users | Apr 11, 2023 | Apr 11, 2023 | ["id", "tenant_code", "sync_time", "other_id", "employee_id", "first_name", "last_name", "email", "status", "last_login"] |
| Bamboo HR Goals - API | ODS Dataset which generated from Bamboo HR Goals | Apr 11, 2023 | Apr 11, 2023 | ["id", "tenant_code", "sync_time", "other_id", "title", "description", "percent_complete", "group_description", "aligns_with_option_id", "shared_with_employee_ids", "due_date", "completion_date", "last_changed_date_time", "status", "employee_id"] |
| Bamboo HR Goals - API | ODS Dataset which generated from Bamboo HR Goals | Apr 11, 2023 | Apr 11, 2023 | ["id", "tenant_code", "sync_time", "other_id", "title", "description", "percent_complete", "group_description", "aligns_with_option_id", "shared_with_employee_ids", "due_date", "completion_date", "last_changed_date_time", "status", "employee_id"] |
| Bamboo HR Users - API | ODS Dataset which generated from Bamboo HR Users | Apr 11, 2023 | Apr 11, 2023 | ["id", "tenant_code", "sync_time", "other_id", "employee_id", "first_name", "last_name", "email", "status", "last_login"] |
| Bamboo HR Golas Comments - API | ODS Dataset which generated from Bamboo HR Golas Comments | Apr 11, 2023 | Apr 11, 2023 | ["id", "tenant_code", "sync_time", "employee_id", "goal_id", "other_id", "author_user_id", "created_at", "text", "can_edit", "can_delete"] |
| Bamboo HR Whos Out - API | ODS Dataset which generated from Bamboo HR Whos Out | Jul 13, 2023 | Jul 14, 2023 | ["id", "tenant_code", "other_id", "employee_id", "name", "start", "ends", "type", "sync_time", "number_of_days", "out_to_day"] |
| Bamboo HR Time Tracking - API | ODS Dataset which generated from Bamboo HR Time Tracking | Aug 29, 2023 | Aug 29, 2023 | ["id", "tenant_code", "sync_time", "other_id", "employee_id", "type", "date_time", "start_time", "end_time", "timezone", "hours", "note", "project_info"] |
| Bamboo HR Time Tracking - Layered | This is a layered template dataset that lists the timesheets for employees as well as determines if the said employee is on leave for the current day. The main layer contains the timesheets that were entered in the last 14 days. Sublayer: 210 days - timesheets entered in the last 210 days | Sep 07, 2023 | Sep 12, 2023 | ["timesheet_id", "employee_id", "employee_fullname", "employee_status", "type", "start_time", "end_time", "hours", "timezone", "note", "project_info", "date_time", "is_on_leave", "leave_start", "leave_end", "filed_leave_type", "division"] |
| Bamboo HR Jobs - API | ODS Dataset which generated from Bamboo HR Jobs | Dec 25, 2023 | Dec 25, 2023 | ["id", "tenant_code", "other_id", "title_id", "title_label", "posted_date", "posted_date_utc", "location_id", "location_label", "department_id", "department_label", "status_id", "status_label", "new_applicants_count", "active_applicants_count", "total_applicants_count", "posting_url", "sync_time"] |
| Bamboo HR Hiring Leads - API | ODS Dataset which generated from Bamboo HR Hiring Leads | Dec 25, 2023 | Dec 25, 2023 | ["id", "tenant_code", "employee_id", "preferred_full_name", "sync_time"] |
| Bamboo HR Company Locations - API | ODS Dataset which generated from Bamboo HR Company Locations | Dec 25, 2023 | Dec 25, 2023 | ["id", "tenant_code", "other_id", "sync_time", "name", "description", "city", "state_id", "state_name", "state_abbrev", "state_iso_code", "country_id", "country_name", "country_iso_code", "zipcode", "address_line1", "address_line2", "phone"] |
| Bamboo HR Statuses - API | ODS Dataset which generated from Bamboo HR Statuses | Dec 25, 2023 | Dec 25, 2023 | ["id", "tenant_code", "other_id", "sync_time", "code", "description", "enabled", "manageable", "name", "translated_name"] |
| BambooHR Applications - API | ODS Dataset which generated from BambooHR Applications | Jan 11, 2024 | Jan 11, 2024 | ["id", "tenant_code", "sync_time", "other_id", "applied_date", "status_id", "rating", "job_id", "applicant_first_name", "applicant_last_name", "applicant_email", "applicant_phone_number", "applicant_address_line1", "applicant_address_city", "applicant_address_zipcode", "applicant_address_country", "applicant_available_start_date", "job_hiring_lead_employee_id", "job_hiring_lead_job_title_id", "job_hiring_lead_job_title_label", "desired_salary"] |
| BambooHR Application Details | This dataset will list all of your BambooHR applications and details. | Jan 15, 2024 | Jan 15, 2024 | ["application_id", "application_date", "applicant_first_name", "applicant_last_name", "applicant_fullname", "applicant_email", "applicant_phone_number", "applicant_address_line1", "applicant_address_city", "applicant_address_country", "applicant_address_zipcode", "applicant_available_start_date", "job_hiring_lead_fullname", "job_hiring_lead_job_title_label", "applying_for", "desired_salary", "application_rating", "status_code", "status_name", "department_label"] |