# How to Integrate Retool with Coursera

- Tool: Retool
- Difficulty: Intermediate
- Time required: 35 minutes
- Last updated: April 2026

## TL;DR

Connect Retool to Coursera using a REST API Resource with OAuth 2.0 authentication against Coursera's Partner API. Organizations with Coursera for Business or content partner access can query courses, enrollments, and learner progress data to build a learning analytics dashboard that tracks employee training completion, certificate issuance, and program engagement across their Coursera catalog.

## Build a Coursera Learning Analytics Dashboard in Retool

Coursera for Business is used by enterprises to provide structured online learning programs to employees, spanning technical skills, leadership development, and professional certifications. While Coursera's administrative interface provides learning analytics, L&D (Learning and Development) teams typically need to report on training progress in the context of broader HR data — headcount by department, role-based skill requirements, and performance review timelines. A Retool dashboard connected to Coursera's Partner API provides the bridge between Coursera's learning data and internal organizational context.

The Coursera Partner API exposes course catalogs, enrollment records with completion status, learner-level grade information, and certificate issuance data for organizations with API access. This data is what L&D teams need to answer questions like: Which employees have completed mandatory compliance training? What percentage of the engineering team has earned the target certification by the Q3 deadline? Which courses have the highest dropout rates and might need intervention? These questions cannot be easily answered from Coursera's native dashboard, but they are straightforward to surface in a Retool app.

Note that Coursera's API access is gated behind a business agreement — API credentials are provided to Coursera for Business customers and content creation partners, not all Coursera users. Organizations interested in API access should contact their Coursera account manager. Once access is granted, the technical setup in Retool is straightforward and follows the standard OAuth 2.0 client credentials pattern used across enterprise learning platforms.

## Before you start

- A Coursera for Business enterprise account or Coursera content partner agreement with API access enabled
- Coursera Partner API credentials (Client ID and Client Secret) obtained from your Coursera account manager or the Coursera for Partners portal
- Your Coursera organization ID or enterprise group ID for scoping API queries to your organization
- A Retool account with permission to create Resources
- Basic familiarity with OAuth 2.0 client credentials grant authentication flow

## Step-by-step guide

### 1. Obtain Coursera Partner API credentials

Coursera API access is available to enterprise customers through the Coursera for Business program and to content creation partners. This is not a self-service API key that any Coursera user can generate — it requires a business agreement with Coursera. If your organization has Coursera for Business, contact your Coursera account manager and request Partner API access. They will provision API credentials through the Coursera for Partners portal. Once provisioned, you receive a Client ID and Client Secret used for OAuth 2.0 client credentials authentication. Log in to the Coursera for Partners portal (partners.coursera.org) with your partner credentials and navigate to the API credentials section to view your Client ID and generate your Client Secret. Your organization will also have an enterprise group ID — a numeric identifier that scopes all enrollment and learner queries to your organization's users rather than the full Coursera platform. This ID appears in partner portal URLs and in the documentation provided by your Coursera account manager. Store both the Client ID and Client Secret in Retool Configuration Variables: COURSERA_CLIENT_ID (not secret) and COURSERA_CLIENT_SECRET (marked as secret). The OAuth token endpoint for Coursera is https://api.coursera.org/oauth2/client_credentials/token. Tokens are obtained by posting Basic authentication (Base64-encoded clientId:clientSecret) to this endpoint.

```
// OAuth token request for Coursera Partner API
// POST https://api.coursera.org/oauth2/client_credentials/token
// Headers: Authorization: Basic base64(clientId:clientSecret)
// Body (application/x-www-form-urlencoded):
grant_type=client_credentials&scope=view_profile
```

**Expected result:** Coursera Partner API credentials (Client ID and Client Secret) are obtained and stored as Retool Configuration Variables. You have the enterprise group ID for scoping queries to your organization.

### 2. Configure the REST API Resource and obtain an access token

In Retool, navigate to the Resources tab and click Add Resource. Select REST API. Name the resource 'Coursera Partner API'. Set the Base URL to https://api.coursera.org. For authentication, select Bearer Token. In the Bearer Token field, enter {{ retoolContext.configVars.COURSERA_ACCESS_TOKEN }}. This references a Configuration Variable that will be populated by your token refresh process. Add a default header: Content-Type with value application/json. Click Save Resource. For the initial token, create a JavaScript query in a Retool app that calls the Coursera token endpoint. The request must use Basic authentication with your Client ID and Client Secret Base64-encoded as the Authorization header value, and the body must be application/x-www-form-urlencoded with grant_type=client_credentials. In a JavaScript query, use the fetch API to POST to https://api.coursera.org/oauth2/client_credentials/token — note that this is an unauthenticated fetch (not going through your Retool resource) because the token endpoint uses Basic auth, not Bearer auth. The response JSON contains access_token. Copy this value and store it as the COURSERA_ACCESS_TOKEN Configuration Variable in Retool Settings → Configuration Variables. For production, create a Retool Workflow on a 50-minute schedule that executes this token request, extracts the access_token from the response, and calls Retool's API to update the Configuration Variable programmatically.

```
// JavaScript query to obtain Coursera access token
// Run this in a Retool app to get the initial token
const clientId = retoolContext.configVars.COURSERA_CLIENT_ID;
const clientSecret = retoolContext.configVars.COURSERA_CLIENT_SECRET;
const credentials = btoa(`${clientId}:${clientSecret}`);

const response = await fetch(
  'https://api.coursera.org/oauth2/client_credentials/token',
  {
    method: 'POST',
    headers: {
      'Authorization': `Basic ${credentials}`,
      'Content-Type': 'application/x-www-form-urlencoded'
    },
    body: 'grant_type=client_credentials&scope=view_profile'
  }
);

const tokenData = await response.json();
return tokenData;
```

**Expected result:** The Coursera Partner API resource is configured in Retool with a valid access token. A test query to /api/enterprises.v1 or /api/courses.v1 returns data from the Coursera API.

### 3. Build course catalog and enrollment queries

Create queries for the core learning data. Create a query named 'getEnterpriseEnrollments'. Set Method to GET and Path to /api/businesses.v1/{{ retoolContext.configVars.COURSERA_ORG_ID }}/enrollments. Add URL parameters: limit → {{ pagination.pageSize || 50 }}, start → {{ (pagination.page - 1) * pagination.pageSize || 0 }}. Coursera uses numeric offset-based pagination with start and limit parameters. The response includes an elements array of enrollment objects, each containing userId, courseId, courseSlug, enrolledTimestamp, grade, isCompleted, and verifiedCertificateUrl. Note that userId values in enrollment records are Coursera internal IDs — you will need a separate mapping from user email to userId if you want to join with your HR system by email. Create a query named 'getCourseCatalog'. Set Method to GET and Path to /api/enterprises.v1/{{ retoolContext.configVars.COURSERA_ORG_ID }}/courseCatalog. This returns the list of courses available to your organization. Create a JavaScript transformer that merges enrollment data with course catalog data: for each enrollment, look up the course name from the catalog using the courseId, compute a completion_status label ('Completed', 'In Progress', or 'Enrolled'), and calculate the days since enrollment. Format grade as a percentage if it is a decimal value (0.0 to 1.0 scale).

```
// Transformer: merge enrollments with course catalog
const enrollments = data.elements || [];
const catalog = getCourseCatalog.data?.elements || [];
const courseMap = Object.fromEntries(
  catalog.map(course => [course.id, course.name])
);

return enrollments.map(enrollment => ({
  user_id: enrollment.userId,
  course_id: enrollment.courseId,
  course_name: courseMap[enrollment.courseId] || enrollment.courseSlug || 'Unknown Course',
  enrolled_date: enrollment.enrolledTimestamp
    ? new Date(enrollment.enrolledTimestamp).toLocaleDateString()
    : 'N/A',
  grade: enrollment.grade !== null && enrollment.grade !== undefined
    ? (enrollment.grade * 100).toFixed(1) + '%'
    : 'In progress',
  completed: enrollment.isCompleted,
  status: enrollment.isCompleted
    ? 'Completed'
    : enrollment.grade > 0 ? 'In Progress' : 'Enrolled',
  certificate_url: enrollment.verifiedCertificateUrl || ''
}));
```

