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

Question

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.

Alex Wong · Answer

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.

Austen Brown · Answer

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

Austen Brown · Answer

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.