Is there a way to find all of the records where response_status_code is null?

[venkataraghavan]

Currently, in a custom report, the only way to get a list of calls that have had a response status code of null seems to be to check for ! of all other error codes.

i.e response_status_code notin 200,201,400,401,402,404,406,424,423,500,503

response_status_code < 0 also does not work.

[anshul_]

A status code of 0 in an NSHTTPURLResponse object generally means there was no response, and can occur for various reasons. The server will never return a status of 0 as this is not a valid HTTP status code.

There are high chances that your user agent couldn't send the request to server because of various reasons and sent back 0 status code in response.

So, I don't think that you will be able to capture 0 status code in the analytics report ever.

[venkataraghavan]

Thanks for the response @aagrawal . However, like I said, we are able to capture null response errors with response_status_code notin 200,201,400,401,402,404,406,424,423,500,503

We are looking for a simpler query.

[anshul_]

oops my bad.. Following is what I found in API docs, which might help you:

Returns metrics for API calls that didn't result in errors:

filter=(is_error eq 0)

Please , let me know if it doesn't work.