**Expected result:** The getEnterpriseEnrollments query returns enriched enrollment records with course names, completion status, grades, and certificate URLs.

### 4. Build completion rate analytics and department-level queries

Create analytics queries for L&D reporting. Create a JavaScript query named 'computeCompletionStats'. This references the enrollment transformer output and computes aggregate metrics: total enrollments, total completions, overall completion rate (completions / enrollments), average grade among completed learners, and a breakdown of completions by status category. Store the result as a state variable for use in Stat components. For department-level analytics, create a JavaScript query named 'groupByDepartment'. This joins enrollment data with an internal HR database query (create a separate PostgreSQL resource for your HR database) by matching email addresses through the user ID mapping table. The join produces rows with employee name, department, manager, and course completion status. Aggregate by department to compute departmental completion rates. Create a query named 'getCompletedCertificates'. Set Method to GET and Path to /api/enterprises.v1/{{ retoolContext.configVars.COURSERA_ORG_ID }}/certificates. This endpoint returns issued certificates with userId, courseId, certificateId, issueTimestamp, and verifiedUrl. Create a transformer that formats this data and flags certificates issued within the last 30 days as 'New' and any with expiry dates within the next 60 days as 'Expiring Soon'.

```
// JavaScript query: compute completion statistics
const enrollments = enrollmentsTransformer.data || [];
const total = enrollments.length;
const completed = enrollments.filter(e => e.completed).length;
const inProgress = enrollments.filter(e => e.status === 'In Progress').length;
const notStarted = enrollments.filter(e => e.status === 'Enrolled').length;

const completedGrades = enrollments
  .filter(e => e.completed && e.grade !== 'In progress')
  .map(e => parseFloat(e.grade));
const avgGrade = completedGrades.length > 0
  ? (completedGrades.reduce((a, b) => a + b, 0) / completedGrades.length).toFixed(1)
  : 'N/A';

return {
  total_enrollments: total,
  completed,
  in_progress: inProgress,
  not_started: notStarted,
  completion_rate: total > 0 ? ((completed / total) * 100).toFixed(1) + '%' : '0%',
  average_grade: avgGrade
};
```

**Expected result:** Completion statistics are computed and available for Stat components. Department-level grouping provides L&D managers with a breakdown of training completion by organizational unit.

### 5. Assemble the learning analytics dashboard UI

Build the complete L&D dashboard using Retool components. At the top, add a row of Stat components: Total Enrolled ({{ computeCompletionStats.data.total_enrollments }}), Completion Rate ({{ computeCompletionStats.data.completion_rate }}), In Progress ({{ computeCompletionStats.data.in_progress }}), and Average Grade ({{ computeCompletionStats.data.average_grade }}). Below the stats, add a Tab component with three tabs: Enrollments, Certificates, and Course Catalog. In the Enrollments tab: add a Select component for department filtering (populated from groupByDepartment.data distinct departments), a Select for status filtering (Completed/In Progress/Enrolled), and a Table named 'enrollmentsTable' bound to the enrollment transformer data with conditional row coloring (green for Completed, yellow for In Progress, gray for Enrolled). The 'certificate_url' column should render as a clickable Link column that opens the Coursera certificate URL in a new tab. In the Certificates tab: add a Table showing earned certificates with user ID, course name, issue date, and a link to verify the certificate. Add a filter for certificates issued in the last 30/60/90 days. In the Course Catalog tab: show all available courses with enrollment counts and completion rates per course, derived by aggregating the enrollment data. Add a Bar Chart showing completion rates across the top 10 most-enrolled courses. Set all three primary queries to run on page load.

