Advance List for Education Management API Returning 429 Error

Lindsey Bryant · June 16

Are others experiencing issues with the Advance List API: https://developer.sky.blackbaud.com/api#api=school&operation=V1ListsAdvancedByList_idGet

We use this one quite a bit to pull down student grades, employment details, contract details, etc and all of a sudden we are getting a 429 error.

I tested things out in Postman under my own developer account and I'm getting:

"One or more errors occurred. (The HTTP status code of the response was not expected (500).\n\nStatus: 500\nResponse: \n{\"Message\":\"An error has occurred.\"})"

and if I run it again I get:

"Limited by error rate".

@Stephen Boyle did something happen with the releases today that I missed?

@Todd DeSchuiteneer I put a support case in as I didn't see anything in the release notes for today. Case Number: 020928182.

I also tested this out with an advance list that we don't use in any of our integrations and I'm getting the same error message.

Brian Gray · June 16

My programs use that endpoint frequently. All of my programs are running as expected. They can read the Advanced Lists as usual with no errors.

Scott Minkoff · June 16

I am having similar issues with getting advanced list data in Power Automate using the Sky API tool. Did you hear anything yet?

Todd DeSchuiteneer · June 16

@Lindsey Bryant are you using the School API GET lists endpoint to return the list? https://developer.sky.blackbaud.com/api#api=school&operation=V1ListsAdvancedByList_idGet

Typically when you received a 429 error its because the list is returned an error when calling and is in a 60 second time-out period. While in this time-out the response from the API if called again will be 429 "Limited by error rate"

Lindsey Bryant · June 16

@Scott Minkoff nothing yet. I have confirmed it appears to be isolated to two of my advance lists that I have created to pull down employment and employment departments. These have been working for years, so I'm not sure why it stopped today. I can see other advance list working again.

However, these same two advance list are failing in all three environments we have with the same error of 429 to many responses. Even if I put a page_size=1000 in it, I'm getting the error immediately. What is truly baffling is if I create a copy of the advance list and run it, I get the same error message. If I create a brand new report, it seems to work fine.

Todd DeSchuiteneer · June 16

@Lindsey Bryant my apologies, I missed the link to the endpoint you posted in the original post. I am checking in with my dev team to see if perhaps there are some lists stuck in that timeout status.

Lindsey Bryant · June 16

@Todd DeSchuiteneer thanks for the reminder. I am using the API you tagged. It just started to happen today with no changes to the advance list. I went into the UI, created a copy of the report, and I'm getting the same error. However, If I create a brand new advance list based off the old report and try it, it works fine.

What's extremely strange is they fact that I'm getting this 429 error through Postman where the 429 error is coming through our ETL tool; so essentially two different accounts. I also added in the page_size parameter as I could see that it may be an issue with the timeout as you mentioned but that doesn't seem to resolve it

I vaguely remember having this or a similar issue in the past and thinking I had to recreate the advance list. Does that make sense or ring a bell?

Scott Minkoff · June 16

@Lindsey Bryant Thanks. I'm still investigating on my end. If I figure out anything that narrows down the issue here, I will post.

Todd DeSchuiteneer · June 16

@Lindsey Bryant @Scott Minkoff our team identified and issue and are working to resolve now. Shouldn't be too long till resolution but I will let you know here as soon as it's taken care of.

Scott Minkoff · June 16

@Todd DeSchuiteneer Thanks!

Michael Nardulli · June 16

I just wanted to chime in to say that I'm experiencing the same issue. It goes beyond any in particular script I've written. If I go to https://developer.sky.blackbaud.com/api#api=school&operation=V1ListsAdvancedByList_idGet and click "Try it", then enter a list_id I get the same result. A 500 error, followed by a 429 on a second attempt. The 429 is explained by the 500 error (there's a Rate Limiting" call out in the link above that explains what that's about.)

I even tried creating a brand new advanced list and populating it on the "Try it" page and got the same result. Something is flagging 500 responses via the "List Single" endpoint. Although, based on this thread, it doesn't seem to be happening to all users.

Has anyone found anything out?

Todd DeSchuiteneer · June 16

@Lindsey Bryant @Scott Minkoff @Michael Nardulli this issue should now be resolved.

Robert Raymond · June 16

yes, same issue. the new Core list API is working. BB-please update when fix.

Scott Minkoff · June 16

@Todd DeSchuiteneer , seems to be working for me now. Thanks!

Michael Nardulli · June 16

Back up and running here - much appreciated!

Robert Raymond · June 16

thanks!

Lindsey Bryant · June 17

@Todd DeSchuiteneer thanks for your quick and continued support! Everything is working great over the past 12 hours or so.

Stephen Boyle · June 17

This should be cleared up now. My apologies.

We were working on an issue concerning paging in the Advanced list endpoint and there was a difference between the dev and production environments that caused the fix to fail in Prod. Those changes have been rolled back.

Advance List for Education Management API Returning 429 Error

Answers

Categories