What email address or phone number would you like to use to sign in to Docs.com?
If you already have an account that you use with Office or other Microsoft services, enter it here.
Or sign in with:
Signing in allows you to download and like content, and it provides the authors analytical data about your interactions with their content.
Embed code for: Data Transfer API - Sunapsis Conference 2015
Select a size
Exporting Sunapsis Data – Data Transfer API
Emily Cheng International Students Office Massachusetts Institute of Technology October 12, 2015
MIT International Student Hold Business Process
Our Current Solution
Our New Solution – Sunapsis Data Transfer API
Future Release Updates
Resources & Questions
MIT International Student “Holds”
“Orientation Clearance” (OC)
“Certificate of Eligibility” (CE)
Holds applied to all accepted student records
Issuance of MIT ID Card
Registration / Enrollment
MIT’s Current Hold Clearance Process (2010 – 10/16/2015)
Every 15 minutes
Holds cleared between 16 and 30 minutes
MIT-Pretoria exchange students case study
Three points of possible connection failures
Sunapsis Cold Fusion file extraction
MIT ISO & Card Services - Reliability, Flexibility, Real-time updates
MIT IS&T - Unpredictable uses, APIs, and Middleware
Sunapsis Data Transfer API
What’s an “API”?
Application Program Interface
Simple Web API - General
Simple HTTP requests and responses
Security protocol: SSL (i.e. https)
HTTP Method for request: POST
Example: MIT Web API
Ensure data sent to API server is from Sunapsis
Shared secret & derived hash value
Three additional name/value pairs in URI
Timestamp – expires reqeusts older than agreed interval
Derived hash token (timestamp + shared secret)
Institution API server will send an HTTP response to the POST request
HTTP status code of 200 indicates success
All other codes indicate failure
Failure responses will include JSON object indicating why the request failed.
Example: Student Holds
Example: Hold Data - JSON String
Configuration: Data Transfer API
url, username, secretKey, sunapsisTable, universityIDLabel
sunapsisTable, sunapsisColumn, institutionColumn, rank
sunapsisTable, idnumber, recordNumber, statusCode, responseDetails, datestamp
Other Data Transfer Possibilities
Citizenship, visa data
API web server to create student.xml
Other Institutions – admissions data, passport data
Sunapsis development team is working to finalize
Configuration within the user interface
Front end access to any errors, including potential option for error statement directly to user
Sunapsis 3.3 in November 2015 or Sunapsis 3.4 in February 2016
Sunapsis 3.2.0 Documentation
3.2.0 Final - Other New Features.pdf
Excel to SQL
Paul Dexter’s example
“Run as fast as you can”
Located on the side of campus near Card Office, 5 minute walk
We’ve moved and now we’re a 15 minute walk
What can we do with the data?
Hack-a-thon - Students use Map data, Wireless access point data and combine it to find free food.
This is a simple Web API, meaning the application uses simple HTTP requests and responses to send and receive data. The sunapsis system will use a POST request to a defined service to transmit data. This would be data tied to a given table in SUNAPSIS tied to a student or scholar’s record. Upon insert or update of data, a configuration could then execute a POST call of JSON data to the configured institutional service expecting to receive incoming data.
JSON is built on two structures:
A collection of name/value pairs. In various languages, this is realized as an object, record, struct, dictionary, hash table, keyed list, or associative array.
An ordered list of values. In most languages, this is realized as an array, vector, list, or sequence.
URL : Uniform Resource Locator, URI: Uniform Resources Identifier
PhP, Python, Ruby on Rails, Java Servlets and JSPs
Note that the Sunapsis documentation has a different name for the jbDataTransferLogent “Holds”
A collection of name/value pairs. In various languages, this is realized as an object, record, struct,