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

ActionWhat it does
Approve or deny trainingApprove or deny a training request that's pending approval.
Archive trainingMove a training to a person's archived transcript, or back out of it.
Assign trainingPut a training on a person's transcript, as a manager or learning admin would, with an optional due date.
Complete trainingMark a training complete on a person's transcript, with an optional date and score.
Create employeeAdd a user to the portal, with their OUs, manager and custom fields.
Exempt from trainingMark a person exempt from a training that isn't completed.
Get employeeGet one user's record, with their organizational units and custom fields.
Get organizational unitGet one organizational unit, with its parent, owner and custom fields.
Get session rosterSee who is registered for, or pending on, an instructor-led session, with seats left.
Get trainingGet 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 trainingGet one training on a person's transcript in full: status, dates, score and how it was assigned.
Get user's transcriptList the trainings on a person's transcript and where each stands, filtered by status, type or title.
List employeesFind users in the portal by name, username, User ID, status, OU or when they were added or changed.
List organizational unitsFind divisions, locations, positions, cost centers and the portal's other organizational units by name or type.
Mark training in progressMove a registered training on a person's transcript to In Progress.
Query a report viewRead rows from one of the Reporting API's views (users, transcripts, trainings, OUs and more), with an OData filter.
Register for trainingRegister a person for a training that's approved on their transcript.
Remove trainingMove a training to the Removed tab of a person's transcript, or restore a removed one.
Request trainingRequest a training for a person, as if they asked for it themselves; it then follows the portal's approval steps.
Search the catalogFind trainings in the learning catalog by title, type, subject, provider or when they were added.
Search transcriptsFind transcript records across the portal that reached a status, or for one training, within one day (the last 24 hours by default).
Update employeeChange a user's details, OUs, manager or custom fields, or deactivate them.
Update employment statusChange a user's employment status or user type, or record their termination (Cornerstone HR portals).
Update transcript trainingChange the due date or the transcript custom fields of a training on a person's transcript.
Withdraw from sessionWithdraw 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

UserusertextRequired
The person, by the User ID on their user record (or what 'Find user by' says).
Traininglearning_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 byuser_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.
DecisiondecisiontextRequired
Approve or deny the request.One of: approve, deny.
Approverapprover_idtextRequired
The approver's numeric employee id.
CommentcommenttextRequired
A comment for the transcript history.
Send Cornerstone's emailssend_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

UserusertextRequired
The person, by the User ID on their user record (or what 'Find user by' says).
Traininglearning_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 byuser_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 unarchiveoperationtext
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

UserusertextRequired
The person, by the User ID on their user record (or what 'Find user by' says).
Traininglearning_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 byuser_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 asassignmenttextRequired
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 datedue_datedate
When it's due. Must not be in the past.
Available fromavailable_datedate
When it becomes available. Defaults to now.
Training purposepurposetext
The purpose, by its English name, if the portal asks for one.
Commentcommenttext
A comment for the transcript history.
Assign again if they have itassign_new_occurrencetrue/false
Turn on to add a new occurrence for someone who already has it.
Send Cornerstone's emailssend_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

UserusertextRequired
The person, by the User ID on their user record (or what 'Find user by' says).
Traininglearning_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 byuser_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 atcompleted_atdate and time
When they completed it. Defaults to now.
Scorescorenumber
Their score, 0 to 100, for tests and online classes.From 0 to 100.
Follow the portal's workflowfollow_workflowtrue/false
Turn on to go through any completion steps the portal has set (such as an evaluation) instead of marking it Completed outright.
Commentcommenttext
A comment for the transcript history.
Send Cornerstone's emailssend_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 IDexternal_idtextRequired
The User ID on their user record, unique in the portal.
Usernameuser_nametextRequired
What they sign in with.
First namefirst_nametextRequired
First name.
Last namelast_nametextRequired
Last name.
Middle namemiddle_nametext
Middle name.
Emailprimary_emailtext
Their work email address.
Work phonework_phonetext
Work phone number.
Mobile phonemobile_phonetext
Mobile phone number.
Managermanager_idtext
Their manager's numeric employee id.
Training approverapprover_idtext
The numeric employee id of who approves their training.
Original hire dateoriginal_hire_datedate
When first hired.
Latest hire datelast_hire_datedate
When last hired.
Street addressaddress_line1text
First line of the address.
Citycitytext
City.
State or provincestatetext
State or province.
ZIP or postal codepostal_codetext
ZIP or postal code.
Countrycountrytext
Country, such as USA.
Organizational unitsou_idslist
Their division, location, position and other OUs, one of each type. Your portal may require some types.
Custom fieldscustom_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

