Global Connections Database
|Name||Dr. Karen Beardsley|
|Affiliation||Global Professional Programs, Global Affairs|
|Project title||Global Connections Database|
|Background||Our new UC Davis Global Connections Database (https://ucdavis.moveonca.com/publisher/1/eng) brings together institutional partnerships and faculty global connections, and will soon incorporate visiting delegation information and other global connections information. This database is an important tool in showcasing the breadth of global linkages and partnerships and the expertise of the UC Davis community, while also enabling searches for future collaborations. Moving forward, Global Affairs wishes to incorporate data from other campus units, such as the Office of Research, using an API. The software platform is a third-party solution called MoveON, by the company QS Unisolution.|
|Description||This proposed project will involve developing programs and a web interface for securely querying the QS Unisolution MoveON API using PHP to extract data and preprocess it for input into other system. The program must securely establish credentials, securely request or send data to the API, and preprocess the response for input into other systems. The program must include methods that limit and filter data to prevent querying sensitive data. Tasks will include evaluating the API provided by QS Unisolution for security.|
|Deliverable||Full web interface allowing secure authentication, transmission of credentials, and secure queries of the API returning JSON data. The interface must be developed to filter and prevent transmission of sensitive data and must meet the IS-3 guidelines. The interface will include methods for preprocessing and transforming the returned data. It will need to be well-documented, including how to extend the code, and all code must be provided to Global Affairs.|
|Skill set desirable||· Secure programming practices and familiarity with the University of California, Office of the President’s (UCOP’s) IS-3 policy.
· Experienced in PHP programming.
· Working knowledge with querying, transforming, and manipulating JSON and XML data from an API.
|Client time availability||30-60 min weekly or more|
|IP requirement||Client wishes to keep IP of the project|