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

Oscar Ira

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.

Austen Brown

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

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

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

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

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.