# Cornerstone OnDemand

> 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.

App · 25 actions. Web page: https://docs.lodol.com/docs/integrations/cornerstone-ondemand

## Actions

### Approve or deny training

Approve or deny a training request that's pending approval. Each call moves it one approval step.

**Inputs**

- User (`user`, text, required): The person, by the User ID on their user record (or what 'Find user by' says).
- Training (`learning_object_id`, text, required): 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_key`, text): 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 (`decision`, text, required): Approve or deny the request. One of: `approve`, `deny`.
- Approver (`approver_id`, text, required): The approver's numeric employee id.
- Comment (`comment`, text, required): A comment for the transcript history.
- Send Cornerstone's emails (`send_emails`, true/false): Turn on to send the emails the portal has set up for this change.

**Outputs**

- `done` (true/false): True once Cornerstone accepted the change
- `item` (object): The training on the transcript, read back (empty if it couldn't be read)
- `learning_object_id` (text): The training's learning object id

**Example output**

```json
{
  "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 (`user`, text, required): The person, by the User ID on their user record (or what 'Find user by' says).
- Training (`learning_object_id`, text, required): 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_key`, text): 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 (`operation`, text): 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**

- `done` (true/false): True once Cornerstone accepted the change
- `item` (object): The training on the transcript, read back (empty if it couldn't be read)
- `learning_object_id` (text): The training's learning object id

**Example output**

```json
{
  "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 (`user`, text, required): The person, by the User ID on their user record (or what 'Find user by' says).
- Training (`learning_object_id`, text, required): 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_key`, text): 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 (`assignment`, text, required): 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_date`, date): When it's due. Must not be in the past.
- Available from (`available_date`, date): When it becomes available. Defaults to now.
- Training purpose (`purpose`, text): The purpose, by its English name, if the portal asks for one.
- Comment (`comment`, text): A comment for the transcript history.
- Assign again if they have it (`assign_new_occurrence`, true/false): Turn on to add a new occurrence for someone who already has it.
- Send Cornerstone's emails (`send_emails`, true/false): Turn on to send the emails the portal has set up for this change.

**Outputs**

- `done` (true/false): True once Cornerstone accepted the change
- `item` (object): The training on the transcript, read back (empty if it couldn't be read)
- `learning_object_id` (text): The training's learning object id

**Example output**

```json
{
  "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 (`user`, text, required): The person, by the User ID on their user record (or what 'Find user by' says).
- Training (`learning_object_id`, text, required): 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_key`, text): 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_at`, date and time): When they completed it. Defaults to now.
- Score (`score`, number): Their score, 0 to 100, for tests and online classes. From 0 to 100.
- Follow the portal's workflow (`follow_workflow`, true/false): Turn on to go through any completion steps the portal has set (such as an evaluation) instead of marking it Completed outright.
- Comment (`comment`, text): A comment for the transcript history.
- Send Cornerstone's emails (`send_emails`, true/false): Turn on to send the emails the portal has set up for this change.

**Outputs**

- `done` (true/false): True once Cornerstone accepted the change
- `item` (object): The training on the transcript, read back (empty if it couldn't be read)
- `learning_object_id` (text): The training's learning object id

**Example output**

```json
{
  "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_id`, text, required): The User ID on their user record, unique in the portal.
- Username (`user_name`, text, required): What they sign in with.
- First name (`first_name`, text, required): First name.
- Last name (`last_name`, text, required): Last name.
- Middle name (`middle_name`, text): Middle name.
- Email (`primary_email`, text): Their work email address.
- Work phone (`work_phone`, text): Work phone number.
- Mobile phone (`mobile_phone`, text): Mobile phone number.
- Manager (`manager_id`, text): Their manager's numeric employee id.
- Training approver (`approver_id`, text): The numeric employee id of who approves their training.
- Original hire date (`original_hire_date`, date): When first hired.
- Latest hire date (`last_hire_date`, date): When last hired.
- Street address (`address_line1`, text): First line of the address.
- City (`city`, text): City.
- State or province (`state`, text): State or province.
- ZIP or postal code (`postal_code`, text): ZIP or postal code.
- Country (`country`, text): Country, such as USA.
- Organizational units (`ou_ids`, list): Their division, location, position and other OUs, one of each type. Your portal may require some types.
- Custom fields (`custom_fields`, object): Values for the user record's custom fields.

**Outputs**

- `employee` (object): The employee, read back
- `id` (number): The employee's numeric id

**Example output**

```json
{
  "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 (`user`, text, required): The person, by the User ID on their user record (or what 'Find user by' says).
- Training (`learning_object_id`, text, required): 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_key`, text): 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 (`reason`, text, required): The exemption reason, exactly as named in the portal's list of reasons (in English), such as Other.
- Comment (`comment`, text, required): A comment for the transcript history.
- Send Cornerstone's emails (`send_emails`, true/false): Turn on to send the emails the portal has set up for this change.

**Outputs**

- `done` (true/false): True once Cornerstone accepted the change
- `item` (object): The training on the transcript, read back (empty if it couldn't be read)
- `learning_object_id` (text): The training's learning object id

**Example output**

```json
{
  "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_id`, text, required): Cornerstone's numeric id for the employee, from 'List employees' or a trigger. (Not their User ID.)

**Outputs**

- `employee` (object): The employee

**Example output**

```json
{
  "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_id`, text, required): The OU. Pick one, or give its numeric id.

