Downloading data using Python. Getting object type errors.
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?
Comments
-
@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.
1 -
@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?
0 -
@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.
0
Categories
- All Categories
- 6 Blackbaud Community Help
- 206 bbcon®
- 1.4K Blackbaud Altru®
- 394 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 1.1K Blackbaud CRM™ and Blackbaud Internet Solutions™
- 15 donorCentrics®
- 357 Blackbaud eTapestry®
- 2.5K Blackbaud Financial Edge NXT®
- 646 Blackbaud Grantmaking™
- 561 Blackbaud Education Management Solutions for Higher Education
- 3.2K Blackbaud Education Management Solutions for K-12 Schools
- 934 Blackbaud Luminate Online® and Blackbaud TeamRaiser®
- 84 JustGiving® from Blackbaud®
- 6.4K Blackbaud Raiser's Edge NXT®
- 3.6K SKY Developer
- 242 ResearchPoint™
- 118 Blackbaud Tuition Management™
- 165 Organizational Best Practices
- 238 The Tap (Just for Fun)
- 33 Blackbaud Community Challenges
- 28 PowerUp Challenges
- 3 (Open) Raiser's Edge NXT PowerUp Challenge: Product Update Briefing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports+
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Email Marketing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Gift Management
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Event Management
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Home Page
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Query
- 778 Community News
- 2.9K Jobs Board
- 53 Blackbaud SKY® Reporting Announcements
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)
