The most recent content from our members.
Description: This shows an example of how you can use Power Automate to periodically leverage the Query API to update Query Date Filters to enable a "rolling" time period such as "last 30 days", etc. This uses the Edit / PATCH Query endpoint to update the starting date on a regular basis (such as nightly at 12:01 am). This…
I've been asked to pull a list of donors that have given in November & December to certain funds going back as far as we have data. Any ideas on how to pull that?
New We’ve introduced two new query fields into web view: Address Processing and Consecutive Years Giving Summary. Address Processing fields help you identify the best address for individuals and organizations. Consecutive Years Giving Summary fields help you find constituents who have given gifts in consecutive calendar…
I've been trying to set up automated query download with SKY API. I have the regular api like https://api.sky.blackbaud.com/constituent/v1/constituents and https://api.sky.blackbaud.com/query/queries working just fine. I have the Analysis - Query - Export permission and have verified that I can export a query to a file…
Do you have experience using, leveraging, and improving nonprofit databases? Do you have experience in data analysis? Come join our talented Philanthropy & Alumni Engagement team at Augusta University in beautiful Augusta, Georgia! We are currently hiring a Database Services Manager in our Information & Data Services…
Queries in both views are in synch realtime. So if you're in the middle of working with a query in web view and still feel like classic query is your comfort zone, you can instantly go into database view and pick up with that same query where you left off. The same goes in the other direction. Your queries in database view…
Hi all, Every year we pull an export with donors who give over a certain amount during the prior fiscal year that are associated with a group of campaigns. Also, included in the list are individuals who gave during the fiscal year even if the gift is associated with a prior campaign. When I created the query, I used the…
We use ImportOMatic in DBV and need ALL the same features in Omatic Cloud. We have been through the training with the onboarding rep. They told us they cannot do the transformations we need them to do. We are looking for alternatives to Omatic Cloud that have the full functionality of Import0Matic in DBV. We gather names…
Hello, After posting here about my goal of Mirroring RE NXT Data for Use in Power BI, I read a lot of excellent discussion and received some great ideas. While Power Automate seemed like the most versatile solution, I was trying to find a solution that didn't require any financial investment. One suggestion was to make use…
It looks like you're new here. Sign in or register to get started.