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

1. Signin to Daton

2. Select Impact from Integrations page

3. Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later

4. Provide your When I Work developer key, email and password. Click here to learn more

5. After providing the details to authorize Daton to periodically extract data from Impact.

6. Post successful authentication you will be prompted to choose from the list of available tables

7. Then select all required fields for each table

8. Submit the integration.

Workflow

1. 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

2. Users would be able to edit/pause/re-activate/delete integration anytime

3. 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

fullname	type
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

fullname	type
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

fullname	type
id	NUMERIC
account_id	NUMERIC
login_id	NUMERIC
timezone_id	NUMERIC
created_by	NUMERIC
role	NUMERIC
is_payroll	BOOLEAN
is_trusted	NUMERIC
type	NUMERIC
email	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

fullname	type
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

fullname	type
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

fullname	type
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