Querying InfusionSoft data with Power Query

Is it possible to query Infusion data or reports of the data by using Power Query through the API? That certainly would simplify custom reporting.

If so, could you point me at some documentation that describes the process? (I’m a user. I need all the help I can get!)


The XMLRPC API’s DataService is the best querying you can get through the API. Using the OrderBy option will let you get a bit more selective, but the querying is still extremely limited.

There are third party tools that handle pulling the data out of Infusionsoft for you and let you use SQL queries to build your reports.