I'm trying to figure out how to look at the returned results from a Query using the Query API and if there are no results, don't create a file. The results of the query are in the URL passed back. I'm not sure how to split that up so I can see if there is a second row of data that isn't the headers. Thanks, Carol
I am further refining my flow for in-kind gift form submissions. For this process an approval process is triggered when a form is submitted. That approval can be approved by one of several people. When Approved, another process is triggered for approval from one of a different set of people. When that is approved, an email…
As part of a data audit, I'm trying to locate all records that have an Attachment. We use PaperSave, so we need to find records where a user may have mistakenly uploaded their document to the Attachments panel instead of PaperSave. This isn't possible using Query or Lists. Using logic similar to that which is found in the…
It looks like we need to change our BBPS password (to enable a BBMS configuration in K12 Core). Support pointed us to a help document outlining how to update the stored password in the various products: When we asked about third-party systems (Blackbaud partners) that use BBMS as the payment processor, support asked us to…
Hello, we are getting the following error while trying to refresh the access token from time to time - let's say once per month for a period of 1 hour roughly : Failed to connect to oauth2.sky.blackbaud.com port 443 after 7077 ms: Connection timed out We believe the refresh token is valid because everything works fine most…
I'm currently working some projects that are geared more towards Data Engineering and Data Science with Blackbaud data. I've created this GitHub Repo with a Jupyter Notebook to show you how to handle the OAuth2 protocol and exchange authorization codes for access and refresh tokens. Full instructions are in the README…
Power BI question: I have a line and clustered column chart and I want the line to be a constant - a value I need to calculate based on filters and averaging. I have created a summary table with the value in it, but since it has only that value, I can't connect it to anything in the data model. I have also tried creating a…
Hello, I am attempting to pull every gift from 2008 to today in order to automate my tableau dashboards, I am fairly new to power automate but I have been trying to create a flow that allows me to do this. So far what I have created below is the closest I can get yet whe I run the flow it keeps on failing. I am almost at…
- Description: As a follow-up to my “Mac to the Future” #bbdevdays discussion, here is a basic example of linking Apple Shortcuts to the Power Platform. This allows one to kick off an on-demand process (such as a gift digest) with parameters directly from Mac / iPhone / iPad without needing to log into Raiser's Edge NXT. -…
I am so happy we have Query API now to help narrow the scope of our actions workflow (more than the available ‘list actions’ item). It took a while for me to figure out how to get the action ids in a useable manner, though. I'm sure my method is not as elegant as it could be (and I would love any tips for cleaning it up),…
It looks like you're new here. Sign in or register to get started.