All Tests  /  Test 4901

Test Id

Test 4901

Test Trace Id

704b011c-b8d7-4520-90ff-52481d9c19bb

Timestamp

Tue, 23 Jun 2026 21:36:03 GMT

Scenario

Send SQL injection payload in field [deviceId]: [') OR ('1'='1]

Expected Result

Should return 4XX

Result

Result Details

The following keywords were detected in the response which might suggest an error details leak: [forbidden]

Contract Path

/api/alerts/by-device/{deviceId}

Fuzzer

SqlInjectionInStringFields

Full Request Path

https://qa-api.puk3p.online/api/alerts/by-device/%27%29+OR+%28%271%27%3D%271?size=20&page=0

Http Method

get
Request Details
Payload
{
  "size": 20,
  "deviceId": "') OR ('1'='1",
  "page": 0
}
Request Details
Headers
[
  {
    "key": "Accept",
    "value": "application/json"
  },
  {
    "key": "Content-Type",
    "value": "application/json"
  },
  {
    "key": "User-Agent",
    "value": "cats/13.8.1-SNAPSHOT (Test 4901 - SqlInjectionInStringFields)"
  },
  {
    "key": "X-Cats-Trace-Id",
    "value": "704b011c-b8d7-4520-90ff-52481d9c19bb"
  }
]
Request Details
cURL
curl  -X GET \
     -H "Accept: application/json" \
-H "Content-Type: application/json" \
-H "User-Agent: cats/13.8.1-SNAPSHOT (Test 4901 - SqlInjectionInStringFields)" \
-H "X-Cats-Trace-Id: 704b011c-b8d7-4520-90ff-52481d9c19bb" \
 \
      \
      https://qa-api.puk3p.online/api/alerts/by-device/%27%29+OR+%28%271%27%3D%271?size=20&page=0
Response
{
  "responseCode": 403,
  "httpMethod": "GET",
  "responseTimeInMs": "132",
  "numberOfWordsInResponse": "1",
  "numberOfLinesInResponse": "1",
  "contentLengthInBytes": "132",
  "jsonBody": {
    "timestamp": "2026-06-23T21:36:03.240Z",
    "status": 403,
    "error": "Forbidden",
    "path": "/api/alerts/by-device/%27%29+OR+%28%271%27%3D%271"
  },
  "headers": [
    {
      "key": "cache-control",
      "value": "no-cache, no-store, max-age=0, must-revalidate"
    },
    {
      "key": "content-type",
      "value": "application/json"
    },
    {
      "key": "date",
      "value": "Tue, 23 Jun 2026 21:36:03 GMT"
    },
    {
      "key": "expires",
      "value": "0"
    },
    {
      "key": "pragma",
      "value": "no-cache"
    },
    {
      "key": "server",
      "value": "nginx/1.24.0 (Ubuntu)"
    },
    {
      "key": "strict-transport-security",
      "value": "max-age=31536000 ; includeSubDomains"
    },
    {
      "key": "vary",
      "value": "Origin"
    },
    {
      "key": "x-content-type-options",
      "value": "nosniff"
    },
    {
      "key": "x-frame-options",
      "value": "DENY"
    },
    {
      "key": "x-xss-protection",
      "value": "0"
    }
  ],
  "responseContentType": "application/json"
}
CATS Replay
cats replay Test4901