Export / Import - list creation & export or automation

Peter Groman
Peter Groman
Fifth Anniversary Participant
in Blackbaud Raiser's Edge NXT® APIs

TL;DR: New to Blackbaud. New to API. Need data from Blackbaud for our new 3rd party nursing app.

BACKGROUND: We use Blackbaud for our SIS and have been frustrated by the nursing module. We have purchased PSNI SnapHealth (cloud-based app). We need to get the data out of Blackbaud and into PSNI. PSNI has file import specifications that require “Normal Form” formatting. (Ie: One row per immunization per student, or 850 students x 24 immunizations = 20,400 rows).

PROBLEM: Blackbaud can export from lists, and under FACULTY / NURSES OFFICE / MANAGE MEDICAL LISTS we can export a CSV of the “Medical Worklist” that has immunizations. HOWEVER, this data is not in NF. Instead, it has 1 row per student, with 24 columns for immunizations. With no SQL server to facilitate ETL, and Excel's native transpose function being insufficient to handle this, I am at a loss as to how to transform this data. I even tried the Excel Power Query plug-in to de-pivot the columns, but with both vaccine-name and vaccine-date needing to remain together in groups of 24 vaccines, this just doesn't work. I called Blackbaud support and they have no way to do this. They recommended using the API.

So I am looking for guidance on pulling data using the API. I've never used APIs before and I am not a programmer. Any help would be appreciated.

Thanks.

Comments

  • Bryna Gleich
    Bryna Gleich Blackbaud Employee
    Tenth Anniversary Kudos 3 Name Dropper Participant

    Medical endpoints are not currently in the SKI API for Schools. There are additional security considerations for Medical data due to HIPAA, which is why Medical isn't available when using the impersonation function, for example. I recommend posting your question in the idea bank, in addition to this user community discussion forum. The idea bank enables other users to add comments and vote for ideas they also like. Product management monitors the idea bank and periodically replies with future roadmap information. Be sure to include details about what data is needed and how it would be used when you post an idea.

    https://developer.blackbaud.com/skyapi/support/ideas

Categories