Hi all, I’m reaching out to see if anyone has successfully connected Power Automate to the Blackbaud CRM read-only database (RODBA) using the SQL Server connector. For context, our BBCRM is fully hosted by Blackbaud (Azure SaaS), and we have the optional read-only database access enabled. We can successfully connect to…
Hello erudite colleagues, I am trying to automate some queries for a reporting task I have been given and I need the queries to be dynamic as in I want to supply dates INTO the query at run time programmatically, so I can run a bunch of them and harvest the resulting data. I don't want to use the ASK syntax as I want the…
Description - Run Blackbaud Education Management List jobs based on items in a SharePoint List, retrieve results, and save results as CSV files in SharePoint with error notifications if failures occur. Use cases - Use this flow to quickly add and remove Advanced, Basic, or Sky lists or change save locations with easy…
A UK based client is asking me how they set the GiftAid fields on a gift. I have looked in both the Gift and Gift2 APIs but have not seen any GiftAid references. When I look at the GiftAid API I can see a method Get gift record with gift splits by gift ID (PREVIEW) This gets the relevant fields such as…
Hi, We're looking at calling the Just Giving API to return gifts that we then prepare in a data warehouse then pass into batches for review by fundraising. We will want to be able to have these gifts soft credited to the fundraising page owners. Has anyone done this with success? Shaun
I have created a flow that works when I hard-code a date in the options, but this is going to run daily and it want it to use "today's date". I initially tried utcnow(), but that didn't work, so then I used the let copilot create an expression for you, which gave me formatDateTime(utcNow(), 'yyyy-MM-dd'), but that's not…
Hi everyone, We are currently working on integrating a digital membership card solution with Blackbaud Altru to enhance our member experience (e.g., QR-based digital cards, mobile wallet support, etc.). However, we are facing a few challenges during the integration process: Limited clarity around accessing and using Altru…
We require that users of our marketplace app have access to the NXT Extensibility role. At least two orgs have now reported that even though they are admin users they are getting a message from us telling them that they do not have the role. We make a call to the NXT Data Integration API in order to determine if they have…
Hi everyone, I'm building an internal app to score records for data hygiene. My process involves sending a POST request to start a query and then polling for the result every 30 seconds. The Issue: Up until last week, this worked fine. Now, the queries are getting stuck. When I run the same query manually in Database View…
Does anyone know if the SKY Developer Cohort environment is configured not to capture a Home address for a new Constituent when no email is provided—only a valid mailing address? We are using this endpoint = 'https://api.sky.blackbaud.com/constituent/v1/constituents Additionally, we are implementing the new Blackbaud…
It looks like you're new here. Sign in or register to get started.