Infusionsoft MySQL


(Todd Bryant) #1

I am looking for a way to review and analyze Infusion data better than some of the payment reports and etc. are able to.
Wandering if possible to export Infusion data to MySQL and pull there via php.


(John Borelli) #2

This would be a better question for the API forum but I’m a developer so you’re in luck :stuck_out_tongue_winking_eye:

You are limited to the exports in your app to csv files (which can be used to import into MySQL database) or by using the api to pull data from each table yourself (see table schema):

https://developer.infusionsoft.com/docs/table-schema/


(Nicholas Trecina) #3

Hi @Todd_Bryant, as John mentioned you can do bulk data pulls with the REST API and XML-RPC for the remaining data that isn’t available via REST. We have also been introducing Rest Hooks so that you can be notified as resources are modified. Here is the current complete list of supported Rest Hooks with more to come soon.

[
  "contact.add",
  "contact.delete",
  "contact.edit",
  "contactGroup.add",
  "contactGroup.applied",
  "contactGroup.delete",
  "contactGroup.edit",
  "contactGroup.removed",
  "invoice.add",
  "invoice.delete",
  "invoice.edit",
  "opportunity.add",
  "opportunity.delete",
  "opportunity.stage_move",
  "order.add",
  "order.delete",
  "order.edit",
  "product.add",
  "product.delete",
  "product.edit"
]

(Jordan Novak) #4

Novak Solutions provides an out-of-the-box solution to do exactly this. Everything Infusionsoft makes available in the API is pulled into MySQL database and kept up to date so that you can run custom reports in whatever framework you want.

https://pages.novaksolutions.com/data-warehouse-video