**Outputs**

- `ou` (object): The organizational unit

**Example output**

```json
{
  "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_id`, text): The session's learning object id (a GUID).
- Session number (`session_number`, text): The session's number.
- Locator (`locator`, number): The session's locator number. At least 1.
- Roster status (`status`, text): Only people with this status on the roster. One of: `Registered`, `Completed`, `Incomplete`, `Withdrawn`, `No Show`.
- Page (`page`, number): Which page of people to get, from 1. Use the 'next_page' an earlier run gave. At least 1.

**Outputs**

- `count` (number): How many people are on this page
- `next_page` (number): The next page's number, or 0 on the last
- `page` (number): This page's number
- `pending_users` (list): People pending a place
- `seats_available` (number): Seats still free
- `total_seats` (number): Seats in the session
- `users` (list): People on the roster

**Example output**

```json
{
  "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_id`, text, required): 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_user`, text): The User ID of someone it's available to. Leave empty for the connection's own user.

**Outputs**

- `training` (object): The training

**Example output**

```json
{
  "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 (`user`, text, required): The person, by the User ID on their user record (or what 'Find user by' says).
- Training (`learning_object_id`, text, required): 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_key`, text): 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_number`, number): Which time they took it. Leave empty for the latest. At least 1.

**Outputs**

- `item` (object): The training

**Example output**

```json
{
  "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 (`user`, text, required): The person, by the User ID on their user record (or what 'Find user by' says).
- Find user by (`user_key`, text): 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_groups`, list): Only trainings in these states. Leave empty for all. One or more of: `NotStarted` (Not started), `InProgress` (In progress), `Completed`, `Other`.
- Training types (`training_types`, list): 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 (`search`, text): Only trainings whose title contains this.
- Changed since (`modified_since`, date): Only trainings changed on or after this date.
- Include archived (`include_archived`, true/false): Turn on to include archived trainings.
- Include removed (`include_removed`, true/false): Turn on to include removed trainings.
- Required only (`required_only`, true/false): Turn on for required trainings only.
- Next page token (`page_token`, text): For the next page, the 'next_page_token' an earlier run gave.

**Outputs**

- `count` (number): How many are on this page
- `items` (list): The trainings on the transcript
- `next_page_token` (text): Give this to the next run for the next page; empty on the last
- `total` (number): How many match in all

**Example output**

```json
{
  "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_name`, text): Only users with this first name.
- Last name (`last_name`, text): Only users with this last name.
- Username (`user_name`, text): Only the user with this username.
- User ID (`external_id`, text): Only the user with this User ID.
- Status (`status`, text): Which users to include. Defaults to active ones. One of: `Active` (Active (default)), `InActive`, `PendingApproval` (Pending approval), `All`. Default: `Active`.
- Organizational units (`ou_ids`, list): Only users in any of these OUs.
- Added since (`created_since`, date): Only users added on or after this date.
- Changed since (`modified_since`, date): Only users whose record's effective change date is on or after this date.
- Page size (`page_size`, number): How many to return, 1 to 1000. Cornerstone's default is 50 (100 for OUs). From 1 to 1000.
- Next page token (`next_page_token`, text): For the next page, the 'next_page_token' an earlier run gave, with the same filters. It lasts 5 minutes.

**Outputs**

- `count` (number): How many are on this page
- `employees` (list): The employees
- `next_page_token` (text): Give this to the next run for the next page; empty on the last

**Example output**

