> ## Documentation Index
> Fetch the complete documentation index at: https://docs.nekt.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Thinkific as a data source

> Bring your Thinkific courses, lessons, enrollments and progress, students, orders, products, coupons and groups to Nekt.

Thinkific is a platform to create, sell and deliver online courses. This connector reads your site's data through the Thinkific Admin API: courses with their chapters and lessons, course reviews, enrollments with progress and completion, users and their custom profile fields, instructors, groups with their members and analysts, orders, products with their price options, bundles, categories, promotions and coupons.

> [!NOTE]
>
> The connector only reads data. It never creates, changes or deletes courses, users, enrollments or orders in Thinkific.

## Before you start

* **Your Thinkific plan must include the API.** Thinkific only gives API access to sites on the **Grow** plan (Pro + Growth) or higher. On other plans every request is refused as if the credentials were wrong.
* **You need the site owner (or an admin who can manage API access).** The connector signs in with an **API Access Token** created in the site settings.
* **Courses built with the new course builder are not in the API.** Thinkific leaves them out of its REST API (courses, chapters, lessons, categories and products). Enrollments in those courses do appear in the `enrollments` table.
* **Some tables depend on your Thinkific plan.** When a feature is not included in your plan (groups, for example), Thinkific refuses to share it. Those tables are skipped and marked as failed in the run, and the other tables keep syncing. Upgrade the plan, or deselect those tables.

## Configuring Thinkific as a Source

