Notes
This sprint we say farewell to Jen Ahlstrom, our fearless Scrum Master! Jen’s been instrumental in keeping the wheels turning for over a year. We’ll terribly miss her range of knowledge and her knack for knowing just the right person to talk to, but we wish her the best in her new position in the School of Medicine and Public Health!
We fixed a couple of bugs related to ETL that presented as a problem with pagination for programs and with grants being incorrectly shown as inactive. Those are fixed now and those endpoints are working as expected. Thanks to our users for reporting those problems to us.
This week we presented a demonstration of a new proof of concept for accessing journal data in the Finance API. This is a much larger dataset than the others we’ve taken on, so it calls for a different approach. Users will send a request with some parameters describing the boundaries of the data needed, but instead of receiving a JSON HTTP response with the requested data in it, you’ll receive a signed link to a file in an Amazon S3 bucket. You can use this link to download the file for up to fifteen minutes. Systems that integrate with this system will need to accommodate this two-step process.
We also talked about new endpoints for awards and award lines. These will give you a lot of new data for research administration. They’re related to grants in the following way: one award can have one or more award lines associated with it, and each award line is associated with one grant. Going the other way, each grant is associated with one award line, and each award line is associated with with one award. Some of the data that was previously stored on a grant in Peoplesoft is stored on awards or award lines in Workday, so you’ll probably need to look at these related records to find everything you need.
You can now filter grants by company, just as you can with most other endpoints. We also updated our sample Postman collection for anyone who’s using that to explore the API.