API Keys

Overview

API keys can be used to access transaction data via OData for Excel tables and Power BI. Users can generate API keys from the xpna task pane and use them to authenticate requests to the xpna API. Two API keys are generated for each workspace allowing users to rotate API keys without losing access to their data.

View or update API keys

Users can view or update their API keys by clicking the "Manage your API keys" button on the Workspace management section of the xpna task pane. API keys can be copied to the clipboard by clicking the "Copy to clipboard" button. API keys can also be refreshed by clicking the be updated by clicking the rotate button. This will generate two new API keys for the workspace and invalidate the old API keys.

Using API keys

To use the API keys in Excel to retreive transaction data, copy the API key to your clipboard using the copy icon then:

• Click the "Data" tab
• Click "Get Data"
• Click "From Other Sources"
• Click "From OData Feed"
• In the URL field enter https://xpna.app/api/odata
• Click "OK"
• Click on "Basic"
• In the "User name" field enter the email address you use to log in to Excel (this would normally be your work email address)
• In the "Password" field enter the API key you copied to your clipboard
• Click "Connect"
• Select the tables you want to import