Is there an Issue with POST requests to start queries and subsequently with GET requests to check when the query is finished?

Hi everyone,

I'm building an internal app to score records for data hygiene. My process involves sending a POST request to start a query and then polling for the result every 30 seconds.

The Issue: Up until last week, this worked fine. Now, the queries are getting stuck. When I run the same query manually in Database View or Web View, it finishes in about a minute. However, via the API, I've waited over 29 minutes (58+ checks) only to keep receiving a "status": "Running" response.

Troubleshooting done:

  • Isolated the API call into a standalone test script; the issue persists.
  • Confirmed the query size hasn't changed significantly.

Has anyone else experienced the SKY API "hanging" on queries lately, or is there a known issue with the asynchronous processing queue?

Any insight would be appreciated!

Best,
Matthew

Edits:
Im working with the RE endpoints.
Im checking for pending, running and completed status, any other status printed into the console as is.

Edit 2:
I believe its query complexity, Im going to split them into a couple and see how it goes givent the fact that the other 2 queries are running just fine but the main one i need ran for 50 minutes of checks every 30 secconds before i cancelled it.

Ill figure it out thanks guys

Answers

Categories