When I Work
When I Work ETL connector for data replication
Snapshot
Features
Details
Release Status
Released
Source API Version
Table Selection
Yes
Column Selection
Yes
Edit Integration
Yes
Replication Type Selection
No
Authentication Parameters
When I Work developer key When I Work email When I Work password
Replication Type
Key based Replication
Replication Key
DATE NA
Suggested Replication Frequency
24 hrs
Tables/APIs Supported
List Times
Locations
List Users
List Shift
Position
List Payroll
Integrate When I Work with Daton
Signin to Daton
Select Impact from Integrations page
Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later
Provide your When I Work developer key, email and password. Click here to learn more
After providing the details to authorize Daton to periodically extract data from Impact.
Post successful authentication you will be prompted to choose from the list of available tables
Then select all required fields for each table
Submit the integration.
Workflow
Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse
Users would be able to edit/pause/re-activate/delete integration anytime
Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
When I Work Data
List Times
Purpose: Retrieve a list of all shifts
Source API Documentation: https://apidocs.wheniwork.com/external/index.html#tag/Times
Replication: Key-Based Replication
Replication Key: LastRunTime
Fields
id
NUMERIC
account_id
NUMERIC
user_id
NUMERIC
creator_id
NUMERIC
position_id
NUMERIC
location_id
NUMERIC
site_id
NUMERIC
shift_id
NUMERIC
start_time
TIMESTAMP
end_time
TIMESTAMP
notes
STRING
length
NUMERIC
hourly_rate
NUMERIC
alert_type
NUMERIC
is_approved
BOOLEAN
modified_by
NUMERIC
sync_id
STRING
sync_hash
STRING
updated_at
TIMESTAMP
created_at
TIMESTAMP
break_hours
NUMERIC
is_alerted
BOOLEAN
_daton_user_id
NUMERIC
_daton_batch_runtime
NUMERIC
_daton_batch_id
NUMERIC
Locations
Purpose: Retrieves all the schedule in a account
Source API Documentation: https://apidocs.wheniwork.com/external/index.html#tag/Schedules-(Locations)/paths/~12~1locations/get
Replication: Key-Based Replication
Replication Key: NA
Fields
id
NUMERIC
account_id
NUMERIC
is_default
NUMERIC
name
STRING
sort
NUMERIC
max_hours
NUMERIC
address
STRING
latitude
NUMERIC
longitude
NUMERIC
place_id
NUMERIC
place_confirmed
BOOLEAN
ip_address
STRING
created_at
TIMESTAMP
updated_at
TIMESTAMP
is_deleted
BOOLEAN
deleted_at
STRING
updated_by
STRING
coordinates
STRING
radius
NUMERIC
place
RECORD
_daton_user_id
NUMERIC
_daton_batch_runtime
NUMERIC
_daton_batch_id
NUMERIC
place.id
NUMERIC
place.business_name
STRING
place.address
STRING
place.street_name
STRING
place.street_number
STRING
place.locality
STRING
place.sub_locality
STRING
place.region
STRING
place.postal_code
STRING
place.country
STRING
place.latitude
NUMERIC
place.longitude
NUMERIC
place.place_type
STRING
place.place_id
STRING
place.updated_at
TIMESTAMP
place.updated_by
STRING
place.formatted_phone_number
STRING
place.international_phone_number
STRING
place.website
STRING
List Users
Purpose: Fetches all the users
Source API Documentation: https://apidocs.wheniwork.com/external/index.html#tag/Users
Replication: Key-Based Replication
Replication Key: LastRunTime
Fields
id
NUMERIC
account_id
NUMERIC
login_id
NUMERIC
timezone_id
NUMERIC
created_by
NUMERIC
role
NUMERIC
is_payroll
BOOLEAN
is_trusted
NUMERIC
type
NUMERIC
STRING
first_name
STRING
last_name
STRING
phone_number
STRING
employee_code
STRING
activated
BOOLEAN
is_hidden
BOOLEAN
uuid
STRING
notes
STRING
is_private
BOOLEAN
hours_preferred
NUMERIC
hours_max
NUMERIC
hourly_rate
NUMERIC
alert_settings
RECORD
reminder_time
NUMERIC
sleep_start
TIME
sleep_end
TIME
is_onboarded
BOOLEAN
last_login
STRING
terminated_at
STRING
notified_at
STRING
invited_at
TIMESTAMP
created_at
TIMESTAMP
updated_at
TIMESTAMP
deleted_at
STRING
is_deleted
BOOLEAN
delete_reason
STRING
avatar_key
STRING
employment_type
STRING
middle_name
STRING
start_date
STRING
is_active
BOOLEAN
password
BOOLEAN
country_id
NUMERIC
c2dm_auth_key
NUMERIC
migration_id
NUMERIC
affiliate
NUMERIC
infotips
STRING
timezone_name
STRING
avatar
RECORD
positions
STRING
locations
STRING
position_rates
RECORD
position_quality
RECORD
sort
RECORD
deletion_queued
BOOLEAN
_daton_user_id
NUMERIC
_daton_batch_runtime
NUMERIC
_daton_batch_id
NUMERIC
dismissed_at
TIMESTAMP
country_code
STRING
is_internal_login
BOOLEAN
alert_settings.timeoff
RECORD
alert_settings.timeoff.sms
BOOLEAN
alert_settings.timeoff.email
BOOLEAN
alert_settings.swaps
RECORD
alert_settings.swaps.sms
BOOLEAN
alert_settings.swaps.email
BOOLEAN
alert_settings.schedule
RECORD
alert_settings.schedule.sms
BOOLEAN
alert_settings.schedule.email
BOOLEAN
alert_settings.reminders
RECORD
alert_settings.reminders.sms
BOOLEAN
alert_settings.reminders.email
BOOLEAN
alert_settings.availability
RECORD
alert_settings.availability.sms
BOOLEAN
alert_settings.availability.email
BOOLEAN
alert_settings.new_employee
RECORD
alert_settings.new_employee.sms
BOOLEAN
alert_settings.new_employee.email
BOOLEAN
alert_settings.attendance
RECORD
alert_settings.attendance.sms
BOOLEAN
alert_settings.attendance.email
BOOLEAN
alert_settings.payroll
RECORD
alert_settings.payroll.sms
BOOLEAN
alert_settings.payroll.email
BOOLEAN
alert_settings.hire
RECORD
alert_settings.hire.sms
BOOLEAN
alert_settings.hire.email
BOOLEAN
alert_settings.workchat
RECORD
alert_settings.workchat.alerts
BOOLEAN
alert_settings.workchat.badge_icon
BOOLEAN
alert_settings.workchat.in_app
BOOLEAN
alert_settings.reporting
RECORD
alert_settings.reporting.sms
BOOLEAN
alert_settings.reporting.email
BOOLEAN
alert_settings.shift_bidding
RECORD
alert_settings.shift_bidding.sms
BOOLEAN
alert_settings.shift_bidding.email
BOOLEAN
alert_settings.workplace_alerts
RECORD
alert_settings.workplace_alerts.sms
BOOLEAN
alert_settings.workplace_alerts.email
BOOLEAN
alert_settings.absences
RECORD
alert_settings.absences.sms
BOOLEAN
alert_settings.absences.email
BOOLEAN
alert_settings.ot_alerts
RECORD
alert_settings.ot_alerts.sms
BOOLEAN
alert_settings.ot_alerts.email
BOOLEAN
alert_settings.shift-bidding
RECORD
alert_settings.shift-bidding.sms
BOOLEAN
alert_settings.shift-bidding.email
BOOLEAN
avatar.url
STRING
avatar.size
STRING
position_rates._385109
NUMERIC
position_rates._0052128
NUMERIC
position_rates._0507330
NUMERIC
position_rates._0507331
NUMERIC
position_rates._0507332
NUMERIC
position_rates._0507333
NUMERIC
position_rates._0507334
NUMERIC
position_rates._0507335
NUMERIC
position_rates._0646340
NUMERIC
position_rates._1038147
NUMERIC
position_rates._1038148
NUMERIC
position_rates._daton_pre_2385109
NUMERIC
position_rates._daton_pre_10052128
NUMERIC
position_rates._daton_pre_10507330
NUMERIC
position_rates._daton_pre_10507331
NUMERIC
position_rates._daton_pre_10507332
NUMERIC
position_rates._daton_pre_10507333
NUMERIC
position_rates._daton_pre_10507334
NUMERIC
position_rates._daton_pre_10507335
NUMERIC
position_rates._daton_pre_10646340
NUMERIC
position_rates._daton_pre_11038147
NUMERIC
position_rates._daton_pre_11038148
NUMERIC
position_rates._daton_pre_2383816
NUMERIC
position_rates._daton_pre_11008917
NUMERIC
position_rates._daton_pre_2382484
NUMERIC
position_rates._daton_pre_2383795
NUMERIC
position_rates._daton_pre_10262243
NUMERIC
position_quality._385109
NUMERIC
position_quality._0052128
NUMERIC
position_quality._0507330
NUMERIC
position_quality._0507331
NUMERIC
position_quality._0507332
NUMERIC
position_quality._0507333
NUMERIC
position_quality._0507334
NUMERIC
position_quality._0507335
NUMERIC
position_quality._0646340
NUMERIC
position_quality._1038147
NUMERIC
position_quality._1038148
NUMERIC
position_quality._daton_pre_2385109
NUMERIC
position_quality._daton_pre_10052128
NUMERIC
position_quality._daton_pre_10507330
NUMERIC
position_quality._daton_pre_10507331
NUMERIC
position_quality._daton_pre_10507332
NUMERIC
position_quality._daton_pre_10507333
NUMERIC
position_quality._daton_pre_10507334
NUMERIC
position_quality._daton_pre_10507335
NUMERIC
position_quality._daton_pre_10646340
NUMERIC
position_quality._daton_pre_11038147
NUMERIC
position_quality._daton_pre_11038148
NUMERIC
position_quality._daton_pre_2383816
NUMERIC
position_quality._daton_pre_11008917
NUMERIC
position_quality._daton_pre_2382484
NUMERIC
position_quality._daton_pre_2383795
NUMERIC
position_quality._daton_pre_10262243
NUMERIC
sort._179391
NUMERIC
sort._232098
NUMERIC
sort._daton_pre_1179391
NUMERIC
sort._daton_pre_1232098
NUMERIC
sort._daton_pre_1180252
NUMERIC
List Shifts
Purpose: Returns list of all shifts
Source API Documentation: https://apidocs.wheniwork.com/external/index.html#tag/Shifts/paths/~12~1shifts/get
Replication: Key-Based Replication
Replication Key: LastRunTime
Fields
id
NUMERIC
account_id
NUMERIC
user_id
NUMERIC
location_id
NUMERIC
position_id
NUMERIC
site_id
NUMERIC
start_time
TIMESTAMP
end_time
TIMESTAMP
break_time
NUMERIC
color
STRING
notes
STRING
alerted
BOOLEAN
shiftchain_key
STRING
published
BOOLEAN
published_date
TIMESTAMP
notified_at
TIMESTAMP
instances
NUMERIC
created_at
TIMESTAMP
updated_at
TIMESTAMP
acknowledged
NUMERIC
acknowledged_at
TIMESTAMP
creator_id
NUMERIC
is_open
BOOLEAN
actionable
BOOLEAN
block_id
NUMERIC
requires_openshift_approval
BOOLEAN
openshift_approval_request_id
NUMERIC
is_trimmed
BOOLEAN
is_approved_without_time
BOOLEAN
_daton_user_id
NUMERIC
_daton_batch_runtime
NUMERIC
_daton_batch_id
NUMERIC
Positions
Purpose: Retrieves all the positions
Source API Documentation: https://apidocs.wheniwork.com/external/index.html#tag/Positions/paths/~12~1positions/get
Replication: Key-Based Replication
Replication Key: NA
Fields
id
NUMERIC
account_id
NUMERIC
name
STRING
color
STRING
sort
NUMERIC
created_at
TIMESTAMP
updated_at
TIMESTAMP
is_deleted
BOOLEAN
updated_by
STRING
tips_tracking
NUMERIC
_daton_user_id
NUMERIC
_daton_batch_runtime
NUMERIC
_daton_batch_id
NUMERIC
List Payroll
Purpose: Retrieves listing of payroll periods
Source API Documentation: https://apidocs.wheniwork.com/external/index.html#tag/Payrolls/paths/~12~1payrolls/get
Replication: Key-Based Replication
Replication Key: LastRunTime
Fields
id
NUMERIC
account_id
NUMERIC
creator_id
NUMERIC
start_date
TIMESTAMP
end_date
TIMESTAMP
settings
RECORD
offset
TIME
notes
STRING
is_edited
NUMERIC
is_closed
BOOLEAN
closed_at
DATETIME
is_finalized
BOOLEAN
finalized_at
TIMESTAMP
created_at
TIMESTAMP
updated_at
TIMESTAMP
updated_by
STRING
_daton_user_id
NUMERIC
_daton_batch_runtime
NUMERIC
_daton_batch_id
NUMERIC
user_id
NUMERIC
position_id
NUMERIC
location_id
NUMERIC
site_id
NUMERIC
shift_id
NUMERIC
start_time
TIMESTAMP
end_time
TIMESTAMP
length
NUMERIC
hourly_rate
NUMERIC
alert_type
NUMERIC
is_approved
BOOLEAN
modified_by
NUMERIC
sync_id
STRING
sync_hash
STRING
break_hours
NUMERIC
is_alerted
BOOLEAN
settings.enabled
BOOLEAN
settings.timesheets
BOOLEAN
settings.type
NUMERIC
settings.hours_max
NUMERIC
settings.hours_max_enabled
BOOLEAN
settings.hours_max_daily
NUMERIC
settings.hours_max_daily_enabled
BOOLEAN
settings.hours_dot_daily
NUMERIC
settings.hours_dot_daily_enabled
BOOLEAN
settings.ot_multiplier
NUMERIC
settings.dbl_multiplier
NUMERIC
settings.work_day_start
TIME
settings.adp_enabled
BOOLEAN
settings.adp_viewable
BOOLEAN
settings.is_onboarded
BOOLEAN
settings.ot_alerts_clockin
BOOLEAN
settings.ot_alerts_clockout
BOOLEAN
settings.ot_alerts_within
NUMERIC
settings.reveal_attendance
BOOLEAN
settings.use_sow_for_ot
BOOLEAN
settings.max_enforcement
RECORD
settings.max_enforcement.enabled
BOOLEAN
settings.rounding
RECORD
settings.rounding.enabled
BOOLEAN
settings.rounding.minuteIncrement
NUMERIC
settings.tips_tracking
BOOLEAN
settings.ot_prevention
RECORD
settings.ot_prevention.enabled
BOOLEAN
settings.ot_prevention.prevent_all
BOOLEAN
settings.ot_prevention.allow_up_to
NUMERIC
Last updated