Export Issues

Peter Groman
Peter Groman
Fifth Anniversary Participant
in Education Management 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

    I don't think medical information is currently in the API endpoints. You can request it as a new idea though. Links to the endpoints and the idea bank are here:

    HIPAA concerns may limit what can be done with medical data though, so be sure to include some details about how your school app would use the information and why when you post the idea.

    General help documentation about how Medical works in Education Management.

Categories