- Description: Use the new (still in public preview) Query API to run an ad-hoc database query (without actually having a query saved in database) to get No Valid Address and Request No Email property of constituent record that is not available from SKY API Constituent List. The flow actually run the API and get the information to store into Azure data warehouse table, but you do not have to and can instead be saved to SharePoint/OneDrive or other cloud storage for use later in your Power BI. This is a pretty quick running flow for more than 400K records, takes less than 2 mintues to run and store into data warehouse.
- Required connections: Blackbaud SKY Add-ins; MS Teams (for error handling messaging); Azure SQL (for processing into Azure SQL database)
- Suggested skill level required to use this template: Intermediate
- Configuration details:
- does not require you to have a query setup in database view first, so no need to worry about the query being accidently deleted
- Category: Automation, Data Management, Integration
- Instructions:
- Download and import and update the flow save name and connection
Ad-hocQueryAPIExportNVAandRNE_20240229173352.zip - if you want to save to onedrive, then delete the actions that “Select As JSON”, “Execute SQL TRUNCATE TABLE” and “Execute SQL INSERT from JSON”
- Depending on if you want the CSV saved or and Excel file in the cloud storage, refer to the following post.