Actions API failing (HTTP 500 Error)

The “Action List (All Constituents)” API is returning an HTTP 500 error for all calls today (7/17/2024). I'm running the same code against the Constituent List, Address List, etc API's and those are all working. Even running the Actions API in the “Try it” console is failing.

Is anyone else encountering this issue?

Comments

  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 Facilitator 3 bbcon 2025 Attendee Badge

    @Mitch Hollberg
    i just used the try it console for action list all constituent and it is working for me, so it is not a global issue.

  • Dan Snyder
    Dan Snyder Community All-Star
    Tenth Anniversary Kudos 5 bbcon 2025 Attendee Badge PowerUp Challenge: Product Update Briefing Feedback Task 3

    @Mitch Hollberg I am experiencing the same with actions using the HTTP request in my flow and have been for a couple days. I also have a flow to add new students from an Excel table and that is “failing” by just continuously running. It is able to get the data from the Excel table, but the next step of adding a new constituent is not triggering.

  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 Facilitator 3 bbcon 2025 Attendee Badge

    @Dan Snyder
    can you post some screenshot of what action is failing, with error of fail, and the same action when in editing mode.

  • Hi, @Mitch Hollberg

    My Sky API scripts started failing on Tuesday, and I'm unable to authenticate when using “Try it”. I just opened a support case.

  • Dan Snyder
    Dan Snyder Community All-Star
    Tenth Anniversary Kudos 5 bbcon 2025 Attendee Badge PowerUp Challenge: Product Update Briefing Feedback Task 3

    @Mitch Hollberg

    I have an open case about this and referenced your post in the notes so hopefully we can get this resolved.

    @Alex Wong
    I kicked this one off this morning and it is still running 2 hours later. basically it is at 11 retries at this point and I suspect will fail when it hits about 3 hours (more below)

    021c09efdc0b605c7fcaeccbe4c6bb93-huge-im

    Here is an error from yesterday and the flow ran for 3 hours

    bd97f443565093a35b7b99312a27dfe8-huge-im

    Here is edit mode:

    7f0090a822a3511ae4dfd386e2427f67-huge-im

  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 Facilitator 3 bbcon 2025 Attendee Badge

    @Dan Snyder
    I am looking at the actoin list for all constituent api endpoint, and does not see a query parameter for “completed” that is of type boolean.

    https://developer.sky.blackbaud.com/api#api=56b76470069a0509c8f1c5b3&operation=ListActionsAllConstituents

    Here's my call without any query paramter that is successful:

    35864466ebcf8d85572a17ff42a0ff35-huge-im

    here's my call with the date_added parameter, which I used the same expression , except a little longer time ago as I'm not sure if we got something in last 24 hours: addHours(utcNow(), -2000)

    34d79d3a6de5c0671909b33e25ff668f-huge-im

    then added the completed=false parameter:

    f113d5a84cd5475e328031ce4d69f292-huge-im

    they are all successfully ran.

    so while the API documentation did not say anything about the completed parameter, the endpoint will take it, but I checked the returned actions, this parameter is definitely ignored.

    1f8f8061111e181c90d5de889c373069-huge-im
    the run that has the completed=false, you can see both true and false is returned

    it is possible that BB changed this at some point but I haven't seen any announcement of this.

    The documentation did mention a “computed_status” parameter, though I am not sure if that's the data point you want. You might want to use a “filter array" action to filter on the completed=false actions instead.

    Though the issue you hae is not related. The only other situation I can think of is server related. Are you hosted in Azure or Blackbaud hosting?

  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 Facilitator 3 bbcon 2025 Attendee Badge

    @Dan Snyder
    I would check the action's setting on retry too, don't use default retry policy, it doens't make sense to error out so many times and exponentially retry and have the flow run for 3hr.

    I recommend a fixed retry

    b8d83a596ae9c47be74c3dbe7b140431-huge-im

    5 reties, retry every 30 seconds.

  • Dan Snyder
    Dan Snyder Community All-Star
    Tenth Anniversary Kudos 5 bbcon 2025 Attendee Badge PowerUp Challenge: Product Update Briefing Feedback Task 3

    @Alex Wong
    We are Azure hosted. My try it without any parameters returns the 500 error. I wonder if the recent action list improvements have anything to do with this issue as it was running just fine for I'd say a couple months but now it is failing.

  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 Facilitator 3 bbcon 2025 Attendee Badge

    @Dan Snyder
    yea, this is odd, you will want to open a support case and most likely have to esculate as regular support team for RE NXT (there is still no SKY API related support team) is generally unable to help.

    @Erik Leaver may be able to help move things along faster too if you provide the support case #

  • @Dan Snyder

    Thank you Dan.

    For what it's worth, here's what I get when calling the Actions List endpoint using the “Try it” option on the API documentation page (here: https://developer.sky.blackbaud.com/api#api=56b76470069a0509c8f1c5b3&operation=ListActionsAllConstituents)

    b276e62d6c03a10b89ce4601ae58d301-huge-im


  • Dan Snyder
    Dan Snyder Community All-Star
    Tenth Anniversary Kudos 5 bbcon 2025 Attendee Badge PowerUp Challenge: Product Update Briefing Feedback Task 3

    @Alex Wong Ah, great point I just changed it so it will give me an error faster. Thanks for that tip.

    @Mitch Hollberg That is the exact error I had with the same endpoint.

  • @Mitch Hollberg I'm also getting the error on a few environments that we support. In my case, it's Error 502 Bad Gateway. All other endpoints are working effectively. I'm starting a case

  • @Mitch Hollberg Scratch that, I think 502 Bad Gateway is a Power Automate response. In Try it, I'm getting the same Error 500, Internal Server Error

  • Erik Leaver
    Erik Leaver Blackbaud Employee
    Tenth Anniversary Kudos 5 First Reply Name Dropper

    @Alex Wong Confirmed a bug has been submitted & being triaged.

  • @Mitch Hollberg
    Thanks to everyone that chimed in on this thread. As of about 4PM Eastern time on 7/23/2024, the “Action list (All constituents)” API seems to again be working (at least for me).

    I'm still interested to know if anyone else continues to experience issues with this, but at least for now I'm able to pull all the actions data I need.

  • Dan Snyder
    Dan Snyder Community All-Star
    Tenth Anniversary Kudos 5 bbcon 2025 Attendee Badge PowerUp Challenge: Product Update Briefing Feedback Task 3

    @Mitch Hollberg Mine seems to be working today as well.