2025 EBSCO User Group

Join me for a walkthrough on accessing and utilizing data from FOLIO through its APIs and PostgreSQL database. I'll begin with how to set up and use the FOLIO APIs and move to accessing raw data through PostgreSQL including utilizing tools such as DBeaver.

Building on these basics, I'll delve into real-world applications by showcasing several projects undertaken at Smith College Libraries. Examples such as:

Collection and Purchasing Reports: Utilizing PostgreSQL queries to create reports that visualize collections and purchasing data, including automating ACRL statistics.

New Materials Browsing: Enabled patrons to browse new books and videos combining EDS APIs with FOLIO data.

Enhanced Course Reserves: Access to Course Reserves through the FOLIO API.

Equipment tracking: Simple equipment tracking utilizing FOLIO's inventory APIs and real time availability tracking to give students a clear picture of what is available.

These examples will illustrate how raw data access can improve library services. Attendees will gain practical insights and actionable knowledge to apply in their own institutions, making the most of FOLIO's robust data capabilities.