Inventory items list to excel

[Ealfardan]

Hello @brandon_oma692,

Sure you can connect your excel to Manager.

Check this other topic:

API 2 using Power Query

I have updated the _ExpandCols functions to workaround a PQ hiccup where PQ doesn’t retrieve the full list of fields and instead uses the lazy method of looking into the first record field–which may or may not be complete. To help get the full list, a new function _GetFieldNames was added.

But I don’t think you can pull Advanced Queries output with it.