Can't pull Updates to Post-Acceptance/Disbursement AND Declined Initial Applications Using Same Query

Currently, in order to query the fund disbursements API on any updates to post-acceptance disbursements (such as category updates, changes to award period or changes to award amount), one would need to use the updated_at date. However, to pull information about cancelled awards, i.e., if an admin/student declines an offer, the only way to query that currently is to query on last_categorized_at date.

Customers are finding this frustrating. Ideally, there would be a way to pull all of these kinds of changes/updates with one query. The problem of using two different queries is that you might end up with duplicates. :-(



The updated at column only addresses Allotment applications, as opposed to including initial applications as well.  As a result, they have to run an additional query to collect changes from the initial application.  This will only include category changes however, and will not capture award amounts or award period updates.  The ideal solution would be to have an updated at field that includes both allotment and initial applications.

  • Deleted User
  • Mar 31 2017
  • Shipped
Employee Name David Welch
Client Name "shard name" ncsu, southalabama, IU
User System Admin
Functional Unit API
  • Attach files
  • Deleted User commented
    August 17, 2017 16:51

    Indiana (IU shard name) would also like to see this fixed.