Date

02 Jul 2020

Attendees

Steven Maglio
Ian Lessing (Unlicensed)
Vince Nievares
Kevin Wu
Diana Antova
Reinard Dolleschel
christian.montecino (Unlicensed)

Goals

Updates on continuing development
Review, organize and add to work items

Focus points for this meeting

General update

Discussion items

Item	Who	Notes
Welcome		Greetings and salutations
Vacations		Christian - in August Diana - 02 Jul 2020, 20 Jul 2020 - 24 Jul 2020 Steven - 06 Jul 2020 - 17 Jul 2020
IP address discussion	Diana Antova	11 Jun 2020 Apigee Proxy Server to UCSB Target Server Security Decision 18 Jun 2020 May no longer be required. It looks Apigee may be able to set us up with static IPs without elevated our contract to a higher tier. We are still waiting for a confirmation email if it will not add any fees to the contract. 02 Jul 2020 Apigee sent over the new IP addresses that will be assigned. 54.203.231.224 54.212.104.180 How do we want to handle the update? See Static IP Address Update Selection table below
Failing calls to class code and employee APIs	Diana Antova	11 Jun 2020 Calls to these APIs are failing intermittently since we updated the IP addresses for whitelisting Christian will check for IP address misspelling and submit a ticket to Apigee if there is no misspelling. 18 Jun 2020 Christian and Crew found that one of the IP addresses was misconfigured in the firewall; and a firewall update resolved the issue
Department Charfield API	Kevin Wu	New department chartfield API, Avi is the developer https://developer.ucsb.edu/content/department-chartfield-data
New API notification	Diana Antova	send CSF notice 12 Mar 2020 no update
Developer Portal Migration to Drupal 8	Ian Lessing (Unlicensed)	Notes: Drupal 8 Migration Notes Links: https://docs.apigee.com/api-platform/publish/drupal/open-source-drupal-8 https://www.drupal.org/project/apigee_devportal_kickstart https://github.com/apigee/devportal-kickstart-project-composer support for Drupal 8 APIGEE-216 09 Apr 2020 Diana Antova email the requirements to Matt Hall, Steven Maglio will create identity requirements (Completed, Campus Identity Resource Request) 21 May 2020 Waiting to hear from Matt Hall about a resource 04 Jun 2020 Matt Hall and campus is focusing on reopening campus and this is not a priority. Drupal 7 will most likely be supported through 2021. We want to upgrade it to Drupal 8 to take advantage of the Apigee improvements. If Ian frees up he can start to work on it. Diana Antova reach out to Matt Hall and public affairs for a resource (Ryan Vizena) and ask for availability.
Apigee support site		https://apigee.secure.force.com/portal/ update documentation APIGEE-238
Reports and alerts	Diana Antova	07 May 2020 Splunk2 might be ready in 2 weeks 04 Jun 2020 Still waiting to hear from Thomas Howard
Student Developed Applications		GoGaucho Team: Hengyu Lui / Jimmy Lin Professors: Chandra Krintz / Tobias Hollerrer GoGaucho Improvements GoGaucho Meetings Notes 08 Nov 2019 Conversation with Registrar about student API use. 14 Nov 2019 Diana Antova Emailed CSO to start the security conversation in regards to liability and oversight on student developed apps. 22 Nov 2019 Will meet with Jennifer Lofthus, SCO and Registrar to discuss student development with APIs. Scheduled for 13 Dec 2019 09 Jan 2020 Diana and Anthony Schmidt will write the two possible options for supporting student development and propose them to the group, CIO, and others for decision 16 Jan 2020 No update 09 Apr 2020 Steven Maglio will schedule a meeting 07 May 2020 New application reps: Arthur and Henry Li 21 May 2020 Asked students to create a new application request for the web app so they don't have to use the same key. Steven is following up with them. 04 Jun 2020 Steven and Seth met with the students. They are continuing to grow the sites. Two new members of the team are taking over. Henry is graduating, Jimmy is staying.
Meeting and group focus year 2020		Project focus Drupal 8 (see also Drupal 8 Migration High Level Requirements) Site initial setup Content migration Redesign to have a more generic purpose (DevOps, development, etc.) AWS Account cleanup automation Identity integration and automation Apigee Support 1 FTE on the apigee team to help with student development oversight and support Now the students have to contact so many groups to have their accounts setup, an FTE can really help with that. Adding the functionality to developer.ucsb.edu to create accounts. Drupal - OK to work with a student For other projects like identity account creation and others it will be difficult to work with a students
Student Email API - BARC	christian.montecino (Unlicensed)	BARC Cashnet Demographics File Every day a file needs to get sent to cashnet. The file contains emails and some other information. They (BARC) would like to know if SA could setup and API which Returns back any student records that have been updated within the last X days? This is used daily, with the cashnet process. Could there be a second endpoint which could return all the students without email addresses? Diana - What do you do with that information? Christian - That one is used by a weekly (monthly?) process. This is used by cashnet is some reconciliation process (unknown). They want a file of the numbers (some sort of identifier the BARC and cashnet know of) that are no associated with known student email addresses. (img 1) Diana - Okay, you won't need applicant information (she wasn't saying this as a question). You'll want to the official UCSB email address if known; but if it's not known, then it would return the applicant email address associated with the student. That value should be replaced once the applicant completes the process to create a ucsbnetid. We think this is how the old/current BARC mainframe program worked (img 2). We haven't seen the program that runs on the mainframe to know if that's exactly what it does. Img 1 / Img 2

