Martus Connector - Using the Martus API

The Martus Connector allows you to extract data from Martus. This data can be extracted with any tool that consumes API information. 

The Martus Connector is an optional additional module available to customers who are at the Plus level, and is included in Premium subscription levels. API documentation can be found in Martus in Setup > API. 

Note: Our API does not allow access to the Personnel Budgeting module in Martus. This is intentional due to a lack of dimensional or permission-based filtering built into the API.

Connect to the Martus Connector

1. Click Setup > API.
2. Click Generate New Token.
3. Choose your Data Source from the dropdown.
4. Copy the code that appears.
5. Additional instructions are available at the bottom of the page.

Pull Data into Excel or Power BI

1. Open Excel or PowerBI.
2. Click Data tab. 
3. Click Get Data.
4. Click Launch Power Query Editor...
5. Click New Source.
6. Click Other Sources.
7. Click Blank Query.
8. Click Advanced Editor.
9. Paste the Martus code from the API page and click Done.