All of our teammates knew about MSU People Search and thought it was a very large breach of MSU student privacy. Anyone can visit the website and get private information on students such as phone numbers, home addresses, and emails.

What it does

We used a web scraper to pull all student information from the MSU people search website and are currently hosting it on a database. We build and Alexa skill to query the data and give the phone number of anyone at MSU who we have in the database.

How we built it

We used the Amazon Alexa SDK with AWS Lambda and DynamoDB. When a request comes in to Alexa, it starts a Lambda which queries the DynamoDB database.

Challenges we ran into

None of us had experience with these tools and products and there wasn't extensive documentation on using it. Also, we had lots of issues importing the data into DynamoDB and the runtime constraints of Lambda and lack of debugging tools are very difficult.

Accomplishments that we're proud of

We were able to successfully retrieve all of the data we needed.

What we learned

We learned a lot about web scraping, how to use AWS Lambda, and general automation tasks such as automating file creation and conversion.

What's next for Howdy

We are planning on talking to MSU about changing the security model for People Search to make the data less generally available.

Share this project: