Power Automate and Sky API
I am in the process of creating a gift notification that will send an automatic email to me every 20 minutes (for now). The process will check for gifts entered in RENXT from that time frame and send me a gift notification. I am running into an issue, where I am calling for the List of Gifts and it seems that the call does not give me all of the latest gifts. For example, we entered a gift at 10:52 AM and 11:00 AM. My gift notification should give me all gifts made from 10:50 AM - 11:10 AM, but it only gave me the 10:52 AM gift and not the 11:00 AM gift. Has anyone run into this issue?
Comments
-
@Jason Guan - I recommend you set up a webhook instead. The flow will trigger after a gift is entered into the system, and therefore won't be restricted to scheduling. The output can be an email, excel file, or even a teams message.
Here's more info on how to do this:2 -
@Jason Guan
gift list is subject to a “delay” (i don't remember exact minute of delay).So first you should confirm if in subsequent runs, the gift eventually come up or not
there can be other situation with the way you are calling the gift list API, so more screenshots of your flow will help diagnose the issue.
Austen's reply is valid as well, if you need to know in such short time inteval of gift added, then using a gift added webhook is best, however, keep these in mind:
- webhook will trigger PER gift created, so if you got 100 gifts batched and committed, 100 RUN of the flow will happen, if your flow is sending you email, you will get 100 emails
- API rate limit is a problem with webhook, 10 API call per seconds could become your nightmare, you will start getting a lot of 429 rate limit error. To combat this, you can limit your webhook flow trigger to set a “concurrency” limit of 3-5 (max)
3 -
I was able use a webhook per the article. Is there a way to make the HTTP request secured?

Currently, the HTTP request is set to “Anyone”. From my understanding, it is not the best secured option, but I would get an error if I was to use the other two options. I am not sure how to add Blackbaud SKY API as a user under “Specific users in my tenant”. Any help is appreciated.
0 -
@Jason Guan
webhook is Blackbaud calling the URL and post the data (i.e. webhook for when gift is created will post the gift system id, constituent system id, added by id, and last changed by id). Blackbaud is not going to call the webhook URL with your tenant credentials.You will also want to change the setting on the trigger:

otherwise, when someone approve/commit a LOT (hundreds or thousands) of gifts, your flow may suffer from congestion. I allow only 5 at a time. Note that by default, there is no limit.
1 -
@Alex Wong
Thanks! The webhooks is working, but I am running into a different issue with the flow. In my flow, I am calling for “Get constituent first gift”. I am getting a “The given constituent does not have any gifts” error, which causes my flow to fail. I am using the call to see if the constituent is a first time giver. There seems to be sort of delay as I resubmitted the flow a few minutes after and it works. Is there any work arounds to get a constituent's first gift?0 -
@Jason Guan
which webhook did you registered? (when gift created?)0 -
@Alex Wong
Gift added - com.blackbaud.gift.add.v10 -
@Jason Guan
webhook is immediate, at the moment the gift is created (with maybe a few seconds delay). However, there are some API calls that requires “processing” to the RODS. You can read a bit more about this here: https://developer.blackbaud.com/skyapi/docs/in-depth-topics/api-lists1
Categories
- All Categories
- 6 Blackbaud Community Help
- 206 bbcon®
- 1.4K Blackbaud Altru®
- 394 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 1.1K Blackbaud CRM™ and Blackbaud Internet Solutions™
- 15 donorCentrics®
- 357 Blackbaud eTapestry®
- 2.5K Blackbaud Financial Edge NXT®
- 646 Blackbaud Grantmaking™
- 561 Blackbaud Education Management Solutions for Higher Education
- 3.2K Blackbaud Education Management Solutions for K-12 Schools
- 934 Blackbaud Luminate Online® and Blackbaud TeamRaiser®
- 84 JustGiving® from Blackbaud®
- 6.4K Blackbaud Raiser's Edge NXT®
- 3.6K SKY Developer
- 242 ResearchPoint™
- 118 Blackbaud Tuition Management™
- 165 Organizational Best Practices
- 238 The Tap (Just for Fun)
- 33 Blackbaud Community Challenges
- 28 PowerUp Challenges
- 3 (Open) Raiser's Edge NXT PowerUp Challenge: Product Update Briefing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports+
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Email Marketing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Gift Management
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Event Management
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Home Page
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Query
- 778 Community News
- 2.9K Jobs Board
- 53 Blackbaud SKY® Reporting Announcements
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)