Action items

Static IP Address Update Selection

Steps To Perform the Update	Responsibility (Steven on Vacation)	Responsibility (Steven in Office)
Ensure all the firewalls have been updated		Steven
Open a ticket with Apigee Support with a suggested change over date Possible Dates		"
Verify Endpoints After Change Make a spread sheet of all endpoints (see below) Assign responsibility for each endpoint		"
Close ticket with Apigee Support	Same as person that opened the ticket	Same as person that opened the ticket
Pros
Cons
Decision

Endpoint	Responsibility (Steven on Vacation)	Responsibility (Steven in Office)	Test Values
academics-curriculums-v1 academics-curriculums-v2	Seth Northrop	Steven	/classes/search?quarter=20202
academics-private-barcquartercalendar-v1	Seth Northrop	Steven	/fwtmn001/G/20203
academics-quartercalendar-v1	Seth Northrop	Steven	/quarters/current
administration-accesscards-v1	Gary
administration-financial-accounts-chartfield	Christian
administration-financial-barc-classcode-v1 administration-financial-barc-classcode-v2	Christian
administration-financial-classcode-v1
administration-financial-gmc-departments-v1
administration-financial-peoplesoft-fauvalidation-v1 administration-financial-peoplesoft-fauvalidation-v2	Christian
administration-private-recreation-photos-v1	Gary
dining-cams-v1 dining-cams-v2	Gary
dining-commons-v1	Gary
dining-mealplans-rates-v1	Gary
dining-menu-v1	Gary
employees-employeejoblookup-v1	Kevin
employees-employeemap	Kevin
employees-private-admgmt-sa-v1	Farah Tahmasbi / Seth Northrop	Steven	https://api.ucsb.edu/employees/private/admgmt/sa/v1/users/maglio-s
housing-assignments-v1	Gary
housing-contracts-status-v1	Gary
students-academicprograms-v1	Seth Northrop	Steven	/majors/8683898
students-courses-v1	Seth Northrop	Steven	/courses/8683898
students-lookups-v1	Seth Northrop	Steven	/admitlevels
students-photos-v1	Gary
students-private-deptcourses-v1	Seth Northrop	Steven	/classlist?quarter=20201&departments=CMPSC
students-private-gradapplverifications-v1	Aurelian Marian / Seth Northrop	Steven	/perm/8683898
students-private-mtdaccess-v1	Seth Northrop	Steven	https://api.ucsb.edu/students/private/mtdaccess/v1/perms
students-registrations-v1 students-registrations-v2	Seth Northrop	Steven	/registrations/8683898
students-rosters-v1	Seth Northrop	Steven	/rosters/20201
students-schedules-v1	Seth Northrop	Steven	/schedules/8683898/20074
students-students-v2	Seth Northrop	Steven	/students/8683898

Browser not supported