Import costs

Every day @ 12:00 we query the WFM Job costs endpoint to get all job costs.
WFM Job Costs Import (opens new window)

The Job list endpoint is: https://api.workflowmax.com/job.api/list)
The individual job endpint is: https://api.workflowmax.com/job.api/costs/

The SQL query to empty the costs database is:

TRUNCATE `Costs`

The query to add all costs to our database is:

INSERT INTO `Costs` (`db_id`,`jobID`,`billable`,`Total`) VALUES ('','$rowTaskRate[ID]','$activeJob->Billable',$costTotal)

This is the cron that triggers the script: Job costs import cron script (opens new window)