Downloading data using Python. Getting object type errors.

Beverly Wallrauch

Hello all. I am a newbie to Python as well as Financial Edge API endpoints. I am trying to download data for use in our data lake. I am trying to convert the json response received from the get command and write the contents to a csv file. Has anyone done this successfully?

Alex Wong

@Beverly Wallrauch
there are multiple ways you can do this in multiple programming language option. I have done it from JSON to SQL insert into MSSQL tables using T-SQL OPENJSON. I have also done it with TypeScript creating a 2-dimensional array and then writing to csv file.

You will want to first look into what kind of support does Python has for JSON object.

Beverly Wallrauch

@Alex Wong Thanks you. Actually I would prefer doing this in SQL and SSIS would be even better. My question here is how would one connect to the API endpoint?

Alex Wong

@Beverly Wallrauch
you can find the info and sample @ https://developer.blackbaud.com/skyapi/

steps are simple (once you get the structure in place).

get authentication token

use authentication token to make the api call to get data

process data into whereever you plan to warehouse the data.

There are many post about authentication token in the community forum.