UserusertextRequired
The person, by the User ID on their user record (or what 'Find user by' says).
Traininglearning_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 byuser_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.
ReasonreasontextRequired
The exemption reason, exactly as named in the portal's list of reasons (in English), such as Other.
CommentcommenttextRequired
A comment for the transcript history.
Send Cornerstone's emailssend_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

Employeeemployee_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 unitou_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

Sessionsession_idtext
The session's learning object id (a GUID).
Session numbersession_numbertext
The session's number.
Locatorlocatornumber
The session's locator number.At least 1.
Roster statusstatustext
Only people with this status on the roster.One of: Registered, Completed, Incomplete, Withdrawn, No Show.
Pagepagenumber
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

Traininglearning_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 byavailable_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

UserusertextRequired
The person, by the User ID on their user record (or what 'Find user by' says).
Traininglearning_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 byuser_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 numberregistration_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

UserusertextRequired
The person, by the User ID on their user record (or what 'Find user by' says).
Find user byuser_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.
Statusstatus_groupslist
Only trainings in these states. Leave empty for all.One or more of: NotStarted (Not started), InProgress (In progress), Completed, Other.
Training typestraining_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 containssearchtext
Only trainings whose title contains this.
Changed sincemodified_sincedate
Only trainings changed on or after this date.
Include archivedinclude_archivedtrue/false
Turn on to include archived trainings.
Include removedinclude_removedtrue/false
Turn on to include removed trainings.
Required onlyrequired_onlytrue/false
Turn on for required trainings only.
Next page tokenpage_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 namefirst_nametext
Only users with this first name.
Last namelast_nametext
Only users with this last name.
Usernameuser_nametext
Only the user with this username.
User IDexternal_idtext
Only the user with this User ID.
Statusstatustext
Which users to include. Defaults to active ones.One of: Active (Active (default)), InActive, PendingApproval (Pending approval), All. Default: Active.
Organizational unitsou_idslist
Only users in any of these OUs.
Added sincecreated_sincedate
Only users added on or after this date.
Changed sincemodified_sincedate
Only users whose record's effective change date is on or after this date.
Page sizepage_sizenumber
How many to return, 1 to 1000. Cornerstone's default is 50 (100 for OUs).From 1 to 1000.
Next page tokennext_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

Namenametext
Only OUs whose name contains this.
Typetype_idtext
Only OUs of this type, such as Division or Location.
OU IDexternal_idtext
Only the OU with this ID of your own.
Include inactiveinclude_inactivetrue/false
Turn on to include OUs marked inactive.
Page sizepage_sizenumber
How many to return, 1 to 1000. Cornerstone's default is 50 (100 for OUs).From 1 to 1000.
Next page tokennext_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

UserusertextRequired
The person, by the User ID on their user record (or what 'Find user by' says).
Traininglearning_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 byuser_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

ViewviewtextRequired
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.
Filterodata_filtertext
An OData filter, such as user_status_id eq 1 or user_lo_comp_dt ge 2026-01-01T00:00:00Z.
Columnscolumnstext
The columns to return, separated by commas, such as user_id,user_name_first. Leave empty for all.
Sort byorder_bytext
A column to sort by, with desc to reverse.
Rowslimitnumber
How many rows a page holds, 1 to 10,000. Defaults to 100.From 1 to 10000.
Next page linknext_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

UserusertextRequired
The person, by the User ID on their user record (or what 'Find user by' says).
Traininglearning_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 byuser_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.
Commentcommenttext
A comment for the transcript history.
Send Cornerstone's emailssend_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

UserusertextRequired
The person, by the User ID on their user record (or what 'Find user by' says).
Traininglearning_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 byuser_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 restoreoperationtext
Whether to remove the training or restore it.One of: remove (Remove from the transcript), restore (Restore a removed training). Default: remove.
Reasonreasontext
Needed to remove: the reason exactly as named in the portal's list (in English), such as Other.
Commentcommenttext
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

