Translating Building ID or Room ID to names

Lindsey Bryant

As we continue to leverage the Sky APIs to populate ODS tables and build our data warehouse, I'm finding a gap on how to say “This class is in this room and in this building”. On the Academic Sections by School Level API, there is a room_id, but that's it. How are others handling similar situations?

I didn't see an API for this and I think it would be great if there was a single list of all buildings and rooms, with the IDs so we could then join the two datasets together.

Lindsey Bryant

@Stephen Boyle we found the Athletics Buildings API, which appears to be what we need and is inclusive to more than just athletic buildings. Maybe updating the name would help others as well.

Stephen Boyle

@Lindsey Bryant

I was off yesterday, so you found the answer before I could reply. And yes, that endpoint is poorly named. It is in the backlog for review and we will likely change the name to "Core buildings" or something similarly general.

Lindsey Bryant

@Stephen Boyle
Thanks for confirming! I'm going to start leveraging it so I appreciate knowing it won't go away or be adjusted for the time being. I hope you had a nice day off!