API 2 using Power Query

[Ealfardan]

Power query connector was updated:

API 2 using Power Query

This is a basic connector to connect Excel (or PowerBI) to Manager api2. let _ExpandCols = (TableToExpand as table, optional ColumnName as text) => let ListAllColumns = Table.ColumnNames(TableToExpand), ColumnsTotal = Table.ColumnCount(TableToExpand), CurrentColumnIndex = if (ColumnName = null) then 0 else List.PositionOf(ListAllColumns, ColumnName), CurrentColumnName = ListAllColumns{CurrentColumnIndex}, CurrentColumnContent = Table.Column(TableToEx…

The following issues were solved:

• Simplified the options to retrieve the object, instead of changing the output function from the code editor, now you can simply set Expand Object to true.

• Automatically get field path and field names from the Route argument. This solves the issue of having to type in inventory-items then inventoryItems and then inventory-item/[key]. Now all of this is being handled by the connector

• Added fields selection. This should be entered as a coma separated list, e.g. ItemCode, ItemName. Leave blank for default field list.
  
  To learn more on the available fields, you can use this connector, which will give you a navigable documents revealing all paths and fields:

let
    Source = Json.Document(Web.Contents("https://{your subdomain}.manager.io/api2"))
in
    Source

• Added pageSize. In order to retrieve all records, you can set this to 0 or null. Be warned though that when you try set your pageSize to anything other than 50, you must make a fields selection

• Added the ability to retrieve the objects, expand it and expand custom field object. Manual expansion is no longer required.