Martus Connector - Using the Martus API

The Martus Connector allows you to extract data from Martus for use in other tools like Excel or Power BI. Martus' data can be extracted with any tool that consumes API information. The Martus Connector does not permit you to write data to Martus, however. One frequently-used choice is to extract this data with Power Query for use within Power BI.  

The Martus Connector is available to all Admin users of Martus. The data provided is not dimensionally limited in any way.

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, thus potentially exposing sensitive data.

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

To access the API Documentation directly, go here: https://prod2.martus.app/api.

Connecting to the Martus Connector

1. Navigate to 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.

Martus provides sample queries.

Select the data source you wish to use to generate the Power Query syntax.

Copy the code. 

Pulling Data into Excel or Power BI

1. Open Excel or Power BI.
2. Click the 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 code from the Martus API page and click Done.
   
   

Endpoint Descriptions

Endpoints are available for the following data.

Budgets and Actuals

• Budgets
• Budget Data (and Actuals which have the same data structure)
• Worksheets 
• Worksheet Lines 
• SPWs
• SPW Lines

Dimensions 

• Dimensions 
• Dimension Items (values)

Accounts 

• Accounts 
• Account Categories 
• Reporting Groups 

In order to obtain full descriptions of each field provided, click on an endpoint, then scroll down to the label Schema. Click Schema and then use the > and … symbols to drill into the full description of the data provided by that endpoint.