Automate extraction of an existing report.

Automate extraction of any existing report in Award Management System. 

SFA would like to push the scholarship application status, drafted or submitted, into the Banner system.  So all of our student employees and financial aid employees could see what a student's scholarship application status is.  We have reports of the status built in Award Management, but have to manually pull them out, give to our IT department, so they can manually load it into Banner.  If we could have the report run and extract automatically, we could post an updated status to Banner daily. 

  • Tammy Mitchum
  • Sep 25 2019
  • Already exists
Client Name "shard name" sfasu
User System Admin
Functional Unit API
Employee Name Tammy Mitchum
  • Attach files
  • Victor Swindell commented
    July 12, 2021 13:45

    your IT Department should be able to create something..
    Can automate the API by putting them in a script that is put on a schedule.

    A programmer can use the Banner API's to automate importing these reports...

    (we have)


  • Admin
    Carrie Goldberger commented
    October 11, 2019 19:18

    Hi Tammy,

    We recently released an Applications API which will allow you to automatically query any of the application grids in the system. It includes a field for the application status. You can find the documentation for this API in your site by going to Site > Settings > Import & Export Tools, and scrolling down to the documentation link.

    Let us know if this API isn't what you're looking for.

    Thanks!

    -Carrie