API query to retrieve only those user accounts where active fines/fees exist
We want to export user fine/fee data to our SIS (PeopleSoft) while retaining the ability to manage patron fine/fees in Alma. The Alma bursar export does not meet our needs because it closes out the fine/fees in Alma. The user API only allows for checking accounts individually to determine whether a fine/fee exists. The 'users' query does not provide a filter for whether a fine/fee is on the retrieved user's account.
Should be, yes.
Ian Chan commented
Thanks Moshe, would this allow for exporting all users with an account balance greater than $0?
Are you familiar with the Export User Blocks action in the Users Integration Profile ? This action is used to export users that should be blocked due to unpaid fines. It can be used to routinely export a list of users that owe more than a given amount. See https://knowledge.exlibrisgroup.com/Alma/Product_Documentation/Alma_Online_Help_(English)/Integrations_with_External_Systems/050User_Management/010Student_Information_Systems