Welcome to Orange Cat LMS
Workforce Intelligence & Academy
Monitor real-time employee presence, run automated batch CSV upserts, organize employees into targeted groups, and assign specialized learning tracks seamlessly.
Presence Breakdown
System Activity & Audit Log
Real-time LMS logsEmployees Directory 0
Full workforce roster. Click any employee row to inspect their full profile, job history, and personal details.
| Employee ID | Employee | Job & Department | Location & Type | Presence | Cohorts / Groups | Courses | Last Modified |
Can Call API?
|
Profile Action |
|---|
No Employees Found
No employees matched your search query or presence filter. Try clearing filters or create a new employee.
Employee Groups & Cohorts
Bundle employees into squads or departments to assign training courses in one click.
Courses & Learning Paths
Design enterprise training curricula and enroll whole groups or individual employees.
Settings & Developer Portal
Explore full REST API documentation, test live endpoints, batch import profiles, and configure system preferences.
Interactive REST API Runner & CSV Hub
Execute live GET and POST requests against the Orange Cat API with real-time JSON responses and latency metrics.
Matches existing employees by id, employeeId, or email. If found, updates their record; otherwise creates a new profile.
// Click 'Execute API' to run call
Batch CSV Import & Upsert
Download Sample CSV
Upload any CSV with headers: EmployeeId, Name, Email, Role, Department, Phone, Presence. Every row is parsed and upserted.
Click to choose a CSV file or drag and drop here
Supports UTF-8 CSV up to 5MB
Batch JSON Import & Upsert Hub
Upsert all employee profiles directly from a JSON array or { "employees": [...] } payload. All 42 standard fields are formatted, validated, and persisted.
Click to choose a .json file or drag & drop here
Supports UTF-8 JSON array format
🌐 OData v4 Protocol Integration Hub
OASIS Standard
Orange Cat LMS exposes full OData v4 (Open Data Protocol) endpoints. Query employee entity collections with declarative URL options: $select, $filter, $orderby, $top, and $count.
/odata/v4/Employees
View XML Schema
OData Protocol & XML Query Engine
Native enterprise OData v4 and v2 services with full XML AtomPub (<feed> / <entry>) and JSON support. Use the interactive query builder to test system query options ($filter, $format, $top, $skip, $select, $orderby, $count) and post new records in XML language designed for SAP Cloud Integration (CPI).
Orange Cat Enterprise OData Adapter
The OData Adapter filters out internal database columns (e.g. passwords, internal IDs, raw customFields strings), replaces blank strings with standard m:null="true" attributes, formats explicit EDM types (Edm.Decimal, Edm.Date, Edm.DateTimeOffset), and injects standard navigation links (Job ➔ Personal ➔ Custom).
m:null="true" on blank attributes
// OData v2 payload will appear here when you click 'Execute Direct OData Call'
/odata/v4/Employees?$format=xml
Create a new employee profile using standard AtomPub XML language (<entry> with <m:properties>) as used by the SAP Cloud Integration OData Receiver Adapter.
// Response will appear here when you click 'Send OData XML POST Request'
$filter Filter System Query Option
Restricts the set of items returned using boolean expressions, comparison operators, and string functions.
eq : Equalne : Not Equalgt : Greater Thange : Greater or Equallt : Less Thanle : Less or Equaland : Logical ANDor : Logical ORcontains(field, 'value')startswith(field, 'value')endswith(field, 'value')tolower(field) eq 'value'$format Response Format (XML / JSON)
Specifies the MIME response representation. Supports AtomPub XML feeds, entries, and OData v4 JSON payloads.
?$format=xml or header Accept: application/atom+xml, application/xml. Returns standard Atom <feed> and <entry> XML.
?$format=json or header Accept: application/json. Returns OData v4 JSON envelope with @odata.context and value array.
$top & $skip Server-side Pagination
Splits large datasets into manageable pages. Essential for SAP CPI looping process calls and memory optimization.
$top=N: Returns at most N items.$skip=N: Skips the first N items before returning results.$select & $orderby Projections & Sorting
Minimize payload bandwidth and control sort sequences across all numeric, date, and text attributes.
$select: Comma-separated field names to return (e.g. employeeId,firstName,salary).$orderby: Field order with optional asc or desc (e.g. salary desc).$count & $metadata Inline Count & Schema Metadata (EDMX XML)
Retrieve total entity count inline, and discover the complete entity model schema required by the SAP Cloud Integration (CPI) OData Adapter.
Appends <m:count>150</m:count> inside XML <feed> or @odata.count in JSON.
?$count=true (or ?$inlinecount=allpages)
Generates standardized OASIS CSDL XML Schema definition for the Employee entity type with all 42 property types, keys, and facets.
OData Navigation Entity Sets & Multi-Hop Traversal: Job ➔ Personal ➔ Custom
OData v4 Spec
Orange Cat LMS partitions 42 standard employee fields into dedicated first-class OData entity sets with standard navigation properties (<NavigationProperty>). You can query each set independently, traverse directly between related entities, or expand inline ($expand). All endpoints deliver standard Atom/CSDL XML by default, or JSON when requested.
Traverse directly from an employee's Job profile to their Personal profile.
GET /odata/v4/JobDetails('1001')/Personal
Traverse from an employee's Personal details to their collection of Custom fields.
GET /odata/v4/PersonalDetails('1001')/Custom
Traverse all 3 hops: Job ➔ Personal ➔ Custom in a single OData request.
GET /odata/v4/Employees('1001')/Job/Personal/Custom
Use /odata/v4/JobDetails('1001')?$expand=Personal or /odata/v4/PersonalDetails('1001')?$expand=Custom to embed related entities inline inside <m:inline> Atom XML or JSON nested objects.
SAP Cloud Integration (CPI) Receiver Adapter Configuration
In your iFlow, add an OData Receiver Adapter (V2 or V4). Set Address to:
http://<host>:5000/odata/v4/
Click Select Resource in CPI. Provide the metadata URL:
http://<host>:5000/odata/v4/$metadata
Select entity set: Employees.
Under Processing Parameters, choose XML (AtomPub). CPI will automatically pass:
Accept: application/atom+xml
🔐 Authentication Studio: Basic Auth, OAuth 2.0 & API Keys
Tick any employee below to instantly generate and test standard HTTP Basic Authentication (Authorization: Basic base64(username:password)), issue OAuth 2.0 Bearer tokens via Client Credentials or Password Grant, or utilize Enterprise API Keys for automated SAP CPI and gateway integrations.
Click on any employee to tick them. Their credentials and encoded Base64 Basic Auth header are automatically linked into the test runner and cURL generators below.
Basic MTAwMTpjb21wYW55I2NvbQ==
Click 'Generate OAuth 2.0 Bearer Token' above
X-API-Key: ocat_live_key_master_2026_superadmin
Live Authenticated Call Runner
Execute direct queries against OData v2/v4 or secured API endpoints using your ticked employee credentials, Bearer token, or API key.
// Response with authenticated credentials will appear here...
Theme & Aesthetic Preferences
Select your preferred color scheme. Preferences are saved automatically to your browser.
Enterprise Custom Attributes
Configure dynamic custom attributes (e.g. GitHub Username, T-Shirt Size, Security Clearance) that automatically display on employee profiles.
Danger Zone
Live Server & Database Diagnostics
Employee Name
🟢 PresentMy Profile Information
My Assigned Cohorts & Squads
My Assigned Courses & Learning Curriculum
Track your curriculum modules and update your progress as you complete lessons.