Notes
This sprint we focused mostly on internal improvements, but we’ve still got a few new things to show. By request, we added filters for active and itemIdentifier to the salesItems endpoint. We ensured all dates and times are presented with the correct formatting in our responses, which affects the filters you can use on them: all date and datetime fields now allow use of the GREATER_THAN and LESS_THAN operators for inexact matches.
We reviewed our internal security tools and found a few things to update and possible improvements to make. We fixed a bug that was making some person and position ID numbers display with decimal points, which aren’t really appropriate for IDs. We fixed the order of the paths presented in the OpenAPI specification, so they’ll now be in alphabetic order when you import the specification into Postman or similar tools. Note that you’ll have to re-import it to see the new order – Postman doesn’t update these automatically.
We added some indexes to our database to speed up certain queries as a way of testing how much performance improvement we see. If it’s significant, we’ll do the same for other endpoints as well.
We also implemented a general solution for URL encoded characters, so they’re now accepted in all endpoints and filters. We continued work on ETL conversion, this time getting through awards, cost centers, spend categories, and ledger accounts.
API changes
- New active and itemIdentifier filters for salesItems