Import invoices

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

The invoices list endpoint is: https://api.workflowmax.com/invoice.api/list
The individual invoice endpoint is: https://api.workflowmax.com/invoice.api/get/

The SQL query to empty the invoice database is:

TRUNCATE `Invoices`

The SQL query to empty the invoice tasks database is:

TRUNCATE `invoiceTasks`

The query to add all invoices to our database is:

INSERT INTO `Invoices` (`db_id`,`InternalID`, `ID`, `Type`, `JobText`, `Description`, `Date`, `DueDate`, `Amount`, `AmountTax`, `AmountIncludingTax`, `AmountPaid`, `AmountOutstanding`, `Status`, `ClientID`, `ClientName`, `ContactID`, `ContactName`) VALUES ('', '$invoice->InternalID', '$invoice->ID', '$invoice->Type', '$invoiceText', '$invoiceDescription', '$invoice->Date', '$invoice->DueDate', '$invoice->Amount', '$invoice->AmountTax', '$invoice->AmountIncludingTax', '$invoice->AmountPaid', '$invoice->AmountOutstanding', '$invoice->Status', '$client->ID', '$clientName', '$contactID', '$contactName')

The query to add all invoice tasks to our database is:

INSERT INTO `invoiceTasks` (`db_id`, `JobID`, `Name`, `taskID`, `invID`, `Description`, `Minutes`, `Amount`) VALUES ('', '$activeJob->ID', '$dept', '$task->ID', '$invoice->ID', '$taskDesc', '$task->Minutes', '$task->Amount')

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