Power Automate and Sky API

Options
Jason Guan
Jason Guan
Name Dropper First Anniversary Facilitator 1
in SKY Developer General Discussions

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?

Tagged:

Comments

  • Austen Brown
    Austen Brown Community All-Star
    Ninth Anniversary Kudos 5 Name Dropper Participant

    @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:


  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 PowerUp Challenge #3 Gift Management Name Dropper

    @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)
  • Jason Guan
    Jason Guan
    Name Dropper First Anniversary Facilitator 1

    @Austen Brown

    I was able use a webhook per the article. Is there a way to make the HTTP request secured?

    ff6b09b0a0971f7ce89e1570ff613dbb-huge-im

    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.

  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 PowerUp Challenge #3 Gift Management Name Dropper

    @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:

    a373a975f38b0f6d90c5fb089fb97991-huge-im

    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.

  • Jason Guan
    Jason Guan
    Name Dropper First Anniversary Facilitator 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?

  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 PowerUp Challenge #3 Gift Management Name Dropper

    @Jason Guan
    which webhook did you registered? (when gift created?)

  • Jason Guan
    Jason Guan
    Name Dropper First Anniversary Facilitator 1

    @Alex Wong
    Gift added - com.blackbaud.gift.add.v1

  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 PowerUp Challenge #3 Gift Management Name Dropper

    @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-lists

Categories