```json
{
  "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 (`name`, text): Only OUs whose name contains this.
- Type (`type_id`, text): Only OUs of this type, such as Division or Location.
- OU ID (`external_id`, text): Only the OU with this ID of your own.
- Include inactive (`include_inactive`, true/false): Turn on to include OUs marked inactive.
- Page size (`page_size`, number): How many to return, 1 to 1000. Cornerstone's default is 50 (100 for OUs). From 1 to 1000.
- Next page token (`next_page_token`, text): For the next page, the 'next_page_token' an earlier run gave, with the same filters. It lasts 5 minutes.

**Outputs**

- `count` (number): How many are on this page
- `next_page_token` (text): Give this to the next run for the next page; empty on the last
- `ous` (list): The organizational units

**Example output**

```json
{
  "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 (`user`, text, required): The person, by the User ID on their user record (or what 'Find user by' says).
- Training (`learning_object_id`, text, required): 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_key`, text): 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**

- `done` (true/false): True once Cornerstone accepted the change
- `item` (object): The training on the transcript, read back (empty if it couldn't be read)
- `learning_object_id` (text): The training's learning object id

**Example output**

```json
{
  "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 (`view`, text, required): 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_filter`, text): An OData filter, such as user_status_id eq 1 or user_lo_comp_dt ge 2026-01-01T00:00:00Z.
- Columns (`columns`, text): The columns to return, separated by commas, such as user_id,user_name_first. Leave empty for all.
- Sort by (`order_by`, text): A column to sort by, with desc to reverse.
- Rows (`limit`, number): How many rows a page holds, 1 to 10,000. Defaults to 100. From 1 to 10000.
- Next page link (`next_link`, text): For the next page, the 'next_link' an earlier run gave.

**Outputs**

- `count` (number): How many rows are on this page
- `next_link` (text): Give this to the next run for the next page; empty on the last
- `rows` (list): The rows

**Example output**

```json
{
  "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 (`user`, text, required): The person, by the User ID on their user record (or what 'Find user by' says).
- Training (`learning_object_id`, text, required): 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_key`, text): 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 (`comment`, text): A comment for the transcript history.
- Send Cornerstone's emails (`send_emails`, true/false): Turn on to send the emails the portal has set up for this change.

**Outputs**

- `done` (true/false): True once Cornerstone accepted the change
- `item` (object): The training on the transcript, read back (empty if it couldn't be read)
- `learning_object_id` (text): The training's learning object id

**Example output**

```json
{
  "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 (`user`, text, required): The person, by the User ID on their user record (or what 'Find user by' says).
- Training (`learning_object_id`, text, required): 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_key`, text): 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 (`operation`, text): Whether to remove the training or restore it. One of: `remove` (Remove from the transcript), `restore` (Restore a removed training). Default: `remove`.
- Reason (`reason`, text): Needed to remove: the reason exactly as named in the portal's list (in English), such as Other.
- Comment (`comment`, text): Needed to remove: a comment for the transcript history.

**Outputs**

- `done` (true/false): True once Cornerstone accepted the change
- `item` (object): The training on the transcript, read back (empty if it couldn't be read)
- `learning_object_id` (text): The training's learning object id

**Example output**

```json
{
  "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 (`user`, text, required): The person, by the User ID on their user record (or what 'Find user by' says).
- Training (`learning_object_id`, text, required): 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_key`, text): 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 (`purpose`, text): The purpose, by its English name, if the portal asks for one.
- Send Cornerstone's emails (`send_emails`, true/false): Turn on to send the emails the portal has set up for this change.

**Outputs**

- `done` (true/false): True once Cornerstone accepted the change
- `item` (object): The training on the transcript, read back (empty if it couldn't be read)
- `learning_object_id` (text): The training's learning object id

**Example output**

```json
{
  "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 (`title`, text): Only trainings with this title.
- Training types (`training_types`, list): 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 (`subject`, text): Only trainings in this subject.
- Provider (`training_provider`, text): Only trainings from this provider.
- Added from (`created_from`, date): Only trainings added on or after this date.
- Added to (`created_to`, date): Only trainings added on or before this date.
- Available to user (`available_to_user`, text): Only trainings this person can take, by their User ID.
- Include inactive (`include_inactive`, true/false): Turn on to include inactive trainings.
- Page (`page`, number): Which page of trainings to get, from 1. Use the 'next_page' an earlier run gave. At least 1.

**Outputs**

- `count` (number): How many are on this page
- `next_page` (number): The next page's number, or 0 on the last
- `page` (number): This page's number
- `total` (number): How many match in all
- `trainings` (list): The trainings on this page

**Example output**

```json
{
  "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 (`status`, text): 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_id`, text): Only this training, by its learning object id.
- Training type (`lo_type`, text): Only this kind of training. One of: `Online Class`, `Quick Course`, `Curriculum`, `Event`, `Session`, `Material`, `Test`, `Video`, `External Training`, `Library`, and 6 more.
- User (`user`, text): Only this person, by their User ID.
- Changed from (`modified_from`, date and time): Start of the period, at most a day before its end.
- Changed to (`modified_to`, date and time): End of the period. Defaults to a day after its start, or now.
- Page (`page`, number): Which page of records to get, from 1. Use the 'next_page' an earlier run gave. At least 1.

**Outputs**

- `count` (number): How many are on this page
- `modified_from` (text): Start of the period searched (UTC)
- `modified_to` (text): End of the period searched (UTC)
- `next_page` (number): The next page's number, or 0 on the last
- `page` (number): This page's number
- `total_pages` (number): How many pages match
- `transcripts` (list): The transcript records

**Example output**

```json
{
  "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_id`, text, required): Cornerstone's numeric id for the employee, from 'List employees' or a trigger. (Not their User ID.)
- User ID (`external_id`, text): The User ID on their user record, unique in the portal. Leave empty to keep it.
- Username (`user_name`, text): What they sign in with. Leave empty to keep it.
- First name (`first_name`, text): First name. Leave empty to keep it.
- Last name (`last_name`, text): Last name. Leave empty to keep it.
- Middle name (`middle_name`, text): Middle name. Leave empty to keep it.
- Email (`primary_email`, text): Their work email address. Leave empty to keep it.
- Work phone (`work_phone`, text): Work phone number. Leave empty to keep it.
- Mobile phone (`mobile_phone`, text): Mobile phone number. Leave empty to keep it.
- Manager (`manager_id`, text): Their manager's numeric employee id. Leave empty to keep it.
- Training approver (`approver_id`, text): The numeric employee id of who approves their training. Leave empty to keep it.
- Original hire date (`original_hire_date`, date): When first hired. Leave empty to keep it.
- Latest hire date (`last_hire_date`, date): When last hired. Leave empty to keep it.
- Active (`active`, text): Choose No to deactivate the user, Yes to reactivate. Leave empty to keep it. One of: `yes`, `no`.
- Street address (`address_line1`, text): First line of the address. Leave empty to keep it.
- City (`city`, text): City. Leave empty to keep it.
- State or province (`state`, text): State or province. Leave empty to keep it.
- ZIP or postal code (`postal_code`, text): ZIP or postal code. Leave empty to keep it.
- Country (`country`, text): Country, such as USA. Leave empty to keep it.
- Organizational units (`ou_ids`, list): 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_fields`, object): Values for the user record's custom fields. Leave empty to keep it.

**Outputs**

- `employee` (object): The employee, read back
- `id` (number): The employee's numeric id

**Example output**

```json
{
  "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_id`, text, required): Cornerstone's numeric id for the employee, from 'List employees' or a trigger. (Not their User ID.)
- Employment status (`employment_status_id`, text): The new employment status. Leave empty to keep it.
- User type (`category_id`, text): The new user type (employment category). Leave empty to keep it.
- Termination date (`termination_date`, date): The day their employment ends, for a termination.
- Termination reason (`termination_reason_id`, text): Why they're leaving, for a termination.
- Eligible for rehire (`eligible_for_rehire`, text): For a termination: whether they may be rehired. One of: `yes`, `no`.
- Rehired (`is_rehired`, text): Choose Yes when this person is being rehired. One of: `yes`, `no`.

**Outputs**

- `employment_status` (object): Their employment status, read back
- `id` (number): The employee's numeric id

**Example output**

```json
{
  "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 (`user`, text, required): The person, by the User ID on their user record (or what 'Find user by' says).
- Training (`learning_object_id`, text, required): 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_key`, text): 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 (`comment`, text, required): A comment for the transcript history.
- Due date (`due_date`, date): The new due date, in the future.
- Custom fields (`custom_fields`, object): Transcript custom fields to set: each field's English name and its value.

**Outputs**

- `done` (true/false): True once Cornerstone accepted the change
- `item` (object): The training on the transcript, read back (empty if it couldn't be read)
- `learning_object_id` (text): The training's learning object id

**Example output**

```json
{
  "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 (`user`, text, required): The person, by the User ID on their user record (or what 'Find user by' says).
- Training (`learning_object_id`, text, required): 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_key`, text): 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 (`reason`, text, required): The withdrawal reason, exactly as named in the portal's list of reasons (in English), such as Other.
- Comment (`comment`, text, required): A comment for the transcript history.
- Send Cornerstone's emails (`send_emails`, true/false): Turn on to send the emails the portal has set up for this change.

**Outputs**

- `done` (true/false): True once Cornerstone accepted the change
- `item` (object): The training on the transcript, read back (empty if it couldn't be read)
- `learning_object_id` (text): The training's learning object id

**Example output**

```json
{
  "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"
}
```
