Cornerstone OnDemand
App · 25 actions
Run learning and people data in Cornerstone OnDemand: add and update employees, search the catalog, assign, register and complete training on transcripts, read rosters and reports.
Actions
| Action | What it does |
|---|---|
| Approve or deny training | Approve or deny a training request that's pending approval. |
| Archive training | Move a training to a person's archived transcript, or back out of it. |
| Assign training | Put a training on a person's transcript, as a manager or learning admin would, with an optional due date. |
| Complete training | Mark a training complete on a person's transcript, with an optional date and score. |
| Create employee | Add a user to the portal, with their OUs, manager and custom fields. |
| Exempt from training | Mark a person exempt from a training that isn't completed. |
| Get employee | Get one user's record, with their organizational units and custom fields. |
| Get organizational unit | Get one organizational unit, with its parent, owner and custom fields. |
| Get session roster | See who is registered for, or pending on, an instructor-led session, with seats left. |
| Get training | Get a training's details and a link that opens it, as offered to a person (curricula, events, sessions, materials, tests, videos and online courses). |
| Get transcript training | Get one training on a person's transcript in full: status, dates, score and how it was assigned. |
| Get user's transcript | List the trainings on a person's transcript and where each stands, filtered by status, type or title. |
| List employees | Find users in the portal by name, username, User ID, status, OU or when they were added or changed. |
| List organizational units | Find divisions, locations, positions, cost centers and the portal's other organizational units by name or type. |
| Mark training in progress | Move a registered training on a person's transcript to In Progress. |
| Query a report view | Read rows from one of the Reporting API's views (users, transcripts, trainings, OUs and more), with an OData filter. |
| Register for training | Register a person for a training that's approved on their transcript. |
| Remove training | Move a training to the Removed tab of a person's transcript, or restore a removed one. |
| Request training | Request a training for a person, as if they asked for it themselves; it then follows the portal's approval steps. |
| Search the catalog | Find trainings in the learning catalog by title, type, subject, provider or when they were added. |
| Search transcripts | Find transcript records across the portal that reached a status, or for one training, within one day (the last 24 hours by default). |
| Update employee | Change a user's details, OUs, manager or custom fields, or deactivate them. |
| Update employment status | Change a user's employment status or user type, or record their termination (Cornerstone HR portals). |
| Update transcript training | Change the due date or the transcript custom fields of a training on a person's transcript. |
| Withdraw from session | Withdraw a person from an instructor-led session they're registered for. |
Approve or deny training
Approve or deny a training request that's pending approval. Each call moves it one approval step.
Inputs
- User
usertextRequired - The person, by the User ID on their user record (or what 'Find user by' says).
- Training
learning_object_idtextRequired - The training's learning object id, a GUID, from 'Search the catalog', a transcript or the training's address in Cornerstone.
- Find user by
user_keytext - What 'User' holds. Defaults to the User ID on their user record.One of:
external_id(User ID (as on the user record)),user_name(Username),employee_id(Employee number from Cornerstone (id)),guid(User GUID). Default:external_id. - Decision
decisiontextRequired - Approve or deny the request.One of:
approve,deny. - Approver
approver_idtextRequired - The approver's numeric employee id.
- Comment
commenttextRequired - A comment for the transcript history.
- Send Cornerstone's emails
send_emailstrue/false - Turn on to send the emails the portal has set up for this change.
Outputs
donetrue/false- True once Cornerstone accepted the change
itemobject- The training on the transcript, read back (empty if it couldn't be read)
learning_object_idtext- The training's learning object id
Example output
{
"done": true,
"item": {
"assignedByUserId": 37,
"assignedDate": "2026-03-05T10:00:00",
"completedDate": null,
"deliveryMethod": "DirectAssignment",
"dueDate": "2026-04-30T00:00:00",
"externalId": "tsmith482",
"isArchived": false,
"isRemoved": false,
"isRequired": true,
"lastModifiedDate": "2026-03-05T10:00:00",
"learningObjectId": "7ad38cb9-04e1-47be-8334-09a4484f82ad",
"learningTitle": "Workplace Safety Basics",
"passed": null,
"registrationDate": "2026-03-05T10:00:00",
"registrationNumber": 1,
"score": null,
"status": "Registered",
"statusChangeDate": "2026-03-05T10:00:00",
"statusGroup": "In Progress",
"trainingHours": "0.75",
"trainingType": "OnlineClass",
"userId": "48928"
},
"learning_object_id": "7ad38cb9-04e1-47be-8334-09a4484f82ad"
}Archive training
Move a training to a person's archived transcript, or back out of it.
Inputs
- User
usertextRequired - The person, by the User ID on their user record (or what 'Find user by' says).
- Training
learning_object_idtextRequired - The training's learning object id, a GUID, from 'Search the catalog', a transcript or the training's address in Cornerstone.
- Find user by
user_keytext - What 'User' holds. Defaults to the User ID on their user record.One of:
external_id(User ID (as on the user record)),user_name(Username),employee_id(Employee number from Cornerstone (id)),guid(User GUID). Default:external_id. - Archive or unarchive
operationtext - Whether to archive the training or bring it back.One of:
archive(Move to the archived transcript),unarchive(Move back from the archive). Default:archive.
Outputs
donetrue/false- True once Cornerstone accepted the change
itemobject- The training on the transcript, read back (empty if it couldn't be read)
learning_object_idtext- The training's learning object id
Example output
{
"done": true,
"item": {
"assignedByUserId": 37,
"assignedDate": "2026-03-05T10:00:00",
"completedDate": null,
"deliveryMethod": "DirectAssignment",
"dueDate": "2026-04-30T00:00:00",
"externalId": "tsmith482",
"isArchived": false,
"isRemoved": false,
"isRequired": true,
"lastModifiedDate": "2026-03-05T10:00:00",
"learningObjectId": "7ad38cb9-04e1-47be-8334-09a4484f82ad",
"learningTitle": "Workplace Safety Basics",
"passed": null,
"registrationDate": "2026-03-05T10:00:00",
"registrationNumber": 1,
"score": null,
"status": "Registered",
"statusChangeDate": "2026-03-05T10:00:00",
"statusGroup": "In Progress",
"trainingHours": "0.75",
"trainingType": "OnlineClass",
"userId": "48928"
},
"learning_object_id": "7ad38cb9-04e1-47be-8334-09a4484f82ad"
}Assign training
Put a training on a person's transcript, as a manager or learning admin would, with an optional due date.
Inputs
- User
usertextRequired - The person, by the User ID on their user record (or what 'Find user by' says).
- Training
learning_object_idtextRequired - The training's learning object id, a GUID, from 'Search the catalog', a transcript or the training's address in Cornerstone.
- Find user by
user_keytext - What 'User' holds. Defaults to the User ID on their user record.One of:
external_id(User ID (as on the user record)),user_name(Username),employee_id(Employee number from Cornerstone (id)),guid(User GUID). Default:external_id. - Assign as
assignmenttextRequired - How far to take it: assigned, approved too, or registered too.One of:
assigned(Assigned only),approved(Assigned and approved),registered(Assigned, approved and registered). - Due date
due_datedate - When it's due. Must not be in the past.
- Available from
available_datedate - When it becomes available. Defaults to now.
- Training purpose
purposetext - The purpose, by its English name, if the portal asks for one.
- Comment
commenttext - A comment for the transcript history.
- Assign again if they have it
assign_new_occurrencetrue/false - Turn on to add a new occurrence for someone who already has it.
- Send Cornerstone's emails
send_emailstrue/false - Turn on to send the emails the portal has set up for this change.
Outputs
donetrue/false- True once Cornerstone accepted the change
itemobject- The training on the transcript, read back (empty if it couldn't be read)
learning_object_idtext- The training's learning object id
Example output
{
"done": true,
"item": {
"assignedByUserId": 37,
"assignedDate": "2026-03-05T10:00:00",
"completedDate": null,
"deliveryMethod": "DirectAssignment",
"dueDate": "2026-04-30T00:00:00",
"externalId": "tsmith482",
"isArchived": false,
"isRemoved": false,
"isRequired": true,
"lastModifiedDate": "2026-03-05T10:00:00",
"learningObjectId": "7ad38cb9-04e1-47be-8334-09a4484f82ad",
"learningTitle": "Workplace Safety Basics",
"passed": null,
"registrationDate": "2026-03-05T10:00:00",
"registrationNumber": 1,
"score": null,
"status": "Registered",
"statusChangeDate": "2026-03-05T10:00:00",
"statusGroup": "In Progress",
"trainingHours": "0.75",
"trainingType": "OnlineClass",
"userId": "48928"
},
"learning_object_id": "7ad38cb9-04e1-47be-8334-09a4484f82ad"
}Complete training
Mark a training complete on a person's transcript, with an optional date and score. Not for sessions or curricula.
Inputs
- User
usertextRequired - The person, by the User ID on their user record (or what 'Find user by' says).
- Training
learning_object_idtextRequired - The training's learning object id, a GUID, from 'Search the catalog', a transcript or the training's address in Cornerstone.
- Find user by
user_keytext - What 'User' holds. Defaults to the User ID on their user record.One of:
external_id(User ID (as on the user record)),user_name(Username),employee_id(Employee number from Cornerstone (id)),guid(User GUID). Default:external_id. - Completed at
completed_atdate and time - When they completed it. Defaults to now.
- Score
scorenumber - Their score, 0 to 100, for tests and online classes.From 0 to 100.
- Follow the portal's workflow
follow_workflowtrue/false - Turn on to go through any completion steps the portal has set (such as an evaluation) instead of marking it Completed outright.
- Comment
commenttext - A comment for the transcript history.
- Send Cornerstone's emails
send_emailstrue/false - Turn on to send the emails the portal has set up for this change.
Outputs
donetrue/false- True once Cornerstone accepted the change
itemobject- The training on the transcript, read back (empty if it couldn't be read)
learning_object_idtext- The training's learning object id
Example output
{
"done": true,
"item": {
"assignedByUserId": 37,
"assignedDate": "2026-03-05T10:00:00",
"completedDate": null,
"deliveryMethod": "DirectAssignment",
"dueDate": "2026-04-30T00:00:00",
"externalId": "tsmith482",
"isArchived": false,
"isRemoved": false,
"isRequired": true,
"lastModifiedDate": "2026-03-05T10:00:00",
"learningObjectId": "7ad38cb9-04e1-47be-8334-09a4484f82ad",
"learningTitle": "Workplace Safety Basics",
"passed": null,
"registrationDate": "2026-03-05T10:00:00",
"registrationNumber": 1,
"score": null,
"status": "Registered",
"statusChangeDate": "2026-03-05T10:00:00",
"statusGroup": "In Progress",
"trainingHours": "0.75",
"trainingType": "OnlineClass",
"userId": "48928"
},
"learning_object_id": "7ad38cb9-04e1-47be-8334-09a4484f82ad"
}Create employee
Add a user to the portal, with their OUs, manager and custom fields.
Inputs
- User ID
external_idtextRequired - The User ID on their user record, unique in the portal.
- Username
user_nametextRequired - What they sign in with.
- First name
first_nametextRequired - First name.
- Last name
last_nametextRequired - Last name.
- Middle name
middle_nametext - Middle name.
- Email
primary_emailtext - Their work email address.
- Work phone
work_phonetext - Work phone number.
- Mobile phone
mobile_phonetext - Mobile phone number.
- Manager
manager_idtext - Their manager's numeric employee id.
- Training approver
approver_idtext - The numeric employee id of who approves their training.
- Original hire date
original_hire_datedate - When first hired.
- Latest hire date
last_hire_datedate - When last hired.
- Street address
address_line1text - First line of the address.
- City
citytext - City.
- State or province
statetext - State or province.
- ZIP or postal code
postal_codetext - ZIP or postal code.
- Country
countrytext - Country, such as USA.
- Organizational units
ou_idslist - Their division, location, position and other OUs, one of each type. Your portal may require some types.
- Custom fields
custom_fieldsobject - Values for the user record's custom fields.
Outputs
employeeobject- The employee, read back
idnumber- The employee's numeric id
Example output
{
"employee": {
"address": {
"city": "Santa Monica",
"country": "USA",
"line1": "1601 Cloverfield Blvd",
"line2": null,
"state": "CA",
"zipCode": "90404"
},
"approverId": null,
"customFields": [
{
"id": 37,
"value": "123919"
}
],
"employeeMetaData": {
"createdDate": "2020-07-05T06:33:02.000Z",
"modifiedDate": "2020-07-06T12:22:00.000Z"
},
"externalId": "tsmith482",
"firstName": "Thomas",
"guid": "2eca8706-e070-4bfd-b8be-0972234354ab",
"id": 48928,
"lastName": "Smith",
"managerId": 37,
"middleName": "Paul",
"mobilePhone": null,
"ous": [
{
"id": 9025,
"typeId": 2
}
],
"personalEmail": null,
"primaryEmail": "t@example.com",
"settings": {
"displayLanguage": "en-US",
"timeZone": "(UTC-08:00) Pacific Time"
},
"userName": "thomas.smith",
"workPhone": "3105551234",
"workerStatus": {
"absent": false,
"active": true,
"lastHireDate": "2018-12-31",
"originalHireDate": "2018-12-31"
}
},
"id": 48928
}Exempt from training
Mark a person exempt from a training that isn't completed.
Inputs
- User
usertextRequired - The person, by the User ID on their user record (or what 'Find user by' says).
- Training
learning_object_idtextRequired - The training's learning object id, a GUID, from 'Search the catalog', a transcript or the training's address in Cornerstone.
- Find user by
user_keytext - What 'User' holds. Defaults to the User ID on their user record.One of:
external_id(User ID (as on the user record)),user_name(Username),employee_id(Employee number from Cornerstone (id)),guid(User GUID). Default:external_id. - Reason
reasontextRequired - The exemption reason, exactly as named in the portal's list of reasons (in English), such as Other.
- Comment
commenttextRequired - A comment for the transcript history.
- Send Cornerstone's emails
send_emailstrue/false - Turn on to send the emails the portal has set up for this change.
Outputs
donetrue/false- True once Cornerstone accepted the change
itemobject- The training on the transcript, read back (empty if it couldn't be read)
learning_object_idtext- The training's learning object id
Example output
{
"done": true,
"item": {
"assignedByUserId": 37,
"assignedDate": "2026-03-05T10:00:00",
"completedDate": null,
"deliveryMethod": "DirectAssignment",
"dueDate": "2026-04-30T00:00:00",
"externalId": "tsmith482",
"isArchived": false,
"isRemoved": false,
"isRequired": true,
"lastModifiedDate": "2026-03-05T10:00:00",
"learningObjectId": "7ad38cb9-04e1-47be-8334-09a4484f82ad",
"learningTitle": "Workplace Safety Basics",
"passed": null,
"registrationDate": "2026-03-05T10:00:00",
"registrationNumber": 1,
"score": null,
"status": "Registered",
"statusChangeDate": "2026-03-05T10:00:00",
"statusGroup": "In Progress",
"trainingHours": "0.75",
"trainingType": "OnlineClass",
"userId": "48928"
},
"learning_object_id": "7ad38cb9-04e1-47be-8334-09a4484f82ad"
}Get employee
Get one user's record, with their organizational units and custom fields.
Inputs
- Employee
employee_idtextRequired - Cornerstone's numeric id for the employee, from 'List employees' or a trigger. (Not their User ID.)
Outputs
employeeobject- The employee
Example output
{
"employee": {
"address": {
"city": "Santa Monica",
"country": "USA",
"line1": "1601 Cloverfield Blvd",
"line2": null,
"state": "CA",
"zipCode": "90404"
},
"approverId": null,
"customFields": [
{
"id": 37,
"value": "123919"
}
],
"employeeMetaData": {
"createdDate": "2020-07-05T06:33:02.000Z",
"modifiedDate": "2020-07-06T12:22:00.000Z"
},
"externalId": "tsmith482",
"firstName": "Thomas",
"guid": "2eca8706-e070-4bfd-b8be-0972234354ab",
"id": 48928,
"lastName": "Smith",
"managerId": 37,
"middleName": "Paul",
"mobilePhone": null,
"ous": [
{
"id": 9025,
"typeId": 2
}
],
"personalEmail": null,
"primaryEmail": "t@example.com",
"settings": {
"displayLanguage": "en-US",
"timeZone": "(UTC-08:00) Pacific Time"
},
"userName": "thomas.smith",
"workPhone": "3105551234",
"workerStatus": {
"absent": false,
"active": true,
"lastHireDate": "2018-12-31",
"originalHireDate": "2018-12-31"
}
}
}Get organizational unit
Get one organizational unit, with its parent, owner and custom fields.
Inputs
- Organizational unit
ou_idtextRequired - The OU. Pick one, or give its numeric id.
Outputs
ouobject- The organizational unit
Example output
{
"ou": {
"active": true,
"description": "The Integration and Services division",
"externalId": "d04523",
"id": 9025,
"name": "Integration and Services",
"ownerId": 123,
"parentId": 186,
"reconcilable": true,
"typeId": 2
}
}Get session roster
See who is registered for, or pending on, an instructor-led session, with seats left. Give one of the session's ids; 25 people at a time.
Inputs
- Session
session_idtext - The session's learning object id (a GUID).
- Session number
session_numbertext - The session's number.
- Locator
locatornumber - The session's locator number.At least 1.
- Roster status
statustext - Only people with this status on the roster.One of:
Registered,Completed,Incomplete,Withdrawn,No Show. - Page
pagenumber - Which page of people to get, from 1. Use the 'next_page' an earlier run gave.At least 1.
Outputs
countnumber- How many people are on this page
next_pagenumber- The next page's number, or 0 on the last
pagenumber- This page's number
pending_userslist- People pending a place
seats_availablenumber- Seats still free
total_seatsnumber- Seats in the session
userslist- People on the roster
Example output
{
"count": 1,
"next_page": 0,
"page": 1,
"pending_users": [
{
"Locator": 1042,
"UserFullName": "Jane Doe",
"UserId": "jdoe"
}
],
"seats_available": 19,
"total_seats": 20,
"users": [
{
"Locator": 1042,
"Passed": false,
"Score": 0,
"SessionCompletionDate": null,
"Status": "Registered",
"UserFullName": "Thomas Smith",
"UserId": "tsmith482"
}
]
}Get training
Get a training's details and a link that opens it, as offered to a person (curricula, events, sessions, materials, tests, videos and online courses).
Inputs
- Training
learning_object_idtextRequired - The training's learning object id, a GUID, from 'Search the catalog', a transcript or the training's address in Cornerstone.
- As seen by
available_to_usertext - The User ID of someone it's available to. Leave empty for the connection's own user.
Outputs
trainingobject- The training
Example output
{
"training": {
"DeepLinkURL": "https://acme.csod.com/DeepLink/ProcessRedirect.aspx?module=lodetails&lo=7ad38cb9-04e1-47be-8334-09a4484f82ad",
"Descr": "An introduction to safety at work.",
"Duration": "45 minutes",
"ObjectId": "7ad38cb9-04e1-47be-8334-09a4484f82ad",
"Provider": "Acme Learning",
"Title": "Workplace Safety Basics",
"Type": "Online Course"
}
}Get transcript training
Get one training on a person's transcript in full: status, dates, score and how it was assigned.
Inputs
- User
usertextRequired - The person, by the User ID on their user record (or what 'Find user by' says).
- Training
learning_object_idtextRequired - The training's learning object id, a GUID, from 'Search the catalog', a transcript or the training's address in Cornerstone.
- Find user by
user_keytext - What 'User' holds. Defaults to the User ID on their user record.One of:
external_id(User ID (as on the user record)),user_name(Username),employee_id(Employee number from Cornerstone (id)),guid(User GUID). Default:external_id. - Registration number
registration_numbernumber - Which time they took it. Leave empty for the latest.At least 1.
Outputs
itemobject- The training
Example output
{
"item": {
"assignedByUserId": 37,
"assignedDate": "2026-03-05T10:00:00",
"completedDate": null,
"deliveryMethod": "DirectAssignment",
"dueDate": "2026-04-30T00:00:00",
"externalId": "tsmith482",
"isArchived": false,
"isRemoved": false,
"isRequired": true,
"lastModifiedDate": "2026-03-05T10:00:00",
"learningObjectId": "7ad38cb9-04e1-47be-8334-09a4484f82ad",
"learningTitle": "Workplace Safety Basics",
"passed": null,
"registrationDate": "2026-03-05T10:00:00",
"registrationNumber": 1,
"score": null,
"status": "Registered",
"statusChangeDate": "2026-03-05T10:00:00",
"statusGroup": "In Progress",
"trainingHours": "0.75",
"trainingType": "OnlineClass",
"userId": "48928"
}
}Get user's transcript
List the trainings on a person's transcript and where each stands, filtered by status, type or title.
Inputs
- User
usertextRequired - The person, by the User ID on their user record (or what 'Find user by' says).
- Find user by
user_keytext - What 'User' holds. Defaults to the User ID on their user record.One of:
external_id(User ID (as on the user record)),user_name(Username),employee_id(Employee number from Cornerstone (id)),guid(User GUID). Default:external_id. - Status
status_groupslist - Only trainings in these states. Leave empty for all.One or more of:
NotStarted(Not started),InProgress(In progress),Completed,Other. - Training types
training_typeslist - Only these kinds of training. Leave empty for all.One or more of:
OnlineClass(Online class),QuickCourse(Quick course),OnlineContent(Online content),Curriculum,Event,Session,Material,Test,Video,ExternalTraining(External training), and 4 more. - Title contains
searchtext - Only trainings whose title contains this.
- Changed since
modified_sincedate - Only trainings changed on or after this date.
- Include archived
include_archivedtrue/false - Turn on to include archived trainings.
- Include removed
include_removedtrue/false - Turn on to include removed trainings.
- Required only
required_onlytrue/false - Turn on for required trainings only.
- Next page token
page_tokentext - For the next page, the 'next_page_token' an earlier run gave.
Outputs
countnumber- How many are on this page
itemslist- The trainings on the transcript
next_page_tokentext- Give this to the next run for the next page; empty on the last
totalnumber- How many match in all
Example output
{
"count": 1,
"items": [
{
"assignedDate": "2026-03-05T10:00:00",
"completedDate": null,
"dueDate": "2026-04-30T00:00:00",
"externalId": "tsmith482",
"isArchived": false,
"isRemoved": false,
"isRequired": true,
"lastModifiedDate": "2026-03-05T10:00:00",
"learningObjectId": "7ad38cb9-04e1-47be-8334-09a4484f82ad",
"learningTitle": "Workplace Safety Basics",
"providerName": "Acme Learning",
"registrationDate": "2026-03-05T10:00:00",
"registrationNumber": 1,
"status": "Registered",
"statusGroups": "In Progress",
"trainingPurpose": null,
"trainingType": "OnlineClass",
"userGuid": "2eca8706-e070-4bfd-b8be-0972234354ab",
"userId": "48928"
}
],
"next_page_token": "",
"total": 1
}List employees
Find users in the portal by name, username, User ID, status, OU or when they were added or changed. Gets one page; for more, run it again with the next page token it gives.
Inputs
- First name
first_nametext - Only users with this first name.
- Last name
last_nametext - Only users with this last name.
- Username
user_nametext - Only the user with this username.
- User ID
external_idtext - Only the user with this User ID.
- Status
statustext - Which users to include. Defaults to active ones.One of:
Active(Active (default)),InActive,PendingApproval(Pending approval),All. Default:Active. - Organizational units
ou_idslist - Only users in any of these OUs.
- Added since
created_sincedate - Only users added on or after this date.
- Changed since
modified_sincedate - Only users whose record's effective change date is on or after this date.
- Page size
page_sizenumber - How many to return, 1 to 1000. Cornerstone's default is 50 (100 for OUs).From 1 to 1000.
- Next page token
next_page_tokentext - For the next page, the 'next_page_token' an earlier run gave, with the same filters. It lasts 5 minutes.
Outputs
countnumber- How many are on this page
employeeslist- The employees
next_page_tokentext- Give this to the next run for the next page; empty on the last
Example output
{
"count": 1,
"employees": [
{
"address": {
"city": "Santa Monica",
"country": "USA",
"line1": "1601 Cloverfield Blvd",
"line2": null,
"state": "CA",
"zipCode": "90404"
},
"approverId": null,
"customFields": [
{
"id": 37,
"value": "123919"
}
],
"employeeMetaData": {
"createdDate": "2020-07-05T06:33:02.000Z",
"modifiedDate": "2020-07-06T12:22:00.000Z"
},
"externalId": "tsmith482",
"firstName": "Thomas",
"guid": "2eca8706-e070-4bfd-b8be-0972234354ab",
"id": 48928,
"lastName": "Smith",
"managerId": 37,
"middleName": "Paul",
"mobilePhone": null,
"ous": [
{
"id": 9025,
"typeId": 2
}
],
"personalEmail": null,
"primaryEmail": "t@example.com",
"settings": {
"displayLanguage": "en-US",
"timeZone": "(UTC-08:00) Pacific Time"
},
"userName": "thomas.smith",
"workPhone": "3105551234",
"workerStatus": {
"absent": false,
"active": true,
"lastHireDate": "2018-12-31",
"originalHireDate": "2018-12-31"
}
}
],
"next_page_token": ""
}List organizational units
Find divisions, locations, positions, cost centers and the portal's other organizational units by name or type.
Inputs
- Name
nametext - Only OUs whose name contains this.
- Type
type_idtext - Only OUs of this type, such as Division or Location.
- OU ID
external_idtext - Only the OU with this ID of your own.
- Include inactive
include_inactivetrue/false - Turn on to include OUs marked inactive.
- Page size
page_sizenumber - How many to return, 1 to 1000. Cornerstone's default is 50 (100 for OUs).From 1 to 1000.
- Next page token
next_page_tokentext - For the next page, the 'next_page_token' an earlier run gave, with the same filters. It lasts 5 minutes.
Outputs
countnumber- How many are on this page
next_page_tokentext- Give this to the next run for the next page; empty on the last
ouslist- The organizational units
Example output
{
"count": 1,
"next_page_token": "",
"ous": [
{
"active": true,
"description": "The Integration and Services division",
"externalId": "d04523",
"id": 9025,
"name": "Integration and Services",
"ownerId": 123,
"parentId": 186,
"reconcilable": true,
"typeId": 2
}
]
}Mark training in progress
Move a registered training on a person's transcript to In Progress.
Inputs
- User
usertextRequired - The person, by the User ID on their user record (or what 'Find user by' says).
- Training
learning_object_idtextRequired - The training's learning object id, a GUID, from 'Search the catalog', a transcript or the training's address in Cornerstone.
- Find user by
user_keytext - What 'User' holds. Defaults to the User ID on their user record.One of:
external_id(User ID (as on the user record)),user_name(Username),employee_id(Employee number from Cornerstone (id)),guid(User GUID). Default:external_id.
Outputs
donetrue/false- True once Cornerstone accepted the change
itemobject- The training on the transcript, read back (empty if it couldn't be read)
learning_object_idtext- The training's learning object id
Example output
{
"done": true,
"item": {
"assignedByUserId": 37,
"assignedDate": "2026-03-05T10:00:00",
"completedDate": null,
"deliveryMethod": "DirectAssignment",
"dueDate": "2026-04-30T00:00:00",
"externalId": "tsmith482",
"isArchived": false,
"isRemoved": false,
"isRequired": true,
"lastModifiedDate": "2026-03-05T10:00:00",
"learningObjectId": "7ad38cb9-04e1-47be-8334-09a4484f82ad",
"learningTitle": "Workplace Safety Basics",
"passed": null,
"registrationDate": "2026-03-05T10:00:00",
"registrationNumber": 1,
"score": null,
"status": "Registered",
"statusChangeDate": "2026-03-05T10:00:00",
"statusGroup": "In Progress",
"trainingHours": "0.75",
"trainingType": "OnlineClass",
"userId": "48928"
},
"learning_object_id": "7ad38cb9-04e1-47be-8334-09a4484f82ad"
}Query a report view
Read rows from one of the Reporting API's views (users, transcripts, trainings, OUs and more), with an OData filter. Needs the Reporting API and the view's own scope.
Inputs
- View
viewtextRequired - The reporting view to read.One of:
vw_rpt_user(User (vw_rpt_user)),vw_rpt_user_cf(User cf (vw_rpt_user_cf)),vw_rpt_user_ou(User ou (vw_rpt_user_ou)),vw_rpt_user_ou_info(User ou info (vw_rpt_user_ou_info)),vw_rpt_user_ou_status(User ou status (vw_rpt_user_ou_status)),vw_rpt_user_ou_history(User ou history (vw_rpt_user_ou_history)),vw_rpt_user_groups(User groups (vw_rpt_user_groups)),vw_rpt_user_status(User status (vw_rpt_user_status)),vw_rpt_user_status_local(User status local (vw_rpt_user_status_local)),vw_rpt_user_dynamic_relation(User dynamic relation (vw_rpt_user_dynamic_relation)), and 88 more. - Filter
odata_filtertext - An OData filter, such as user_status_id eq 1 or user_lo_comp_dt ge 2026-01-01T00:00:00Z.
- Columns
columnstext - The columns to return, separated by commas, such as user_id,user_name_first. Leave empty for all.
- Sort by
order_bytext - A column to sort by, with desc to reverse.
- Rows
limitnumber - How many rows a page holds, 1 to 10,000. Defaults to 100.From 1 to 10000.
- Next page link
next_linktext - For the next page, the 'next_link' an earlier run gave.
Outputs
countnumber- How many rows are on this page
next_linktext- Give this to the next run for the next page; empty on the last
rowslist- The rows
Example output
{
"count": 1,
"next_link": "",
"rows": [
{
"user_id": 48928,
"user_name_first": "Thomas",
"user_name_last": "Smith",
"user_ref": "tsmith482"
}
]
}Register for training
Register a person for a training that's approved on their transcript.
Inputs
- User
usertextRequired - The person, by the User ID on their user record (or what 'Find user by' says).
- Training
learning_object_idtextRequired - The training's learning object id, a GUID, from 'Search the catalog', a transcript or the training's address in Cornerstone.
- Find user by
user_keytext - What 'User' holds. Defaults to the User ID on their user record.One of:
external_id(User ID (as on the user record)),user_name(Username),employee_id(Employee number from Cornerstone (id)),guid(User GUID). Default:external_id. - Comment
commenttext - A comment for the transcript history.
- Send Cornerstone's emails
send_emailstrue/false - Turn on to send the emails the portal has set up for this change.
Outputs
donetrue/false- True once Cornerstone accepted the change
itemobject- The training on the transcript, read back (empty if it couldn't be read)
learning_object_idtext- The training's learning object id
Example output
{
"done": true,
"item": {
"assignedByUserId": 37,
"assignedDate": "2026-03-05T10:00:00",
"completedDate": null,
"deliveryMethod": "DirectAssignment",
"dueDate": "2026-04-30T00:00:00",
"externalId": "tsmith482",
"isArchived": false,
"isRemoved": false,
"isRequired": true,
"lastModifiedDate": "2026-03-05T10:00:00",
"learningObjectId": "7ad38cb9-04e1-47be-8334-09a4484f82ad",
"learningTitle": "Workplace Safety Basics",
"passed": null,
"registrationDate": "2026-03-05T10:00:00",
"registrationNumber": 1,
"score": null,
"status": "Registered",
"statusChangeDate": "2026-03-05T10:00:00",
"statusGroup": "In Progress",
"trainingHours": "0.75",
"trainingType": "OnlineClass",
"userId": "48928"
},
"learning_object_id": "7ad38cb9-04e1-47be-8334-09a4484f82ad"
}Remove training
Move a training to the Removed tab of a person's transcript, or restore a removed one.
Inputs
- User
usertextRequired - The person, by the User ID on their user record (or what 'Find user by' says).
- Training
learning_object_idtextRequired - The training's learning object id, a GUID, from 'Search the catalog', a transcript or the training's address in Cornerstone.
- Find user by
user_keytext - What 'User' holds. Defaults to the User ID on their user record.One of:
external_id(User ID (as on the user record)),user_name(Username),employee_id(Employee number from Cornerstone (id)),guid(User GUID). Default:external_id. - Remove or restore
operationtext - Whether to remove the training or restore it.One of:
remove(Remove from the transcript),restore(Restore a removed training). Default:remove. - Reason
reasontext - Needed to remove: the reason exactly as named in the portal's list (in English), such as Other.
- Comment
commenttext - Needed to remove: a comment for the transcript history.
Outputs
donetrue/false- True once Cornerstone accepted the change
itemobject- The training on the transcript, read back (empty if it couldn't be read)
learning_object_idtext- The training's learning object id
Example output
{
"done": true,
"item": {
"assignedByUserId": 37,
"assignedDate": "2026-03-05T10:00:00",
"completedDate": null,
"deliveryMethod": "DirectAssignment",
"dueDate": "2026-04-30T00:00:00",
"externalId": "tsmith482",
"isArchived": false,
"isRemoved": false,
"isRequired": true,
"lastModifiedDate": "2026-03-05T10:00:00",
"learningObjectId": "7ad38cb9-04e1-47be-8334-09a4484f82ad",
"learningTitle": "Workplace Safety Basics",
"passed": null,
"registrationDate": "2026-03-05T10:00:00",
"registrationNumber": 1,
"score": null,
"status": "Registered",
"statusChangeDate": "2026-03-05T10:00:00",
"statusGroup": "In Progress",
"trainingHours": "0.75",
"trainingType": "OnlineClass",
"userId": "48928"
},
"learning_object_id": "7ad38cb9-04e1-47be-8334-09a4484f82ad"
}Request training
Request a training for a person, as if they asked for it themselves; it then follows the portal's approval steps.
Inputs
- User
usertextRequired - The person, by the User ID on their user record (or what 'Find user by' says).
- Training
learning_object_idtextRequired - The training's learning object id, a GUID, from 'Search the catalog', a transcript or the training's address in Cornerstone.
- Find user by
user_keytext - What 'User' holds. Defaults to the User ID on their user record.One of:
external_id(User ID (as on the user record)),user_name(Username),employee_id(Employee number from Cornerstone (id)),guid(User GUID). Default:external_id. - Training purpose
purposetext - The purpose, by its English name, if the portal asks for one.
- Send Cornerstone's emails
send_emailstrue/false - Turn on to send the emails the portal has set up for this change.
Outputs
donetrue/false- True once Cornerstone accepted the change
itemobject- The training on the transcript, read back (empty if it couldn't be read)
learning_object_idtext- The training's learning object id
Example output
{
"done": true,
"item": {
"assignedByUserId": 37,
"assignedDate": "2026-03-05T10:00:00",
"completedDate": null,
"deliveryMethod": "DirectAssignment",
"dueDate": "2026-04-30T00:00:00",
"externalId": "tsmith482",
"isArchived": false,
"isRemoved": false,
"isRequired": true,
"lastModifiedDate": "2026-03-05T10:00:00",
"learningObjectId": "7ad38cb9-04e1-47be-8334-09a4484f82ad",
"learningTitle": "Workplace Safety Basics",
"passed": null,
"registrationDate": "2026-03-05T10:00:00",
"registrationNumber": 1,
"score": null,
"status": "Registered",
"statusChangeDate": "2026-03-05T10:00:00",
"statusGroup": "In Progress",
"trainingHours": "0.75",
"trainingType": "OnlineClass",
"userId": "48928"
},
"learning_object_id": "7ad38cb9-04e1-47be-8334-09a4484f82ad"
}Search the catalog
Find trainings in the learning catalog by title, type, subject, provider or when they were added. Gets 25 at a time.
Inputs
- Title
titletext - Only trainings with this title.
- Training types
training_typeslist - Only these kinds of training. Leave empty for all.One or more of:
Course(Online class),SCO(Quick course),Curriculum,Event,Material,Test,Video,Library,SocialLearningProgram(Program). - Subject
subjecttext - Only trainings in this subject.
- Provider
training_providertext - Only trainings from this provider.
- Added from
created_fromdate - Only trainings added on or after this date.
- Added to
created_todate - Only trainings added on or before this date.
- Available to user
available_to_usertext - Only trainings this person can take, by their User ID.
- Include inactive
include_inactivetrue/false - Turn on to include inactive trainings.
- Page
pagenumber - Which page of trainings to get, from 1. Use the 'next_page' an earlier run gave.At least 1.
Outputs
countnumber- How many are on this page
next_pagenumber- The next page's number, or 0 on the last
pagenumber- This page's number
totalnumber- How many match in all
trainingslist- The trainings on this page
Example output
{
"count": 1,
"next_page": 0,
"page": 1,
"total": 1,
"trainings": [
{
"CreateDate": "2026-03-02T17:15:00",
"Description": "An introduction to safety at work.",
"Duration": 45,
"ModifyDate": "2026-03-04T09:00:00",
"ObjectId": "7ad38cb9-04e1-47be-8334-09a4484f82ad",
"Price": 0,
"Provider": "Acme Learning",
"Title": "Workplace Safety Basics",
"TrainingSubType": "",
"TrainingType": "Course",
"Version": "1"
}
]
}Search transcripts
Find transcript records across the portal that reached a status, or for one training, within one day (the last 24 hours by default). Active users only; 50 at a time.
Inputs
- Status
statustext - Only records in this status. Needed unless a training is given.One of:
Completed,Registered,Started(In progress),Approved,Granted Waitlist(Waitlisted),Denied,Cancelled,Withdrawn,Marked Exempt(Exempt),Marked Incomplete(Incomplete), and 8 more. - Training
learning_object_idtext - Only this training, by its learning object id.
- Training type
lo_typetext - Only this kind of training.One of:
Online Class,Quick Course,Curriculum,Event,Session,Material,Test,Video,External Training,Library, and 6 more. - User
usertext - Only this person, by their User ID.
- Changed from
modified_fromdate and time - Start of the period, at most a day before its end.
- Changed to
modified_todate and time - End of the period. Defaults to a day after its start, or now.
- Page
pagenumber - Which page of records to get, from 1. Use the 'next_page' an earlier run gave.At least 1.
Outputs
countnumber- How many are on this page
modified_fromtext- Start of the period searched (UTC)
modified_totext- End of the period searched (UTC)
next_pagenumber- The next page's number, or 0 on the last
pagenumber- This page's number
total_pagesnumber- How many pages match
transcriptslist- The transcript records
Example output
{
"count": 1,
"modified_from": "2026-03-06T00:00:00",
"modified_to": "2026-03-06T23:59:59",
"next_page": 0,
"page": 1,
"total_pages": 1,
"transcripts": [
{
"ActionDates": {
"AssignedDate": "2026-03-05T10:00:00",
"CompletionDate": "2026-03-06T15:20:00",
"DueDate": "2026-04-30T00:00:00",
"ModificationDate": "2026-03-06T15:20:00",
"RegistrationDate": "2026-03-05T10:00:00",
"StatusChangeDate": "2026-03-06T15:20:00"
},
"AssignorId": "jdoe",
"CourseId": "SAFE-101",
"CourseName": "Workplace Safety Basics",
"LOID": "7ad38cb9-04e1-47be-8334-09a4484f82ad",
"LOType": "Online Class",
"RegNum": 1,
"Score": 92,
"TrainingTime": "00:45:00",
"TranscriptStatus": "Completed",
"UserID": "tsmith482"
}
]
}Update employee
Change a user's details, OUs, manager or custom fields, or deactivate them. Only the fields given change.
Inputs
- Employee
employee_idtextRequired - Cornerstone's numeric id for the employee, from 'List employees' or a trigger. (Not their User ID.)
- User ID
external_idtext - The User ID on their user record, unique in the portal. Leave empty to keep it.
- Username
user_nametext - What they sign in with. Leave empty to keep it.
- First name
first_nametext - First name. Leave empty to keep it.
- Last name
last_nametext - Last name. Leave empty to keep it.
- Middle name
middle_nametext - Middle name. Leave empty to keep it.
- Email
primary_emailtext - Their work email address. Leave empty to keep it.
- Work phone
work_phonetext - Work phone number. Leave empty to keep it.
- Mobile phone
mobile_phonetext - Mobile phone number. Leave empty to keep it.
- Manager
manager_idtext - Their manager's numeric employee id. Leave empty to keep it.
- Training approver
approver_idtext - The numeric employee id of who approves their training. Leave empty to keep it.
- Original hire date
original_hire_datedate - When first hired. Leave empty to keep it.
- Latest hire date
last_hire_datedate - When last hired. Leave empty to keep it.
- Active
activetext - Choose No to deactivate the user, Yes to reactivate. Leave empty to keep it.One of:
yes,no. - Street address
address_line1text - First line of the address. Leave empty to keep it.
- City
citytext - City. Leave empty to keep it.
- State or province
statetext - State or province. Leave empty to keep it.
- ZIP or postal code
postal_codetext - ZIP or postal code. Leave empty to keep it.
- Country
countrytext - Country, such as USA. Leave empty to keep it.
- Organizational units
ou_idslist - Their division, location, position and other OUs, one of each type. An OU replaces the one of its type they had; others stay.
- Custom fields
custom_fieldsobject - Values for the user record's custom fields. Leave empty to keep it.
Outputs
employeeobject- The employee, read back
idnumber- The employee's numeric id
Example output
{
"employee": {
"address": {
"city": "Santa Monica",
"country": "USA",
"line1": "1601 Cloverfield Blvd",
"line2": null,
"state": "CA",
"zipCode": "90404"
},
"approverId": null,
"customFields": [
{
"id": 37,
"value": "123919"
}
],
"employeeMetaData": {
"createdDate": "2020-07-05T06:33:02.000Z",
"modifiedDate": "2020-07-06T12:22:00.000Z"
},
"externalId": "tsmith482",
"firstName": "Thomas",
"guid": "2eca8706-e070-4bfd-b8be-0972234354ab",
"id": 48928,
"lastName": "Smith",
"managerId": 37,
"middleName": "Paul",
"mobilePhone": null,
"ous": [
{
"id": 9025,
"typeId": 2
}
],
"personalEmail": null,
"primaryEmail": "t@example.com",
"settings": {
"displayLanguage": "en-US",
"timeZone": "(UTC-08:00) Pacific Time"
},
"userName": "thomas.smith",
"workPhone": "3105551234",
"workerStatus": {
"absent": false,
"active": true,
"lastHireDate": "2018-12-31",
"originalHireDate": "2018-12-31"
}
},
"id": 48928
}Update employment status
Change a user's employment status or user type, or record their termination (Cornerstone HR portals).
Inputs
- Employee
employee_idtextRequired - Cornerstone's numeric id for the employee, from 'List employees' or a trigger. (Not their User ID.)
- Employment status
employment_status_idtext - The new employment status. Leave empty to keep it.
- User type
category_idtext - The new user type (employment category). Leave empty to keep it.
- Termination date
termination_datedate - The day their employment ends, for a termination.
- Termination reason
termination_reason_idtext - Why they're leaving, for a termination.
- Eligible for rehire
eligible_for_rehiretext - For a termination: whether they may be rehired.One of:
yes,no. - Rehired
is_rehiredtext - Choose Yes when this person is being rehired.One of:
yes,no.
Outputs
employment_statusobject- Their employment status, read back
idnumber- The employee's numeric id
Example output
{
"employment_status": {
"categoryId": 2,
"employmentStatusId": 1,
"isRehiredEmployee": false,
"leaveStatusId": null,
"subCategoryId": null,
"terminationStatus": {
"eligibleForRehire": true,
"terminationDate": null,
"terminationReasonId": null
}
},
"id": 48928
}Update transcript training
Change the due date or the transcript custom fields of a training on a person's transcript. Not for completed trainings.
Inputs
- User
usertextRequired - The person, by the User ID on their user record (or what 'Find user by' says).
- Training
learning_object_idtextRequired - The training's learning object id, a GUID, from 'Search the catalog', a transcript or the training's address in Cornerstone.
- Find user by
user_keytext - What 'User' holds. Defaults to the User ID on their user record.One of:
external_id(User ID (as on the user record)),user_name(Username),employee_id(Employee number from Cornerstone (id)),guid(User GUID). Default:external_id. - Comment
commenttextRequired - A comment for the transcript history.
- Due date
due_datedate - The new due date, in the future.
- Custom fields
custom_fieldsobject - Transcript custom fields to set: each field's English name and its value.
Outputs
donetrue/false- True once Cornerstone accepted the change
itemobject- The training on the transcript, read back (empty if it couldn't be read)
learning_object_idtext- The training's learning object id
Example output
{
"done": true,
"item": {
"assignedByUserId": 37,
"assignedDate": "2026-03-05T10:00:00",
"completedDate": null,
"deliveryMethod": "DirectAssignment",
"dueDate": "2026-04-30T00:00:00",
"externalId": "tsmith482",
"isArchived": false,
"isRemoved": false,
"isRequired": true,
"lastModifiedDate": "2026-03-05T10:00:00",
"learningObjectId": "7ad38cb9-04e1-47be-8334-09a4484f82ad",
"learningTitle": "Workplace Safety Basics",
"passed": null,
"registrationDate": "2026-03-05T10:00:00",
"registrationNumber": 1,
"score": null,
"status": "Registered",
"statusChangeDate": "2026-03-05T10:00:00",
"statusGroup": "In Progress",
"trainingHours": "0.75",
"trainingType": "OnlineClass",
"userId": "48928"
},
"learning_object_id": "7ad38cb9-04e1-47be-8334-09a4484f82ad"
}Withdraw from session
Withdraw a person from an instructor-led session they're registered for.
Inputs
- User
usertextRequired - The person, by the User ID on their user record (or what 'Find user by' says).
- Training
learning_object_idtextRequired - The training's learning object id, a GUID, from 'Search the catalog', a transcript or the training's address in Cornerstone.
- Find user by
user_keytext - What 'User' holds. Defaults to the User ID on their user record.One of:
external_id(User ID (as on the user record)),user_name(Username),employee_id(Employee number from Cornerstone (id)),guid(User GUID). Default:external_id. - Reason
reasontextRequired - The withdrawal reason, exactly as named in the portal's list of reasons (in English), such as Other.
- Comment
commenttextRequired - A comment for the transcript history.
- Send Cornerstone's emails
send_emailstrue/false - Turn on to send the emails the portal has set up for this change.
Outputs
donetrue/false- True once Cornerstone accepted the change
itemobject- The training on the transcript, read back (empty if it couldn't be read)
learning_object_idtext- The training's learning object id
Example output
{
"done": true,
"item": {
"assignedByUserId": 37,
"assignedDate": "2026-03-05T10:00:00",
"completedDate": null,
"deliveryMethod": "DirectAssignment",
"dueDate": "2026-04-30T00:00:00",
"externalId": "tsmith482",
"isArchived": false,
"isRemoved": false,
"isRequired": true,
"lastModifiedDate": "2026-03-05T10:00:00",
"learningObjectId": "7ad38cb9-04e1-47be-8334-09a4484f82ad",
"learningTitle": "Workplace Safety Basics",
"passed": null,
"registrationDate": "2026-03-05T10:00:00",
"registrationNumber": 1,
"score": null,
"status": "Registered",
"statusChangeDate": "2026-03-05T10:00:00",
"statusGroup": "In Progress",
"trainingHours": "0.75",
"trainingType": "OnlineClass",
"userId": "48928"
},
"learning_object_id": "7ad38cb9-04e1-47be-8334-09a4484f82ad"
}