Import quotes

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

The quotes list endpoint is: https://api.workflowmax.com/quote.api/list

The SQL query to empty the quotes database is:

TRUNCATE `Quotes`

The query to add all quotes to our database is:

INSERT INTO `Quotes` (`db_id`,`ID`, `Cost`, `Total`) VALUES ('', '$quoteID', '$quoteCost', '$quoteAmount')

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