7shifts Lite
7shifts is a team management software for restaurants.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | AVAILABILITY_REASON, COMPANY, COMPANY_INACTIVE_REASON, COMPANY_LABOUR_SETTING, DAY_PART_SETTING, DEPARTMENT, LOCATION, LOG_BOOK_CATEGORY, SHIFT, TASK_LIST_TEMPLATE, TASK_MANAGEMENT_SETTING, TIME_PUNCH, and USERS tables. |
| History mode | ||
| Custom data | ||
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking | ||
| Authorization via API | check |
Setup guide
Follow our step-by-step 7shifts setup guide to connect 7shifts with your destination using Fivetran connectors.
Sync overview
To capture new records, we incrementally sync the following tables and their child tables:
AVAILABILITYDAILY_SALES_LABORDAILY_STATSDEPARTMENTENGAGE_OVERVIEWEVENTLOG_BOOK_COMMENTLOG_BOOK_POSTRECEIPTROLESHIFTSHIFT_FEEDBACKTASK_LISTTASK_LIST_DAILY_SUMMARYTIME_OFFTIME_PUNCHUSERSUSER_WAGE
We re-import the remaining tables in every sync to capture updates and deletes.
Schema information
This schema applies to all 7shifts connectors.
Explore 7shifts schema ERD