Reactor

7shifts

Connectors · Updated May 22, 2025

Overview

This document guides you through setting up and using the 7shifts connector within the Reactor Data platform. This connector provides a robust and efficient way to extract your data from 7shifts and load it into your data warehouse or other chosen destination.

Key Capabilities

  • Streamlined Data Ingestion: Easily pull critical data from 7shifts directly into Reactor.
  • Flexible Configuration: Tailor your data extraction process using Reactor's intuitive setup wizard.
  • Automated Scheduling: Set up recurring data synchronization to keep your insights fresh.
  • Supported Data Entities: Access key data entities such as:
    • companies
    • locations
    • departments
    • roles
    • users
    • wages
    • assignments
    • location_assignments
    • department_assignments
    • role_assignments
    • time_punches
    • shifts

Setting Up the 7shifts Connector in Reactor

Prerequisites

Before you begin, ensure you have:

  • An active account with 7shifts and the necessary permissions to access its data.
  • An Access Token from 7shifts.
  • An active Reactor Data workspace.

Connector Setup Wizard Steps

Follow these steps in the Reactor Data UI to configure your 7shifts connector:

Step 1: Connector Configuration

  1. Log in to Reactor Data.
  2. Navigate to Sources and click + New Source.
  3. Select the 7shifts from the available connectors.
  4. You will be prompted to provide the following details:
    • Connection Version*: This is typically 0.0.1 (or the latest version compatible).
    • Connector Endpoint*: Select the relevant endpoint from the dropdown.
    • Scope*: Enter the scope required for data access (e.g., specific permissions or data access levels).
    • Display Name*: Provide a user-friendly name for this connection in Reactor (e.g., "7shifts Workforce Data"). This name will also be used to generate the unique SCID (e.g., EXAMPLE 33:[CONNECTOR NAME]::).

Step 2: Parameter Configuration

Next, define the parameters for your data extraction:

  • Replication start date*: Specify the UTC date and time in YYYY-MM-DDTHH:MM:SSZ format (e.g., 2017-01-25T00:00:00Z). Only data generated after this date will be retrieved. This corresponds to the start_date parameter in 7shifts configuration.
  • Lookback Window in days*: Enter a number of days (e.g., 0). When set, the connector will re-export data from the past N days in every sync. This is useful for data that updates frequently after creation.
  • Data request time increment in days*: Enter a number of days (e.g., 365). This sets the time window for each API request. A larger value means fewer requests and potentially faster syncs, but less frequent state persistence.

Step 3: Auth Configuration

Provide the necessary authentication details:

  • Auth Key*: Enter your 7shifts Access Token. You can generate this by navigating to "Company Settings", then "Developer Tools" in your 7shifts account, and under the Access Token Section, clicking "Create Access Token".

Step 4: Schedule Configuration

Define how often Reactor should collect data:

  • Data collection schedule (Cron Expression)*: Select a cron expression from the dropdown or manually enter one (e.g., 0 * * * * for every hour).

Final Screen (Summary)

The final screen will summarize your configuration, including:

  • Display Name
  • Versions
  • Endpoint
  • Scope
  • Event Scid
  • Auth Configuration
  • Parameter Configuration
  • Minimum updated_at: (If this is a user-configurable field in the original, describe it. Otherwise, omit or note as system-derived.)
  • Schedule Configuration
  • Cron Expression

Data Entities Available for Extraction

The 7shifts connector provides access to the following data entities (equivalent to Airbyte "streams"):

  • companies: Represents information about companies within 7shifts.
  • locations: Contains data regarding specific locations associated with a company.
  • departments: Details different departments within the company structure.
  • roles: Provides information about the various roles employees can hold.
  • users: Contains employee user data.
  • wages: Represents wage information for employees.
  • assignments: Details various types of assignments.
  • location_assignments: Specific assignments related to locations.
  • department_assignments: Assignments organized by department.
  • role_assignments: Assignments based on employee roles.
  • time_punches: Records of employee time punches.
  • shifts: Information about scheduled employee shifts.

Data Model (Common Fields)

Below are common data types and considerations for fields extracted by this connector:

Integration Type (Source System) Reactor Data Type
string STRING
number NUMBER
array ARRAY
object OBJECT
boolean BOOLEAN
date/datetime DATETIME
integer INTEGER

Important Considerations

  • Data Volume & Performance: Be mindful of 7shifts' API rate limits and data quotas. While Reactor is optimized for efficient transfers, very high volumes or frequent requests can impact performance.
  • Data Latency & Accuracy: The time_punches and shifts data entities support incremental synchronization, allowing for more frequent and efficient updates. Other entities like wages, assignments, location_assignments, department_assignments, and role_assignments support full data refreshes.
  • Sync Modes: This connector supports various sync modes, allowing for full data refreshes or incremental updates.