API Call to use "export" module

John Bozek

Good afternoon All,

I am looking to automate the exporting of an “export” for upload into an SFTP server. I have done some skimming of the various endpoints and while I do see list/list v2 it does not appear that i can retrieve all of the information I would need in my export. Curious if there is a way through any of the endpoints to retrieve a preformatted export.

Alex Wong

@John Bozek
SKY API endpoint does not do EXPORT module. Query module exists to gather data and then you can play with it in power bi or power automate to format it the way you want.

If you want to use Export from dbview, then you will need to manually run the export or use RE:Queue, which is a paid module that you have to pay Blackbaud to get. RE:Queue will schedule export you want to do and place into a folder, you will configure the folder to save the scheduled export to the SFTP folder. THEN you can automate the “downloading” of the files using power auotmate or other automation tool that can connects to SFTP.

John Bozek

@Alex Wong
you're the man thank you; figured as much. Curious in a word or two would it be worth persuing a AutoHotkey/ run @ nighttime sort of work around or just bite the bullet and sell my org on Queue?

Alex Wong

@John Bozek
I don't know if AutoHokey is going to work well with a remote app access through Citrix.

You can potentially use Power Automate Desktop to automate the logging into RE NXT on browser, launching of RE database view, and click through to export what you want.

Erik Leaver

@John Bozek We held a session at bbdevdays that might be helpful: API & Queues & Backups, Oh My! What to consider when bringing data out of RENXT: