Web Services Practice Lab

Welcome to the Web Services Practice Lab. This practice lab is a private, independent and free-of-charge service for Cornerstone OnDemand customers, employees, partners and prospects. The platform is designed to quickly and easily execute selected Cornerstone web services, mainly for demo or testing purposes. The solution let's you focus on the web services calls while fully handling the authorization process using OAuth 2.0. This solution does NOT log any sensitive data (e.g. Client Id & Secret). Note: Use this portal on your own risk, there's no support or SLA.

Query Cornerstone data with SQL

Unlock powerful data access effortlessly with SQL — no API calls needed.
Experience seamless integration with your favorite tools like Power BI, Excel, and other reporting or analytic platforms, making it incredibly easy to access and analyze Cornerstone data.

• No throttling limits
• Query your data in seconds, with just a few lines of SQL code
• Connect the dots and query multiple tables with one SQL statement
• Apply any filter
• Transform your data as needed

Check out talenttrends.com

Reporting APIs

The Reporting API allows you to retrieve data from your Cornerstone Real-time Data Warehouse. The API adheres to the OData protocol and dynamically adjusts to reflect your portal's schema.

Data Exporter APIs

The Data Exporter API provides access to CORE objects, which are optimized for reliability at scale and improved performance compared to the Reporting API views. The API adheres to the OData protocol and dynamically adjusts to reflect your portal's schema.

Field Finder

This feature helps you to find a field in Reporting API and/or Data Exporter API. We will query both Reporting API and Data Exporting API metadata and provide you with some search capabilties.

Employee/OU APIs

The Employee/OU API allows you to retrieve, create or update Employee and Organizational Unit data.

Transcript APIs

The new Transcript API allows you to retrieve, create or update Transcript data.

Foundational APIs

The Foundational APIs allow you to retrieve data from various parts of the Cornerstone system.

Learning Assignment API

Assign training to Users using the Learning Assignment API.

Express Class API

Document gathered learning after the learning takes place using Express Class API.

Bulk API

The Bulk API is optimized for loading large data sets in an asynchronous, queued model. The data will be loaded via API's into staging tables first, before being processed via Edge Import. With the Bulk API, you can create and update your Employee data, Organizational data, Learning data and Capability data in Cornerstone. With Get Specification, you can download all supported Bulk API load types with it's specific options and properties.

Step 1: Dowload the schema file (.CSV) for your load type (Get Schema).
Step 2: Update the .CSV file on your local machine (add your data).
Step 3: Upload the .CSV file. This step will create the job & import tasks and your data will be send to Cornerstone (Load Data).
Step 4: Check the result in the Bulk API History page in Cornerstone (Admin > Tools > Edge > Bulk API History) or by using the available Bulk API's.

Prerequisites: Read the Considerations before using the Bulk API.

Individual

For experienced users: Build your own individual query (POST/PATCH/PUT) to return Cornerstone data from any available web service, or send (Update) your own JSON string to any Cornerstone web service.

xAPI

Capture and return learning experiences using xAPI and Cornerstone's Learning Record Store (LRS).

Webhooks

Show captured webhook events (latest 1000 records from the last 24 hours).