Import staff

Every day @ 12:00 we query the staff endpoint to get all staff.
staff Import (opens new window)

The staff list endpoint is: https://api.workflowmax.com/staff.api/list

The SQL query to empty the staff database is:

TRUNCATE `Staff`

The query to add all staff to our database is:

INSERT INTO `Staff` (`db_id`,`staff_id`, `name`,`BillableRate` ) VALUES ('', '$staffID', '$staffName', '$billableRate')

This is the cron that triggers the script.
NOTE: Deleted cron for now as need to change script to only import new staff members rather than drop and re-import