Query API outputs "Viewing this query is not yet supported" for some requests

@Alex Wong

I feel like I'm really close to a successful test here, but I've run into what looks to be one final snag.

So, I've built a script that sends a POST request to execute a query job, (using the existing query ID), and as expected, it returns a JSON object containing the job id (randomized string) and a job status ("Pending"). All good, that part of the script seems to be working fine.

Here's the API docs page I'm referencing for this part.

However, when I then pass the id into a GET request for the job execution status (so that I can determine when the query job is complete, as well as the URL for where the results will be hosted), I'm simply getting a “404 Client Error: Resource Not Found for URL” error. An example is here:

HTTPERROR: 404 Client Error: Resource Not Found for url:

Here's the API docs page I'm referencing for this part.

I've been looking at this for some time now, but I cannot figure out what I'm doing wrong, so I'm looking for a fresh pair of eyes here. The job ID I'm using looks like it should work, considering that the BB server successfully returned the information on my initial POST request. Is there anything that you can see that is missing in what I'm doing?

Here are the outputs I'm printing to the console. Right after the last line is where I get the 404 error:

@Alex Wong

For the POST:

URL: "https://api.sky.blackbaud.com/query/queries/executebyid"

Query Parameters: {
"product" : "RE",
"module" : "None"
}

Request Body: {
"id" : "51089"
}

_______________________________________________________________________

For the GET:

URL: “https://api.sky.blackbaud.com/query/jobs/”

Query Parameters: {
"product" : "RE",
"module" : "None",
"include_read_url" : "OnceCompleted",
"content_disposition" : "Inline"
}

@Alex Wong
Well, I was going by the API documentation regarding the defaults, so I didn't think that I would need to explicitly define them if I were okay with their default values. However, it's still a good suggestion, at least for troubleshooting purposes. Some of your values seem different from the defaults, but I'll still select the ones you've picked. I'm assuming that this is what you are asking me to do:

Here's the request body data for the query execution request (POST):

{
"id" : "51089",
"ux_mode" : "Asynchronous",
"formatting_mode" : "None",
"sql_generation_mode" : "Export",
"output_format" : "JSON"
}

And then the params:

{
"product" : "RE",
"module" : "None"
}

______________________________________________________________________________________________

Here are the params for the query job status request (GET). Note, there is no request body, of course, since that is not listed as a requirement in the docs:

{
"product" : "RE",
"module" : "None",
"include_read_url" : "OnceCompleted",
"content_disposition" : "Attachment"
}

Same issue and same error, unfortunately…