MSPBots WIKI : Crewhu Public Datasets
Here are the published or Alpha version Crewhu datasets that you can use to create the widgets and dashboards
In total, there are 9 publish/alpha Datasets
Name | Description | Created Date | Last updated | Fields |
---|---|---|---|---|
Crewhu User - API | ODS Dataset which generated from Crewhu User | Jan 21, 2022 | Jan 21, 2022 | ["id", "tenant_code", "other_id", "sync_time", "inactive", "firstname", "lastname", "hiredate", "picture", "location", "position", "department", "managed_locations", "managed_departments"] |
Crewhu Badge - API | ODS Dataset which generated from Crewhu Badge | Mar 10, 2022 | Mar 10, 2022 | ["id", "tenant_code", "other_id", "image_class", "image_file", "name", "description", "created_at", "updated_at", "inactive", "sync_time"] |
Crewhu BadgeHistory - API | ODS Dataset which generated from Crewhu BadgeHistory | Mar 10, 2022 | Mar 10, 2022 | ["id", "tenant_code", "other_id", "to_users", "badge", "badge_points", "date_given", "message", "from_user", "survey", "created_at", "updated_at", "badge_level", "date_cancelled", "mess_cancelled", "user_cancelled", "inactive", "sync_time"] |
Crewhu PrizeHistory - API | ODS Dataset which generated from Crewhu PrizeHistory | Mar 10, 2022 | Mar 10, 2022 | ["id", "tenant_code", "other_id", "status", "prize", "quantity", "date_redeem", "users", "points", "created_at", "updated_at", "sync_time"] |
Crewhu Prize - API | ODS Dataset which generated from Crewhu Prize | Mar 10, 2022 | Mar 10, 2022 | ["id", "tenant_code", "other_id", "taxable", "description", "points", "image", "created_at", "updated_at", "inactive", "sync_time"] |
Crewhu Survey - API | ODS Dataset which generated from Crewhu Survey | Mar 10, 2022 | Mar 10, 2022 | ["id", "tenant_code", "other_id", "survey_tags_customer", "survey_tags_company", "reviewed", "employees", "ip_address", "ticket_num", "rating", "survey_type_code", "customer_data_customer_id", "customer_data_customer_name", "customer_data_contact_email", "customer_data_contact_name", "customer_data_contact_phone", "created_at", "updated_at", "comment", "closed", "inactive", "summary", "rating_label", "sync_time"] |
Crewhu Survey Data | All of the surveys from CrewHu integration | Mar 25, 2022 | Apr 08, 2023 | ["id", "survey_id", "rating", "rating_text", "updated_at", "employee_id_list", "employee_list", "customer_tag_list", "company_tag_list", "reviewed", "created_at", "inactive", "closed_at", "survey_type", "ip_address", "ticket_number", "contact_phone", "contact", "customer_id", "contact_email", "company", "comment", "summary", "survey_completed", "ticket_id"] |
Crewhu Survey Employee Data | Surveys created in crewHu in the last 365 days. This dataset will then split out a survey for each employee on the survey, so if the survey has 5 employees, you'll see that survey 5 times. | Apr 28, 2022 | Dec 10, 2022 | ["id", "survey_id", "rating", "employee_id", "rating_text", "updated_at", "employee", "team", "location", "customer_tag_list", "company_tag_list", "reviewed", "created_at", "inactive", "closed_at", "survey_type", "ip_address", "ticket_number", "customer_data_contact_phone", "contact", "customer_data_customer_id", "contact_email", "company", "comment", "summary"] |
Crewhu User Badge History | This is a dataset that contains the details of the badges that have been awarded. And also the details of the users who received/awarded the badge. | Jun 28, 2023 | Jul 03, 2023 | ["id", "badge", "badge_points", "badge_level", "date_given", "message", "survey", "created_at", "updated_at", "date_cancelled", "mess_cancelled", "to_user_id", "from_user_id", "awarded_to", "awarded_by", "awarded_to_email", "awarded_by_email"] |