Tables: object metadata
Lists the Reporting API tables that hold metadata for objects in Mindtickle such as users, series, series ratings, modules, and content items, with their update frequency and download links.
Prerequisites
- FAQ: Your email address must be enabled for Reporting API access.
These tables provide metadata details for objects in Mindtickle, such as users, series, series ratings, modules, and content items. Sample links request up to 10 results. Full-data links omit that sample limit but remain subject to data limits and pagination requirements. For the attributes in each table, see the Reporting API metadata sheet.
User details
Section titled “User details”| Table name | Update frequency | Description | Downloads |
|---|---|---|---|
Users |
Hourly | Provides attributes for each user such as UserId, creation date, email, name, location, and department. Granularity: UserId. |
Sample data, full data |
UserGroups |
Hourly | Contains the mapping of users within a group. Granularity: UserId x GroupId. |
Sample data, full data |
Series and module details
Section titled “Series and module details”| Table name | Update frequency | Description | Downloads |
|---|---|---|---|
SeriesCollection |
Hourly | Contains series attributes such as SeriesId, series name, creator name, state, and visibility. Granularity: SeriesId. |
Sample data, full data |
SeriesModules |
Hourly | Contains the mapping of modules within a series. Granularity: SeriesId x ModuleId. |
Sample data, full data |
SeriesModuleSections |
Hourly | Contains the mapping of modules to sections within the series. Granularity: SeriesId x ModuleId x SectionId. |
Sample data, full data |
Modules |
Hourly | Contains module attributes such as ModuleId, version, scores, name, type, and creator. Granularity: ModuleId. |
Sample data, full data |
Series rating details
Section titled “Series rating details”| Table name | Update frequency | Description | Downloads |
|---|---|---|---|
SeriesRating |
Hourly | Contains information about learners’ ratings for a particular series, as a count and an average. Granularity: SeriesId. |
Sample data, full data |
SeriesUserRating |
Every 6 hours | Contains information about a particular learner’s rating for a series. Granularity: SeriesId x UserId. |
Sample data, full data |
Module rating details
Section titled “Module rating details”| Table name | Update frequency | Description | Downloads |
|---|---|---|---|
ModuleRating ** |
Hourly | Contains information about learners’ ratings for a particular module. Only the latest rating from a user is considered. Granularity: ModuleId. |
Sample data, full data |
ModuleUserRating ** |
Every 6 hours | Contains information about a particular learner’s rating and feedback for a module. Granularity: ModuleId x UserId. |
Sample data, full data |
Series certification details
Section titled “Series certification details”| Table name | Update frequency | Description | Downloads |
|---|---|---|---|
SeriesCertification |
Every 6 hours | Contains information about all certifications for all series. Granularity: SeriesId x CertificationId. |
Sample data, full data |
SeriesUserCertification |
Every 6 hours | Contains information about users who have been awarded certification across all series. Granularity: SeriesId x UserId x CertificationId. |
Sample data, full data |
Tag details
Section titled “Tag details”| Table name | Update frequency | Description | Downloads |
|---|---|---|---|
ModuleTags |
Daily at 9 pm Pacific Time * | Contains the mapping of modules to tags. Granularity: ModuleId x TagId. |
Sample data, full data |
LearningObjectTags |
Daily at 9 pm Pacific Time * | Contains the mapping of tags to content items within courses, quick updates, and assessments. Granularity: ModuleId x LearningObjectId x TagId. |
Sample data, full data |
Asset Hub details
Section titled “Asset Hub details”| Table name | Update frequency | Description | Downloads |
|---|---|---|---|
Asset ** |
Every 6 hours | Contains general asset information for Asset Hub, such as creation, state, and expiration. Granularity: AssetId. |
Sample data, full data |
Attribute ** |
Every 6 hours | Contains attribute information for Asset Hub. Granularity: AttributeId. |
Sample data, full data |
Hubs ** |
Every 6 hours | Contains information about all the hubs created for Asset Hub. Granularity: HubId. |
Sample data, full data |
HubAsset ** |
Every 6 hours | Contains hub to asset mapping information for Asset Hub. Granularity: HubId x AssetId. |
Sample data, full data |
AttributeAsset ** |
Every 6 hours | Contains attribute to asset mapping information for Asset Hub. Granularity: AttributeId x AssetId. |
Sample data, full data |
- Asterisk (*): For an update frequency marked with an asterisk, it may take up to 24 hours for data updates to appear.
- Double asterisk (**): Tables marked with a double asterisk are not enabled by default. Contact Mindtickle Support to enable a particular table for your learning site. The rest of the tables are enabled by default.
- Download links: Sample links request up to 10 results. Full-data links remain subject to the table’s data limits; use pagination for larger exports.
- Timestamps: For fields with a timestamp (date and time) across the Reporting API tables, the value is in the GMT time zone.
- Service root URL: The Reporting API has two service root URLs to query and extract data. The download links on this page reference the default URL. Ensure that you are using the correct, applicable URL.
Users:UserIdis stored in decimal format but displayed as hexadecimal in the platform interface.SeriesModuleSections: Visible only if sections are enabled.Modules: Does not provide data for missions in draft status.