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.
