Get Database View Query via API (Proposal/Opportunities)

Bob Rowe
Bob Rowe
Name Dropper First Anniversary Facilitator 1
in Blackbaud Raiser's Edge NXT® APIs

I have custom fields in the Opportunity Module that cannot be added to a NXT Web View for an export (an NXT limitation). I am able to create a Database View Query that has all the fields/data that I need. Is there a way to access a Database View Query via the API?

I can get the data via the API directly with multiple calls. With custom fields it is a little more complicated.

Thanks for any suggestions!

Comments

  • Alex Wong
    Alex Wong Community All-Star
    Tenth Anniversary Kudos 5 Facilitator 4 bbcon 2025 Attendee Badge

    @Bob Rowe
    currently you cannot access exported data from RE database view's query/export via SKY API. This is in the work by Blackbaud, so it's upcoming.

    However, if you need the data from RE database view, you can consider using RE:Queue for now, which is basically a scheduler to export a query, export, or import (create export file). the export goes into a FTP location, which then can be accessed programmatically

Categories