Question 69850 in Ajax Question posted in
You can find the official documentation here.

How do i get HTTP status code 200 instead of 202 from an ajax call – Jquery ajax

The below code always receives a HTTP ‘202 Accepted’ status code:
enter image description here

When I try the same API using postman I get 200 OK":
enter image description here

function ExportStatus() {
  function ExportStatusAjax() {
    $.ajax({
      type: "GET",
      url: "https://api.powerbi.com/v1.0/myorg/groups/" + groupId + "/reports/" + reportId + "/exports/" + exportId + "",
      headers: {
        "Authorization": "Bearer " + accessToken
      },
      success: function(data, textStatus, jqXHR) {
        if (jqXHR.status == 200) {
          GetExportFile()
        } else {
          ExportStatusAjax()
        }
      },
      error: function(err) {
        alert(error)
      }
    });
  }

  ExportStatusAjax()
}
Tags:

2

Answers


  1. 0

    You have a recursion that will never end. ExportStatusAjax() calls itself in 2 places at least. Remove it from your code at all. And don’ t pay to much attention to the status codes if there are not 400x or 500x. As soon as it returns to success you are ready to continue.

    Login or Signup to reply.
  2. 0

    I am not familiar with Power BI, so I can’t say for sure, but judging by your code and the API status codes, this looks like a case of an asynchronous API. What that means is, instead of the traditional model in HTTP where the client submits a request and gets the response back (this is a 200, a.k.a. OK), a client submits an HTTP request and the response is a placeholder to tell you that the real response is not ready yet.

    202 is called Accepted and I believe that in this situation it is being used to indicate your request has been accepted into a queue. The idea being that, if you keep retrying, eventually it will be done and you’ll get the real response, which comes with a status code of 200. Reports, analytics, or other sorts of computationally expensive workloads often follow this pattern.

    This approach is a common pattern. If that is in fact what is happening here, then your code is probably correct and seeing the response flip between 202 and 200 is normal.

    With that said, your approach is constantly hammering the server. As soon as it gets back a 202, it immediately retries, which adds load to the remote system, which theoretically may actually slow it down.

    I suggest putting in a timer to delay the retries, maybe every 3 seconds or 5 seconds or so. The setTimeout function can help you.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search