UserusertextRequired
The person, by the User ID on their user record (or what 'Find user by' says).
Traininglearning_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 byuser_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 purposepurposetext
The purpose, by its English name, if the portal asks for one.
Send Cornerstone's emailssend_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

Titletitletext
Only trainings with this title.
Training typestraining_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).
Subjectsubjecttext
Only trainings in this subject.
Providertraining_providertext
Only trainings from this provider.
Added fromcreated_fromdate
Only trainings added on or after this date.
Added tocreated_todate
Only trainings added on or before this date.
Available to useravailable_to_usertext
Only trainings this person can take, by their User ID.
Include inactiveinclude_inactivetrue/false
Turn on to include inactive trainings.
Pagepagenumber
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

Statusstatustext
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.
Traininglearning_object_idtext
Only this training, by its learning object id.
Training typelo_typetext
Only this kind of training.One of: Online Class, Quick Course, Curriculum, Event, Session, Material, Test, Video, External Training, Library, and 6 more.
Userusertext
Only this person, by their User ID.
Changed frommodified_fromdate and time
Start of the period, at most a day before its end.
Changed tomodified_todate and time
End of the period. Defaults to a day after its start, or now.
Pagepagenumber
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

Employeeemployee_idtextRequired
Cornerstone's numeric id for the employee, from 'List employees' or a trigger. (Not their User ID.)
User IDexternal_idtext
The User ID on their user record, unique in the portal. Leave empty to keep it.
Usernameuser_nametext
What they sign in with. Leave empty to keep it.
First namefirst_nametext
First name. Leave empty to keep it.
Last namelast_nametext
Last name. Leave empty to keep it.
Middle namemiddle_nametext
Middle name. Leave empty to keep it.
Emailprimary_emailtext
Their work email address. Leave empty to keep it.
Work phonework_phonetext
Work phone number. Leave empty to keep it.
Mobile phonemobile_phonetext
Mobile phone number. Leave empty to keep it.
Managermanager_idtext
Their manager's numeric employee id. Leave empty to keep it.
Training approverapprover_idtext
The numeric employee id of who approves their training. Leave empty to keep it.
Original hire dateoriginal_hire_datedate
When first hired. Leave empty to keep it.
Latest hire datelast_hire_datedate
When last hired. Leave empty to keep it.
Activeactivetext
Choose No to deactivate the user, Yes to reactivate. Leave empty to keep it.One of: yes, no.
Street addressaddress_line1text
First line of the address. Leave empty to keep it.
Citycitytext
City. Leave empty to keep it.
State or provincestatetext
State or province. Leave empty to keep it.
ZIP or postal codepostal_codetext
ZIP or postal code. Leave empty to keep it.
Countrycountrytext
Country, such as USA. Leave empty to keep it.
Organizational unitsou_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 fieldscustom_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

Employeeemployee_idtextRequired
Cornerstone's numeric id for the employee, from 'List employees' or a trigger. (Not their User ID.)
Employment statusemployment_status_idtext
The new employment status. Leave empty to keep it.
User typecategory_idtext
The new user type (employment category). Leave empty to keep it.
Termination datetermination_datedate
The day their employment ends, for a termination.
Termination reasontermination_reason_idtext
Why they're leaving, for a termination.
Eligible for rehireeligible_for_rehiretext
For a termination: whether they may be rehired.One of: yes, no.
Rehiredis_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

UserusertextRequired
The person, by the User ID on their user record (or what 'Find user by' says).
Traininglearning_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 byuser_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.
CommentcommenttextRequired
A comment for the transcript history.
Due datedue_datedate
The new due date, in the future.
Custom fieldscustom_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

UserusertextRequired
The person, by the User ID on their user record (or what 'Find user by' says).
Traininglearning_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 byuser_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.
ReasonreasontextRequired
The withdrawal reason, exactly as named in the portal's list of reasons (in English), such as Other.
CommentcommenttextRequired
A comment for the transcript history.
Send Cornerstone's emailssend_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"
}

On this page