SumTotal

SumTotal connections give you access to your company’s human resources and learning management data.

Source Setup

SumTotal uses OAuth as the authentication method for their API. To get the credentials, you need to follow these steps:

Find your Tenant URL. This is the complete URL that will precede your API calls (e.g.,https://yourCompany.sumtotal.host/).
Setup your CLIENT_ID and CLIENT_SECRET via the following steps:
1. Login to SumTotal as an Admin.
2. Go to Administration → Common Objects → Configuration → oAuth Configuration.
3. Click Add to create a new oAuth Client.
4. Insert the CLIENT_ID.
5. Insert a secure CLIENT_SECRET.
6. Select allapis as scope.
7. Make sure PKCE is disabled. If this function is not disabled, it will block API calls.
8. Click Submit.

Note

Prefer using an API? Go here and select SumTotal under the Body header to start creating your connection via API.

What Data is Available?

You can create SumTotal pipelines with the following entities:

Entity	Pipeline Mode	Iceberg Support
Activities	Replace	Batch
Audiences	Replace	Batch
Competencies	Replace	Batch
Domains	Replace	Batch
Grades	Replace	Batch
Jobs	Replace	Batch
Organizations	Replace	Batch
Skills	Replace	Batch
Social	Replace	Batch
Topics	Replace	Batch
Users	Replace	Batch
User Activities	Replace	Batch
User Activities Progress	Replace	Batch
User Tasks	Replace	Batch
Talent: User Process	Replace	Batch
Talent: Process Steps	Replace	Batch

Key Considerations

SumTotal’s API has two contexts: User Context, which returns data for logged-in users and B2B, which can return data for multiple system users. Etleap currently only supports extracting data from endpoints associated with the B2B context.