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 and Premium subscription levels. If you are a Plus subscription level please contact our team for more information on this feature. 

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.

To Connect to Martus Connector

1. Click Setup > API
2. Click 'Generate New Token'
3. Choose your data source
4. Copy the code that appears

How To Pull This Data in 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 screen earlier and click 'Done'