**Expected result:** A three-tab learning analytics dashboard shows overall completion stats, an enrollment table with status filtering and certificate links, a certificate tracking view, and a course performance comparison.

## Best practices

- Store Coursera Client ID and Client Secret in Retool Configuration Variables marked as secrets — the Client Secret provides full API access to your organization's learner data and must be protected with the same rigor as database credentials
- Implement automated OAuth token refresh using a Retool Workflow on a 50-minute schedule — Coursera tokens expire in 1 hour, and relying on manual token updates will cause dashboard outages during business hours
- Request a learner email-to-user-ID mapping from Coursera and store it in a Retool Database table to enable JOIN queries that combine Coursera enrollment data with your HRIS or identity management system
- Use pagination parameters (limit and start offset) on all enrollment queries and implement proper pagination UI — large enterprises can have thousands of enrollment records that cannot be fetched in a single request
- Create separate Retool apps for different audiences: an executive summary dashboard with completion rates by department, and an L&D administrator panel with individual-level enrollment management — role-based access in Retool ensures the right data reaches the right audience
- Cache course catalog data in a Retool Database table or long-lived state variable since the catalog changes infrequently — re-fetching it on every dashboard load adds unnecessary API calls for data that is valid for hours or days
- Add conditional formatting in the enrollments table to highlight learners enrolled in mandatory courses but with zero progress after 14 days — these are the learners who need intervention or reminder communications from the L&D team
- Combine Coursera completion data with performance review timelines stored in your HR database to answer whether employees completed required upskilling before their next review — this is the report L&D leadership needs most and cannot get from Coursera alone

## Use cases

### Build an employee training completion tracker for L&D reporting

Create a Retool dashboard that shows enrollment and completion data for all employees enrolled in mandatory Coursera training programs. Join Coursera enrollment records with an internal HR database table to add department and manager information alongside learning progress. Display completion rates per department, highlight employees who have not started required courses, and show certificate expiration dates for certifications with validity periods.

Prompt example:

```
Build a Retool training completion tracker for Coursera. Show all enrollments for mandatory courses in a Table with employee email, course name, enrollment date, completion percentage, and certificate status. Group by department using a Select filter. Highlight rows where completion is 0% and enrollment date is older than 14 days. Show a Stat for overall completion rate.
```

### Build a course catalog and enrollment management panel

Create a Retool panel that displays the organization's Coursera course catalog with enrollment counts, completion rates, and average grades per course. Allow L&D administrators to view which employees are enrolled in each course, identify courses with high dropout rates, and export enrollment data for specific courses. Include a Chart showing enrollment trends over time for each course.

Prompt example:

```
Build a Retool course management panel for Coursera. Show the course catalog in a Table with course name, enrolled count, completion rate, and average grade. On row selection, show a list of enrolled learners with their completion status. Add a Bar Chart comparing completion rates across the top 10 courses.
```

### Build a certificate and badge tracking dashboard

Create a Retool panel that tracks earned certificates and professional credentials across the organization's Coursera programs. Show each certificate holder's name, the certificate earned, issue date, and expiration date if applicable. Include a filter for expiring certificates (within the next 60 days) and an export function for sending certificate data to the HR system. Combine with internal data to show whether each certificate holder has updated their profile with the new credential.

Prompt example:

```
Build a Retool certificate tracker for Coursera. Show all earned certificates in a Table with learner name, certificate title, issue date, and expiry date. Add a filter for certificates expiring within 60 days (highlighted in orange). Add a Stat for total unique certificates earned in the current quarter. Include a CSV export button.
```

## Troubleshooting

### 401 Unauthorized — 'invalid_token' when running Coursera API queries

Cause: The Coursera access token stored in the Configuration Variable has expired. Client credentials tokens from Coursera are valid for approximately 1 hour, after which they must be refreshed using the client credentials grant again.

