When I Work

When I Work ETL connector for data replication

PreviousRelease Notes NextXero

Last updated 1 year ago

Snapshot

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

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

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

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

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

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