Searching data / Building a query / Operations reference / Network group / HTTP Status Type (httpstatustype)
HTTP Status Type (httpstatustype)
Description
Given a field containing HTTP status codes, this operation creates a new column containing the corresponding HTTP status code type (or class). The valid types are:
- Informational (100-199) - The request was received, continuing process
- Successful (200-299) - The request was successfully received, understood and accepted
- Redirection (300-399) - Further action needs to be taken in order to complete the request
- Client Error (400-499) - The request contains bad syntax or cannot be fulfilled
- Server Error (500-599) - The server failed to fulfill an apparently valid request
How does it work in the search window?
Select Create column in the search window toolbar, then select the HTTP Status Type operation. Only one argument is required.
Argument | Data type |
---|---|
Status code (mandatory) | Integer |
The new column's data type is string.
Example
We want to get the types associated with the HTTP status codes in the statusCode column, so we click Create column and select the HTTP Status Type operation. Select statusCode as the argument and assign a name to the new column - let's call it statusCodeType.
Click Create column and you will see the following result:
How does it work in LINQ?
Use the operator select... as...
and add the operation syntax to create the new column.
httpstatustype(integer)
Examples
Copy the following LINQ script and try the above example on the demo.ecommerce.data
table.
from demo.ecommerce.data
httpstatustype(statusCode) as statusCodeType