In the [Sources](https://app.nekt.ai/sources) tab, click on the "Add source" button located on the top right of your screen. Then, select the Thinkific option from the list of connectors.

Click **Next** and you'll be prompted to add your access.

### 1. Add account access

Choose how the connector signs in. **API Access Token** is the method Thinkific recommends.

To create an API Access Token:

1. Sign in to your Thinkific site.
2. Go to **Settings** and open the **Code & analytics** tab.
3. Scroll to **API Access Tokens** and click **Add API access token**.
4. Give it a name (for example, "Nekt") and an expiration date, and click **Save**.
5. Copy the token. Thinkific shows it only once.

See [Thinkific's guide to API Access Tokens](https://support.thinkific.dev/hc/en-us/articles/38357676036887-Authorization-using-API-Access-Token).

> [!WARNING]
>
> The token stops working on the expiration date you chose. When it expires the sync fails: create a new token in Thinkific and update it in the source. The token gives access to all the data of your site, so keep it safe.

If your site already uses the **legacy API key**, you can use it instead: it is under **Settings > Code & analytics > API**, together with your site's subdomain. Thinkific plans to retire this method, and resetting the key to see it again breaks any other integration that uses it.

The following configurations are available:

* **Authentication Method**: **API Access Token (recommended)** or **API Key and subdomain (legacy)**.
* **API Access Token**: the token you created, when you chose API Access Token.
* **API Key**: the legacy API key of your site, when you chose the legacy method.
* **Subdomain**: the first part of your site's thinkific.com address (`yourschool` for `yourschool.thinkific.com`), when you chose the legacy method. Not your custom domain.

Once you're done, click **Next**.

### 2. Select streams

Choose which data streams you want to sync. For faster extractions, select only the streams that are relevant to your analysis. You can select entire groups of streams or pick specific ones.

> Tip: The stream can be found more easily by typing its name.

Select the streams and click **Next**.

### 3. Configure data streams

Customize how you want your data to appear in your catalog. Select the desired layer where the data will be placed, a folder to organize it inside the layer, a name for each table (which will effectively contain the fetched data) and the type of sync.

* **Layer**: choose between the existing layers on your catalog. This is where you will find your new extracted tables as the extraction runs successfully.
* **Folder**: a folder can be created inside the selected layer to group all tables being created from this new data source.
* **Table name**: we suggest a name, but feel free to customize it. You have the option to add a **prefix** to all tables at once and make this process faster!
* **Sync Type**: `enrollments` can be synced as **Incremental**: each sync brings only the enrollments that changed since the previous one (and, once a week, all of them again). Every other table is synced as **Full table**: each sync brings the current state of the data, so records deleted in Thinkific also leave your catalog.

Once you are done configuring, click **Next**.

### 4. Configure data source

Describe your data source for easy identification within your organization, not exceeding 140 characters.

To define your [Trigger](https://docs.nekt.com/runs/scheduling-and-triggers.md), consider how often you want data to be extracted from this source. This decision usually depends on how frequently you need the new table data updated (every day, once a week, or only at specific times).

Optionally, you can configure Delta Log Retention and determine for how long we should store old states of this table as it gets updated. Read more about this resource [here](https://docs.nekt.com/get-started/core-concepts/resource-control).

Once you are ready, click **Next** to finalize the setup.

### 5. Check your new source

You can view your new source on the [Sources](https://app.nekt.ai/sources) page. If needed, manually trigger the source extraction by clicking on the arrow button. Once executed, your data will appear in your Catalog.

> [!WARNING]
>
> For you to be able to see it on your [Catalog](https://app.nekt.ai/catalog), you need at least one successful source run.

# Streams and Fields

## Available streams

The table below lists every stream, its **slug** (the exact identifier to pass when creating the source via API) and a short description.

| Stream | Slug | Description |
| - | - | - |
| Courses | `courses` | Courses of the site. |
| Chapters | `chapters` | Chapters of each course. |
| Contents (lessons) | `contents` | Lessons, quizzes and other contents of each chapter. |
| Course Reviews | `course_reviews` | Reviews of each course, approved or not. |
| Enrollments | `enrollments` | Which user is enrolled in which course, with progress and completion. |
| Users | `users` | Every user of the site: students, admins, affiliates. |
| User Custom Profile Fields | `user_custom_profile_fields` | One row per user and custom profile field. |
| Custom Profile Field Definitions | `custom_profile_field_definitions` | The custom fields of the sign-up form. |
| Instructors | `instructors` | Instructor profiles shown on courses. |
| Groups | `groups` | Groups of students. May depend on your Thinkific plan. |
| Group Analysts | `group_analysts` | Users who can see each group's reports. May depend on your Thinkific plan. |
| Group Members | `group_members` | Users that belong to each group. May depend on your Thinkific plan. |
| Orders | `orders` | Order history. |
| Order Items | `order_items` | One row per product of each order. |
| Products | `products` | What the site sells: courses, bundles and communities. |
| Product Prices | `product_prices` | Price options of each product. |
| Bundles | `bundles` | Bundles of courses. |
| Bundle Courses | `bundle_courses` | One row per bundle and course. |
| Categories | `collections` | Categories of the site (called collections in the API). |
| Category Products | `collection_products` | One row per category and product. |
| Promotions | `promotions` | Discount rules. |
| Coupons | `coupons` | Coupon codes of each promotion. |

Every table also has an `additional_fields` column: any field Thinkific returns that is not mapped to its own column, as a JSON object.

## Fields by stream

Fields marked **String (JSON)** hold a JSON value; use your SQL engine's JSON functions to read them.

### Courses and learning

> [accordion] Courses
>
> The courses of the site. Courses built with Thinkific's new course builder are not available in the API. Read in full on every sync.
>
> Table: `courses` · Primary key: `id` · Sync: Full table
>
> | Field | Type | Description |
> | :- | :- | :- |
> | `id` | Integer | Unique identifier of the course. |
> | `name` | String | Name of the course. |
> | `slug` | String | URL-friendly name of the course, used in the landing page and course player addresses. |
> | `subtitle` | String | Subtitle of the course (deprecated; used by legacy themes). |
> | `product_id` | Integer | ID of the product that sells this course (see products). |
> | `description` | String | Description of the course. |
> | `course_card_text` | String | Text of the course card (deprecated; use description). |
> | `intro_video_youtube` | String | YouTube intro video identifier (deprecated; used by legacy themes). |
> | `contact_information` | String | Contact information of the course (deprecated). |
> | `keywords` | String | Keywords of the course. |
> | `duration` | String | Duration shown for the course (deprecated; used by legacy themes). |
> | `banner_image_url` | String | Landing page banner image URL (deprecated; use course\_card\_image\_url). |
> | `course_card_image_url` | String | Card image URL of the course. |
> | `intro_video_wistia_identifier` | String | Wistia intro video identifier (deprecated; used by legacy themes). |
> | `administrator_user_ids` | Array of Integer | IDs of the users who administer the course. |
> | `chapter_ids` | Array of Integer | IDs of the chapters of the course, in order. |
> | `reviews_enabled` | Boolean | Whether reviews are enabled for the course. |
> | `user_id` | Integer | ID of the user who created the course. |
> | `instructor_id` | Integer | ID of the instructor of the course (see instructors). |
> | `additional_fields` | String (JSON) | Fields the Thinkific API returned that this connector does not map to a column, kept as a JSON object (null when there are none). |

> [accordion] Chapters
>
> The chapters of each course, read with one request per course. Read in full on every sync.
>
> Table: `chapters` · Primary key: `id` · Sync: Full table
>
> | Field | Type | Description |
> | :- | :- | :- |
> | `id` | Integer | Unique identifier of the chapter. |
> | `course_id` | Integer | ID of the course the chapter belongs to. |
> | `name` | String | Name of the chapter. |
> | `position` | Integer | Position of the chapter within the course. |
> | `description` | String | Description of the chapter. |
> | `duration_in_seconds` | Number | Duration of the chapter in seconds (sum of the lengths of its video lessons). |
> | `content_ids` | Array of Integer | IDs of the contents (lessons) of the chapter, in order. |
> | `additional_fields` | String (JSON) | Fields the Thinkific API returned that this connector does not map to a column, kept as a JSON object (null when there are none). |

> [accordion] Contents (lessons)
>
> The lessons, quizzes, surveys and other contents of each chapter, read with one request per chapter. Read in full on every sync.
>
> Table: `contents` · Primary key: `id` · Sync: Full table
>
> | Field | Type | Description |
> | :- | :- | :- |
> | `id` | Integer | Unique identifier of the content (lesson). |
> | `chapter_id` | Integer | ID of the chapter the content is in. |
> | `course_id` | Integer | ID of the course the content is in. |
> | `name` | String | Name of the content. |
> | `position` | Integer | Position of the content within its chapter. |
> | `contentable_type` | String | Type of the content (for example Lesson, Quiz, Survey, Download). |
> | `free` | Boolean | Whether the content is a free preview. |
> | `take_url` | String | Address of the content in the course player. |
> | `additional_fields` | String (JSON) | Fields the Thinkific API returned that this connector does not map to a column, kept as a JSON object (null when there are none). |

> [accordion] Course Reviews
>
> The reviews of each course, approved or not, read per course. Read in full on every sync.
>
> Table: `course_reviews` · Primary key: `id` · Sync: Full table
>
> | Field | Type | Description |
> | :- | :- | :- |
> | `id` | Integer | Unique identifier of the course review. |
> | `course_id` | Integer | ID of the course being reviewed. |
> | `user_id` | Integer | ID of the user who wrote the review. |
> | `rating` | Number | Rating of the review, out of 5. |
> | `title` | String | Title of the review. |
> | `review_text` | String | Text of the review. |
> | `approved` | Boolean | Whether the review has been approved. |
> | `created_at` | Datetime | Date and time the review was created. |
> | `additional_fields` | String (JSON) | Fields the Thinkific API returned that this connector does not map to a column, kept as a JSON object (null when there are none). |

> [accordion] Enrollments
>
> Which user is enrolled in which course, with progress, completion and expiry. The first sync reads every enrollment; later syncs read the enrollments updated since the previous sync (with one day of margin) up to the moment the sync started, and once a week all of them again, so values that change when a date passes (such as `expired`) are refreshed. An enrollment updated while a sync runs is picked up by the next sync. If the weekly full refresh cannot be completed, that sync still loads the recent changes and the next one tries the full refresh again.
>
> Table: `enrollments` · Primary key: `id` · Sync: Incremental (by `updated_at`)
>
> | Field | Type | Description |
> | :- | :- | :- |
> | `id` | Integer | Unique identifier of the enrollment. |
> | `user_id` | Integer | ID of the enrolled user. |
> | `user_email` | String | Email of the enrolled user. |
> | `user_name` | String | Full name of the enrolled user. |
> | `course_id` | Integer | ID of the course. |
> | `course_name` | String | Name of the course. |
> | `percentage_completed` | Number | Completion of the course, from 0.0 to 1.0 (0.5 = 50%). |
> | `completed` | Boolean | Whether the enrollment is completed. |
> | `completed_at` | Datetime | Date and time the enrollment was completed. |
> | `expired` | Boolean | Whether the enrollment is expired. |
> | `expiry_date` | Datetime | Date and time the enrollment expires. |
> | `is_free_trial` | Boolean | Whether the enrollment is a free trial. |
> | `started_at` | Datetime | Date and time the enrollment started. |
> | `activated_at` | Datetime | Date and time the enrollment was activated. |
> | `created_at` | Datetime | Date and time the enrollment was created (when the API sends it). |
> | `updated_at` | Datetime | Date and time the enrollment was last updated, used as the incremental replication key. |
> | `additional_fields` | String (JSON) | Fields the Thinkific API returned that this connector does not map to a column, kept as a JSON object (null when there are none). |

### People

> [accordion] Users
>
> Every user of the site: students, admins and affiliates. Read in full on every sync.
>
> Table: `users` · Primary key: `id` · Sync: Full table
>
> | Field | Type | Description |
> | :- | :- | :- |
> | `id` | Integer | Unique identifier of the user. |
> | `created_at` | Datetime | Date and time the user was created. |
> | `first_name` | String | First name of the user. |
> | `last_name` | String | Last name of the user. |
> | `full_name` | String | Full name of the user. |
> | `email` | String | Email of the user. |
> | `company` | String | Company of the user. |
> | `roles` | Array of String | Roles of the user (for example affiliate, course\_admin, group\_analyst, site\_admin). |
> | `avatar_url` | String | Avatar URL of the user. |
> | `bio` | String | Bio of the user. |
> | `headline` | String | Headline or title of the user. |
> | `external_source` | String | External source the user came from (single sign-on or integration). |
> | `affiliate_code` | String | Affiliate code of the user, when the user is an affiliate. |
> | `affiliate_commission` | Number | Affiliate commission of the user (percent or fixed amount, see affiliate\_commission\_type). |
> | `affiliate_commission_type` | String | Affiliate payout type: % (percentage) or \$ (fixed amount). |
> | `affiliate_payout_email` | String | Email used to pay the affiliate. |
> | `administered_course_ids` | Array of Integer | IDs of the courses the user administers. |
> | `custom_profile_fields` | String (JSON) | Custom profile fields of the user (JSON array of objects with id, label, value and definition id); also one per row in user\_custom\_profile\_fields. |
> | `additional_fields` | String (JSON) | Fields the Thinkific API returned that this connector does not map to a column, kept as a JSON object (null when there are none). |

> [accordion] User Custom Profile Fields
>
> The custom profile fields of each user (for example country or phone), one row per user and field. Read in full on every sync.
>
> Table: `user_custom_profile_fields` · Primary key: `user_id`, `id` · Sync: Full table
>
> | Field | Type | Description |
> | :- | :- | :- |
> | `user_id` | Integer | ID of the user. |
> | `id` | Integer | Unique identifier of the field value. |
> | `custom_profile_field_definition_id` | Integer | ID of the field definition (see custom\_profile\_field\_definitions). |
> | `label` | String | Label of the field. |
> | `value` | String | Value the user gave for the field. |
> | `additional_fields` | String (JSON) | Fields the Thinkific API returned that this connector does not map to a column, kept as a JSON object (null when there are none). |

> [accordion] Custom Profile Field Definitions
>
> The custom fields of the site's sign-up form. Read in full on every sync.
>
> Table: `custom_profile_field_definitions` · Primary key: `id` · Sync: Full table
>
> | Field | Type | Description |
> | :- | :- | :- |
> | `id` | Integer | Unique identifier of the field definition. |
> | `label` | String | Label of the field. |
> | `field_type` | String | Type of the field. |
> | `required` | Boolean | Whether the field is required. |
> | `additional_fields` | String (JSON) | Fields the Thinkific API returned that this connector does not map to a column, kept as a JSON object (null when there are none). |

> [accordion] Instructors
>
> The instructor profiles shown on courses. Read in full on every sync.
>
> Table: `instructors` · Primary key: `id` · Sync: Full table
>
> | Field | Type | Description |
> | :- | :- | :- |
> | `id` | Integer | Unique identifier of the instructor. |
> | `user_id` | Integer | ID of the user owning the instructor profile. |
> | `title` | String | Title of the instructor. |
> | `first_name` | String | First name of the instructor. |
> | `last_name` | String | Last name of the instructor. |
> | `email` | String | Email of the instructor. |
> | `bio` | String | Bio of the instructor. |
> | `slug` | String | Slug of the instructor. |
> | `avatar_url` | String | Avatar URL of the instructor. |
> | `created_at` | Datetime | Date and time the instructor was created. |
> | `additional_fields` | String (JSON) | Fields the Thinkific API returned that this connector does not map to a column, kept as a JSON object (null when there are none). |

> [accordion] Groups
>
> Groups of students, for example the employees of a client company. May depend on your Thinkific plan. Read in full on every sync.
>
> Table: `groups` · Primary key: `id` · Sync: Full table
>
> | Field | Type | Description |
> | :- | :- | :- |
> | `id` | Integer | Unique identifier of the group. |
> | `name` | String | Name of the group. |
> | `token` | String | 8-character unique identifier of the group. |
> | `created_at` | Datetime | Date and time the group was created. |
> | `additional_fields` | String (JSON) | Fields the Thinkific API returned that this connector does not map to a column, kept as a JSON object (null when there are none). |

> [accordion] Group Analysts
>
> The users who can see each group's reports, read with one request per group. Read in full on every sync.
>
> Table: `group_analysts` · Primary key: `group_id`, `user_id` · Sync: Full table
>
> | Field | Type | Description |
> | :- | :- | :- |
> | `group_id` | Integer | ID of the group. |
> | `user_id` | Integer | ID of a user who is an analyst of the group. |
> | `additional_fields` | String (JSON) | Fields the Thinkific API returned that this connector does not map to a column, kept as a JSON object (null when there are none). |

> [accordion] Group Members
>
> The users that belong to each group, read per group. Before reading the groups, the connector checks that Thinkific applies the group filter; if it does not, this table fails instead of listing every user in every group. Read in full on every sync.
>
> Table: `group_members` · Primary key: `group_id`, `user_id` · Sync: Full table
>
> | Field | Type | Description |
> | :- | :- | :- |
> | `group_id` | Integer | ID of the group. |
> | `user_id` | Integer | ID of a user who belongs to the group (see users). |
> | `additional_fields` | String (JSON) | Fields the Thinkific API returned that this connector does not map to a column, kept as a JSON object (null when there are none). |

### Sales

> [accordion] Orders
>
> The order history of the site. Read in full on every sync.
>
> Table: `orders` · Primary key: `id` · Sync: Full table
>
> | Field | Type | Description |
> | :- | :- | :- |
> | `id` | Integer | Unique identifier of the order. |
> | `created_at` | Datetime | Date and time the order was created. |
> | `status` | String | Status of the order (for example complete, refunded). |
> | `user_id` | Integer | ID of the user who placed the order. |
> | `user_email` | String | Email of the user who placed the order. |
> | `user_name` | String | Full name of the user who placed the order. |
> | `product_id` | Integer | ID of the product purchased. |
> | `product_name` | String | Name of the product purchased. |
> | `amount_dollars` | Number | Order amount in the site's currency units (Thinkific calls it dollars). |
> | `amount_cents` | Integer | Order amount in cents of the site's currency. |
> | `subscription` | Boolean | Whether the order is for a subscription. |
> | `coupon_code` | String | Coupon code used on the order. |
> | `coupon_id` | Integer | ID of the coupon used on the order. |
> | `affiliate_referral_code` | String | Affiliate referral code used on the order. |
> | `items` | String (JSON) | Products of the order (JSON array of objects with product\_id, product\_name, amount\_dollars and amount\_cents); also one per row in order\_items. |
> | `additional_fields` | String (JSON) | Fields the Thinkific API returned that this connector does not map to a column, kept as a JSON object (null when there are none). |

> [accordion] Order Items
>
> The products of each order, one row per order and product. Read in full on every sync.
>
> Table: `order_items` · Primary key: `order_id`, `item_index` · Sync: Full table
>
> | Field | Type | Description |
> | :- | :- | :- |
> | `order_id` | Integer | ID of the order the item belongs to. |
> | `item_index` | Integer | Position of the item in the order (0 for the first). |
> | `product_id` | Integer | ID of the product of the item. |
> | `product_name` | String | Name of the product of the item. |
> | `amount_dollars` | Number | Price of the item in the site's currency units. |
> | `amount_cents` | Integer | Price of the item in cents of the site's currency. |
> | `additional_fields` | String (JSON) | Fields the Thinkific API returned that this connector does not map to a column, kept as a JSON object (null when there are none). |

> [accordion] Products
>
> What the site sells: courses, bundles and communities. Read in full on every sync.
>
> Table: `products` · Primary key: `id` · Sync: Full table
>
> | Field | Type | Description |
> | :- | :- | :- |
> | `id` | Integer | Unique identifier of the product. |
> | `created_at` | Datetime | Date and time the product was created. |
> | `productable_id` | Integer | ID of the course, bundle or community this product sells. |
> | `productable_type` | String | What the product sells: Course, Bundle or Community. |
> | `name` | String | Name of the product. |
> | `slug` | String | Slug of the product. |
> | `status` | String | Status of the product: published or draft. |
> | `price` | Number | Price of the product (deprecated by Thinkific; see product\_prices). |
> | `position` | Integer | Position of the product within the site, used for ordering. |
> | `private` | Boolean | Whether the product is private (cannot be purchased; users must be enrolled by an admin). |
> | `hidden` | Boolean | Whether the product is hidden from the site pages. |
> | `subscription` | Boolean | Whether the product is a subscription. |
> | `days_until_expiry` | Integer | Days of access granted from the enrollment date, when access can end. |
> | `has_certificate` | Boolean | Whether the product has a certificate. |
> | `keywords` | String | Keywords of the product. |
> | `seo_title` | String | SEO title of the product. |
> | `seo_description` | String | SEO description of the product. |
> | `collection_ids` | Array of Integer | IDs of the categories (collections) the product belongs to. |
> | `related_product_ids` | Array of Integer | IDs of the related products. |
> | `description` | String | Description of the product. |
> | `card_image_url` | String | Card image URL of the product. |
> | `product_prices` | String (JSON) | Price options of the product (JSON array of objects); also one per row in product\_prices. |
> | `additional_fields` | String (JSON) | Fields the Thinkific API returned that this connector does not map to a column, kept as a JSON object (null when there are none). |

> [accordion] Product Prices
>
> The price options of each product (one-time, subscription, payment plan, free). Read in full on every sync.
>
> Table: `product_prices` · Primary key: `id` · Sync: Full table
>
> | Field | Type | Description |
> | :- | :- | :- |
> | `id` | Integer | Unique identifier of the price option. |
> | `product_id` | Integer | ID of the product the price option belongs to. |
> | `is_primary` | Boolean | Whether this is the default price option of the product. |
> | `payment_type` | String | Type of payment: free, one-time, subscription or payment-plan. |
> | `label` | String | Description of the price option (required when it is not the primary one). |
> | `price_name` | String | Name of the price option. |
> | `price` | Number | Amount charged, in the price option's currency units. |
> | `currency` | String | Three-letter ISO currency code of the price option. |
> | `days_until_expiry` | Integer | Days after purchase that the student stays enrolled. |
> | `pay_button_text` | String | Text of the buy button for this price option. |
> | `number_of_payments` | Integer | Number of recurring payments, for a payment-plan price option. |
> | `billing_interval` | String | Billing frequency: month or year (interval in the API). |
> | `billing_interval_count` | Integer | Number of intervals between billings (interval\_count in the API). |
> | `trial_interval` | String | Interval of the trial period: day or month. |
> | `trial_interval_count` | Integer | Number of trial intervals. |
> | `custom_first_price` | Number | Amount of the first payment period of a subscription, when it differs. |
> | `additional_fields` | String (JSON) | Fields the Thinkific API returned that this connector does not map to a column, kept as a JSON object (null when there are none). |

> [accordion] Bundles
>
> Bundles of courses, read with one request per bundle product. Read in full on every sync.
>
> Table: `bundles` · Primary key: `id` · Sync: Full table
>
> | Field | Type | Description |
> | :- | :- | :- |
> | `id` | Integer | Unique identifier of the bundle. |
> | `product_id` | Integer | ID of the product that sells the bundle (see products). |
> | `name` | String | Name of the bundle. |
> | `description` | String | Description of the bundle. |
> | `tagline` | String | Tagline of the bundle (deprecated). |
> | `banner_image_url` | String | Banner image URL of the bundle (deprecated; use bundle\_card\_image\_url). |
> | `bundle_card_image_url` | String | Card image URL of the bundle. |
> | `course_ids` | Array of Integer | IDs of the courses in the bundle; also one per row in bundle\_courses. |
> | `additional_fields` | String (JSON) | Fields the Thinkific API returned that this connector does not map to a column, kept as a JSON object (null when there are none). |

> [accordion] Bundle Courses
>
> The courses of each bundle, one row per bundle and course. Read in full on every sync.
>
> Table: `bundle_courses` · Primary key: `bundle_id`, `course_id` · Sync: Full table
>
> | Field | Type | Description |
> | :- | :- | :- |
> | `bundle_id` | Integer | ID of the bundle. |
> | `course_id` | Integer | ID of a course in the bundle. |
> | `position` | Integer | Position of the course in the bundle's list (0 for the first). |
> | `additional_fields` | String (JSON) | Fields the Thinkific API returned that this connector does not map to a column, kept as a JSON object (null when there are none). |

> [accordion] Categories
>
> The categories of the site (called collections in the Thinkific API). Read in full on every sync.
>
> Table: `collections` · Primary key: `id` · Sync: Full table
>
> | Field | Type | Description |
> | :- | :- | :- |
> | `id` | Integer | Unique identifier of the category. |
> | `name` | String | Name of the category. |
> | `description` | String | Description of the category. |
> | `slug` | String | Slug of the category. |
> | `is_default` | Boolean | Whether this is the site's default category (default in the API). |
> | `created_at` | Datetime | Date and time the category was created. |
> | `product_ids` | Array of Integer | IDs of the products in the category; also one per row in collection\_products. |
> | `additional_fields` | String (JSON) | Fields the Thinkific API returned that this connector does not map to a column, kept as a JSON object (null when there are none). |

> [accordion] Category Products
>
> The products of each category, one row per category and product. Read in full on every sync.
>
> Table: `collection_products` · Primary key: `collection_id`, `product_id` · Sync: Full table
>
> | Field | Type | Description |
> | :- | :- | :- |
> | `collection_id` | Integer | ID of the category (collection). |
> | `product_id` | Integer | ID of a product in the category. |
> | `position` | Integer | Position of the product in the category's list (0 for the first). |
> | `additional_fields` | String (JSON) | Fields the Thinkific API returned that this connector does not map to a column, kept as a JSON object (null when there are none). |

> [accordion] Promotions
>
> Discount rules. Coupons are the usable codes of a promotion. Read in full on every sync.
>
> Table: `promotions` · Primary key: `id` · Sync: Full table
>
> | Field | Type | Description |
> | :- | :- | :- |
> | `id` | Integer | Unique identifier of the promotion. |
> | `name` | String | Name of the promotion. |
> | `description` | String | Description of the promotion. |
> | `starts_at` | Datetime | Date and time the promotion begins. |
> | `expires_at` | Datetime | Date and time the promotion ends. |
> | `discount_type` | String | Type of discount: fixed or percentage. |
> | `amount` | Number | Amount of the discount: currency units when fixed, percent when percentage. |
> | `duration` | Integer | Number of billing periods the promotion applies to, for subscriptions and payment plans. |
> | `coupon_ids` | Array of Integer | IDs of the coupons of the promotion. |
> | `additional_fields` | String (JSON) | Fields the Thinkific API returned that this connector does not map to a column, kept as a JSON object (null when there are none). |

> [accordion] Coupons
>
> The coupon codes of each promotion, read per promotion. Read in full on every sync.
>
> Table: `coupons` · Primary key: `id` · Sync: Full table
>
> | Field | Type | Description |
> | :- | :- | :- |
> | `id` | Integer | Unique identifier of the coupon. |
> | `promotion_id` | Integer | ID of the promotion the coupon belongs to. |
> | `code` | String | Coupon code. |
> | `note` | String | Note on the coupon (deprecated by Thinkific). |
> | `quantity` | Integer | Number of times the coupon can be used (null for unlimited). |
> | `quantity_used` | Integer | Number of times the coupon has been used. |
> | `created_at` | Datetime | Date and time the coupon was created. |
> | `additional_fields` | String (JSON) | Fields the Thinkific API returned that this connector does not map to a column, kept as a JSON object (null when there are none). |

## Implementation notes

* **Full reads.** Except for enrollments, Thinkific's API has no filter by update date, so those tables are read in full on every sync. A table is only replaced once it was read completely: when Thinkific fails or answers inconsistently in the middle of a table, that table keeps the data of the previous sync and the run says which table failed.
* **Changes during a sync.** Thinkific returns its lists page by page, so a record created or deleted while a list is being read can shift the others between pages. To avoid missing records, the connector reads every list that has more than one page at least twice and combines the reads, reading again while a read still finds records the earlier ones missed. Records that appear because they were created or updated during the sync do not count as missed. If a list keeps changing in a way the reads cannot settle, that table fails instead of loading with gaps, and the next sync tries again.
* **Empty answers.** If a table that had records in the previous sync suddenly comes back empty, the sync stops that table instead of emptying it. If the data really was removed in Thinkific, run a Full sync of the source to accept the empty table.
* **Tables Thinkific refuses or does not offer.** When Thinkific answers that a feature is not included in your plan, the tables of that feature are skipped and marked as failed, and the sync log names them. The same happens, with a "not found" message, when Thinkific does not offer one of the lists for your site. If no selected table can be read, or the credentials are invalid or expired, the run fails.
* **Renamed columns.** Two API fields have names that are reserved words in SQL: a category's `default` is loaded as `is_default`, and a price option's `interval` and `interval_count` as `billing_interval` and `billing_interval_count`.
* **Amounts.** Order amounts come in the site's currency; Thinkific calls the unit "dollars" (`amount_dollars`) and also sends the value in cents (`amount_cents`).
* **Rate limits.** Thinkific allows 120 requests per minute per site, shared with your other integrations. The connector sends one request at a time, spaced to use at most about two thirds of that limit so your other integrations keep working, and waits and retries when Thinkific asks it to slow down. Tables read per course, chapter, promotion or group take one request per record, so sites with many courses and chapters take longer to sync.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.