Copy ZenDesk data into MySQL db

Does what it says on the tin, for use in cron etc.

Written by @i1yaz Comissioned by @foshdafosh

Installation:

  • Run composer install
  • Run php artisan migrate
  • Create and edit .env as appropriate
  • Visit yourappdomain.com/key
  • Copy string into .env APP_KEY= variable
  • Visit yourappdomain.com/api/zendesk to load ZenDesk data into MySQL

Planned additions:

  • ZenDesk
    • Users
    • Identities
    • Organisations
    • Tickets
  • Xero
    • Contacts
    • Sales Invoices
    • Quotes
    • Items
    • Employee details
    • Staff Leave
    • Staff Timesheets
    • Users
  • Xero - History and Notes etc - Ideally need a way to manually load all the notes, history and other specific data for a specific ID, for these endpoints:
    • Contacts
    • Sales Invoices
      • Online Invoice
      • Line Items
      • Repeating Invoices
    • Quotes
    • Items
  • Date Dimension regeneration
    • Template
    • Use first and last dates in available data as start and end (SELECT rng.EarliestDate, rng.LatestDate FROM dates_range AS rng;)
    • Create dates_holidays table, and automatically populate using this file
  • ProcessSt
    • Users
    • Templates
    • Checklists
    • Assignments
  • TeamViewer
  • Metis (API in Beta)
    • Channels
    • Customers
    • Calls
    • Invoices
  • Gandi
    • Domains
    • LiveDNS
    • Email
    • Billing
    • Organisation
    • Templates
  • Uptime Robot
    • Monitors
    • Alert Contacts
    • Maintainance Windows
    • Public Status Pages
  • WHM / cPanel
  • GoCardless
    • Customers
    • Payments
    • Plans
    • Payouts
    • Events
  • Square
  • Mailchimp
  • MySQL Import
    • Import tables from multiple MySQL databases, adding a prefix to tables (db1_mytable, db2_thattable etc) for each database
  • Denormalise data using Views
  • Clockify - merge original project into this one
  • eBay
  • Use webhooks etc to keep data up to date during the day
    • ZenDesk
    • Xero
    • ProcessSt
    • Metis
    • Uptime Robot