API Request throttling issue

Rachel Le
Rachel Le
Name Dropper Facilitator 1
in SKY Developer General Discussions

We are using Sky API to pull data from Raiser's Edge DB to our data warehouse, but are getting the following message when submitting new API Requests:

{
"id": "[idon'tknowifthisissensitivebutwillredactanyway]",
"status": "Throttled",
"message": "Your request is being delayed because you have too many queries running right now. Your request will run once other queries have completed. You will receive a notification when this request has completed."
}

Is there any way for us to kill the queries that are running so we can reset and try making new API requests?

We appreciate any insight/help that others can provide.

Comments

  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 Facilitator 3 Raiser's Edge NXT Fall 2025 Product Update Briefing Badge

    @Rachel Le
    Looks like you are issuing Query API? The error message looks to be for Query API rather than “normal” SKY API endpoint (which will have a 429 error if rate limit issue).

    If you did issue too many Query API, assuming you recorded the JOB ID (if you didn't, then your process is incorrect, since you need the JOB ID to get the status of the query job and finally get the sas_uri to download the output), you can get the status of each JOB ID. If you dont' have the JOB ID, then you will just have to wait it out, there is currently no API endpoint to get a list of submitted query job.

  • Rachel Le
    Rachel Le
    Name Dropper Facilitator 1

    @Alex Wong
    Thanks for the insight. At the moment I am not needing status updates on the queries but the ability to kill the process because we have had one query running for over a week now. Do you know if that is possible, or do I have to just wait it out?

  • Chris Rodgers
    Chris Rodgers Blackbaud Employee
    Ninth Anniversary Kudos 2 Name Dropper Participant

    Hey @Rachel Le,

    I'm with the SKY API Team. At this point, you may want to reach out to Blackbaud Support if the job has been pending for over a week. If you have the Job ID for the query that is pending, that will help the Query team identify and terminate the job. If you have your SKY Application ID and Blackbaud Environment ID handy, those will be helpful as well.

  • Rachel Le
    Rachel Le
    Name Dropper Facilitator 1

    @Chris Rodgers
    Thank you so much for letting me know what information is needed.

Categories