# Querying InfusionSoft data with Power Query

**URL:** <https://integration.keap.com/t/querying-infusionsoft-data-with-power-query/49344>\
**Category:** API Q&A\
**Created:** [August 13, 2018, 5:23pm UTC](https://integration.keap.com/t/querying-infusionsoft-data-with-power-query/49344 "2018-08-13T17:23:50Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Charley\_Kyd](https://sea1.discourse-cdn.com/flex019/user_avatar/integration.keap.com/charley_kyd/32/5863_2.png) [@Charley\_Kyd](https://integration.keap.com/u/Charley_Kyd)\
**Post date:** [August 13, 2018, 5:23pm UTC](https://integration.keap.com/t/querying-infusionsoft-data-with-power-query/49344/1 "2018-08-13T17:23:50Z")

</div>

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!)

Thanks!

---

<div class="post-metadata">

**Author:** ![Jordan\_Novak](https://avatars.discourse-cdn.com/v4/letter/j/b9e5f3/32.png) [@Jordan\_Novak](https://integration.keap.com/u/Jordan_Novak)\
**Post date:** [August 13, 2018, 6:14pm UTC](https://integration.keap.com/t/querying-infusionsoft-data-with-power-query/49344/2 "2018-08-13T18:14:00Z")

</div>

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.