Is there an SKY API Reference for the Export Module of DB View?

Oscar Ira
Oscar Ira
Name Dropper Participant Facilitator 1
edited August 5 in Blackbaud Raiser's Edge NXT®: General Discussions

I have an Export that filters duplicate records of all Constituents in DB View and would like to know if there is an API Reference that I can use (like Standard Reports Endpoint References) to run that Constituent Export and run it automatically using PowerAutomate.

Tagged:

Answers

  • Austen Brown
    Austen Brown Community All-Star
    Ninth Anniversary Kudos 5 PowerUp Challenge: Product Update Briefing Feedback Task 3 bbcon 2025 Attendee Badge

    WV Export is currently in development and there are no specific Export APIs as of right now. However, you can use the existing APIs and Power Automate connectors to emulate an export as a work around. You can use it to extract data via a Query, then run through a series of actions to determine the remainder of the information needed within the export to either write to a CSV or a table in an XLSX.

  • Oscar Ira
    Oscar Ira
    Name Dropper Participant Facilitator 1

    Thank you Austen! I was trying to get the information of all the constituents with all their phone 1(home) and phone 2(mobile) in one row and not repeating. We have 268,000 donors and would like to see the same no in my csv output. I have a query for all the constituents and need a power automate flow to accomplish this. Do you have a similar flow that you can share to get the series of actions to determine the information that i needed? Thank you!

  • Austen Brown
    Austen Brown Community All-Star
    Ninth Anniversary Kudos 5 PowerUp Challenge: Product Update Briefing Feedback Task 3 bbcon 2025 Attendee Badge

    Due to the volume, I'd recommend doing a Export out of DBV to your BB FTP folder and then having a flow trigger from the 'new file added in FTP' to use the contents of the export in a flow. Going through the API that would be a LOT of calls and you may start hitting limits.

  • Austen Brown
    Austen Brown Community All-Star
    Ninth Anniversary Kudos 5 PowerUp Challenge: Product Update Briefing Feedback Task 3 bbcon 2025 Attendee Badge

    Here's a shared template from @Alex Wong that talks through how to grab a CSV from an FTP and then utilize the contents in a flow:

    https://community.blackbaud.com/discussion/63726/sharing-my-power-automate-template-re-queue-csv-to-sharepoint-excel-table
  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 Facilitator 3 Raiser's Edge NXT Fall 2025 Product Update Briefing Badge
    https://community.blackbaud.com/discussion/comment/305572#Comment_305572

    Go with what Austen recommended if you are doing this once in a while, but if you want to do this more often and want more automation not manual exporting from dbview, you can use Query API to accomplish this.

    in query api, you can set output to export 1 column for a "phone (email)" type per column.

Categories