Table to store errors

[Mahendran]

Is there any Table in Saviynt which stores the below errors

1. Authentication Errors
401 Unauthorized: This indicates that the API request is missing authentication credentials or the provided credentials are invalid.
Response Example:
{
  "error": "Unauthorized",
  "message": "Invalid API key or token."
}

2. Permission Errors
403 Forbidden: The authenticated user does not have permission to perform the requested operation.
Response Example:
{
  "error": "Forbidden",
  "message": "You do not have permission to access this resource."
}

3. Resource Not Found
404 Not Found: The requested resource could not be found.
Response Example:
{
  "error": "Not Found",
  "message": "The requested resource was not found."
}

4. Bad Request
400 Bad Request: The request was invalid or cannot be served. This often includes issues with the request parameters or payload.
Response Example:
{
  "error": "Bad Request",
  "message": "Invalid request parameters or body."
}

5. Conflict
409 Conflict: There is a conflict with the current state of the resource. This might occur, for instance, when trying to create a resource that already exists.
Response Example:
{
  "error": "Conflict",
  "message": "The resource already exists or is in an inconsistent state."
}

6. Internal Server Error
500 Internal Server Error: The server encountered an unexpected condition that prevented it from fulfilling the request.
Response Example:
{
  "error": "Internal Server Error",
  "message": "An unexpected error occurred on the server."
}

7. Service Unavailable
503 Service Unavailable: The server is currently unable to handle the request due to temporary overloading or maintenance.
Response Example:
{
  "error": "Service Unavailable",
  "message": "The server is currently unavailable. Please try again later."
}

8. Rate Limiting
429 Too Many Requests: The user has sent too many requests in a given amount of time.
Response Example:
{
  "error": "Too Many Requests",
  "message": "Rate limit exceeded. Please wait before making additional requests."
}

we have a use case to send an alert email to the third-party team that whenever they call the Saviynt Api and get the above errors.
If there is any table stores the errors in the Saviynt.

[stalluri]

@Mahendran 

There is no such table that stores the values you requested for.

Saviynt APIs will send response based on operation, you can't manipulate the response.

[rushikeshvartak]

You can use below query for your requirement

SELECT taskkey,
       provisioningcomments,
       CASE
         WHEN provisioningcomments LIKE '% 400 %' THEN
         'Bad Request: The request was invalid or cannot be served.'
         WHEN provisioningcomments LIKE '% 401 %' THEN
         'Unauthorized: Invalid API key or token.'
         WHEN provisioningcomments LIKE '% 403 %' THEN
         'Forbidden: You do not have permission to access this resource.'
         WHEN provisioningcomments LIKE '% 404 %' THEN
         'Not Found: The requested resource was not found.'
         WHEN provisioningcomments LIKE '% 409 %' THEN
         'Conflict: The resource already exists or is in an inconsistent state.'
         WHEN provisioningcomments LIKE '% 429 %' THEN
'Too Many Requests: Rate limit exceeded. Please wait before making additional requests.'
  WHEN provisioningcomments LIKE '% 500 %' THEN
  'Internal Server Error: An unexpected error occurred on the server.'
  WHEN provisioningcomments LIKE '% 503 %' THEN
  'Service Unavailable: The server is currently unavailable.'
  ELSE 'Unknown Error'
END AS error_description
FROM   arstasks
WHERE  ( provisioningcomments LIKE '% 400 %'
          OR provisioningcomments LIKE '% 401 %'
          OR provisioningcomments LIKE '% 403 %'
          OR provisioningcomments LIKE '% 404 %'
          OR provisioningcomments LIKE '% 409 %'
          OR provisioningcomments LIKE '% 429 %'
          OR provisioningcomments LIKE '% 500 %'
          OR provisioningcomments LIKE '% 503 %' );