Solution: Run the token refresh JavaScript query to obtain a new access token and update the COURSERA_ACCESS_TOKEN Configuration Variable. If this is happening frequently, implement the automated Retool Workflow that refreshes the token every 50 minutes. Verify the token request is using the correct client credentials and that your Coursera partner API access has not been suspended.

### Enterprise enrollment endpoint returns 403 Forbidden — 'not authorized for this enterprise'

Cause: The enterprise group ID in the API path is incorrect, or the API credentials provided were not granted access to this specific enterprise group.

Solution: Verify the COURSERA_ORG_ID Configuration Variable contains the correct enterprise group ID as a numeric string. Confirm with your Coursera account manager that your API credentials have been granted access to this enterprise group. Some Coursera for Business configurations use different ID formats — request the exact API endpoint paths from your Coursera technical contact.

### Enrollment data shows Coursera user IDs but no email addresses or names

Cause: Coursera's enrollment API returns internal user IDs, not email addresses. The API does not expose email addresses in enrollment responses for privacy reasons. Joining enrollment data with email-based HR records requires a separate user ID-to-email mapping.

Solution: Request a learner roster export from your Coursera for Business administrator — this export includes email-to-user-ID mappings. Import this data into a Retool Database table. In your enrollment transformer or a JavaScript query, perform a client-side join between the enrollment records (keyed by Coursera user ID) and the roster table (keyed by user ID) to attach email addresses and names to each enrollment row.

### Course catalog query returns an empty elements array despite courses being visible in CoursEra admin

Cause: The course catalog endpoint path uses a different enterprise identifier than the enrollment endpoint, or the catalog endpoint requires different OAuth scopes than those granted to your API credentials.

Solution: Verify the correct API path for your Coursera partnership type with your account manager — the exact endpoint for the enterprise course catalog varies between Coursera for Business and content partner configurations. Check the OAuth scopes included in your client credentials token request. Some catalog endpoints require additional scopes beyond view_profile — request the full list of required scopes from your Coursera technical contact and include them in the token request body.

## Frequently asked questions

### Can any Coursera account access the Coursera Partner API?

No. Coursera's Partner API is only available to organizations with a Coursera for Business enterprise agreement or content creation partnership. Individual Coursera users and small teams do not have API access. If your organization has Coursera for Business, contact your Coursera account manager to request API credentials — the provisioning process typically takes a few business days.

### Does Retool have a native Coursera connector?

No, Retool does not have a native Coursera connector. You connect using a REST API Resource with OAuth 2.0 Bearer token authentication. The setup is slightly more complex than simple API key integrations because Coursera requires an OAuth token exchange, but once the initial token is obtained and the auto-refresh Workflow is in place, the integration works reliably for ongoing use.

### How do I get employee names alongside Coursera enrollment data in Retool?

Coursera's API returns internal user IDs, not email addresses or names. To display employee names, import the learner roster (a mapping of Coursera user ID to email/name) into a Retool Database table. Use a JavaScript query to join the enrollment API data with the roster table by matching on user ID. Your Coursera for Business administrator can export the roster from the Coursera admin interface.

### Can I enroll employees in Coursera courses from Retool?

Coursera's Partner API includes endpoints for managing enrollments in Coursera for Business configurations, including bulk enrollment operations. This requires write-level API scopes in addition to read scopes. In Retool, you would create a Form with a learner user ID and course ID, and trigger a POST request to the enrollment endpoint. Coordinate with your Coursera account manager to confirm which enrollment management endpoints are available for your agreement type.

### What should I do if Coursera API access is not yet available for my organization?

If your organization does not yet have Coursera API access, Coursera's admin interface provides CSV export capabilities for enrollment and completion data. Import these CSV exports into a Retool Database table on a scheduled basis (weekly or monthly) and build your analytics dashboard using the imported data instead of live API queries. This offline approach provides the same analytical capabilities with a slight data freshness lag.

---

Source: https://www.rapidevelopers.com/retool-integrations/coursera
© RapidDev — https://www.rapidevelopers.com/retool-integrations/coursera