Overview

Middleware provides general web services interfaces via the https://iet-ws.ucdavis.edu/api/.. service URL. Many APIs require you to obtain an application API key from iam-data-admin@ucdavis.edu or middleware-api@ucdavis.edu.

Please refer to the specific API documentation below. If you have questions on these APIs please email middleware-api@ucdavis.edu.

IAM Identity Store Database Views and RESTful Web Service APIs

Data Dictionary and Outline (Spreadsheet)

Spreadsheet containing Data Dictionary and outline of Database Views and RESTful Web Services APIs.

Identity Store RESTful Web Service APIs Technical Documentation

The IAM Identity Store APIs are currently organized into three categories:  People, People Associations, and Organization Info.

1. People APIs (Overview)
   1. Core People
   2. Ids
   3. Affiliations
   4. Contact Info
   5. Primary Kerberos Account Lookup
   6. Primary HSAD Account Lookup
2. People Associations APIs (Overview)
   1. PPS Associations
   2. Online Directory Associations
   3. Health System (HS) Associations
   4. Student Associations
3. Organization Info APIs (Overview)
   1. PPS Departments
   2. PPS Divisions (Business Office Units)
   3. PPS Titles
   4. Health System Cost Centers
   5. Health System Titles
   6. SIS Colleges
   7. SIS Majors
   8. Online Directory (ODR) Departments
   9. Online Directory (ODR) Titles
   10. Reports To by Department

Online Directory APIs

1. Search API
2. Bulk Load API

Mothra APIs

1. Email Address and Kerberos Lookup API
2. Majors Count API

Banner APIs

1. PIDM Lookup API

All APIs

• Page:
  Mothra email address and Kerberos ID lookup API - Developer's Guide - DRAFT — This documentation is intended for those wishing to look up email addresses and kerberos IDs via the REST with JSON interface.
• Page:
  Identity Store Contact Info API
• Page:
  Identity Store Primary Kerberos Account API
• Page:
  Identity Store Primary HSAD Account API
• Page:
  Identity Store Ids API
• Page:
  Banner PIDM Lookup API - Developer's Guide - DRAFT — This documentation is intended for developers who wish to look up Banner PIDMs from within their application via the REST with JSON interface.
• Page:
  Identity Store Affiliations API
• Page:
  Identity Store Core People API
• Page:
  Online Directory Search API - Developer's Guide — This documentation is intended for developers who wish to perform a basic search on the public data within the Online Directory system from within their application via the REST with JSON interface.
• Page:
  Identity Store SIS Majors API
• Page:
  Mothra majors count API - Developer's Guide - DRAFT — This documentation is intended primarily for Tim Leamy to look up major numbers via the REST with JSON interface.  The query used is as follows:

   select count(*), majorcode from people
  			where clienttype in ('U', 'R', 'C', 'P')
  			and clientstatus = 'A'
  			and majorcode is not null
  			group by majorcode
  			order by majorcode
  

• Page:
  Identity Store PPS Divisions (Business Office Units) API
• Page:
  Identity Store Online Directory (ODR) Titles API
• Page:
  Identity Store PPS Titles API
• Page:
  Identity Store Online Directory (ODR) Departments API