The ClearPoint API allows you to connect your ClearPoint account with other applications and data sources, helping you expand your reporting and analysis capabilities.
Step 1 — Select the Measure in ClearPoint
To retrieve Measure data through the ClearPoint API, you need the Measure ID.
Option A: Find the Measure ID in the URL
Navigate to the Measure Detail Page in ClearPoint.
Look at your browser’s address bar.
Locate the value after objectId.
Example URL:
https://app.clearpointstrategy.com/#/index/?object=measure&objectId=1522940&periodId=312499&scorecardId=154480
💡 In this example, the Measure ID is 1522940.
Option B: Display the Measure ID on the Detail Page
From the left navigation, click Elements.
Open Measures.
Select the Measure (e.g., Revenue).
Open the kebab menu (⋮) next to the Edit icon and select Edit Layout.
In the layout panel, locate the Measure ID field.
Drag and drop to place it where you want it.
Click Save.
💡 You will now see the Measure ID displayed directly on the Measure Detail Page.
Step 2 — Add an API Key for Power BI Integration
From the top navigation, click Settings.
Select Integrations.
Navigate to the API Keys tab.
Click the Add API Key (+) icon.
Enter a name such as PowerBI.
We recommend using a descriptive name for future reference.
Set an expiration date as needed.
Map the API Key to a user.
Click Save.
Select the newly created key and copy the Access Key and Secret Key.
💡 You will use these values when connecting Power BI to ClearPoint.
Step 3 — Integrate ClearPoint with Power BI
If you do not already have Power BI, you can download it here.
Connect Power BI to ClearPoint
Open Power BI.
Click Get Data.
Select Web.
In the dialog that appears, click Advanced.
In the URL parts field, enter the following endpoint, replacing
{measureId}with your actual Measure ID:
https://app.clearpointstrategy.com/api/v1/measures/{measureId}/measureDataExample using Measure ID 1522940:
https://app.clearpointstrategy.com/api/v1/measures/1522940/measureData
Under HTTP request header parameters, add:
accessKey → paste your Access Key
secretKey → paste your Secret Key
Click OK.
💡 Power BI will now retrieve Measure Data from ClearPoint through the API.