Add Get Web hook events API

What does this MR do and why?

Add get web hook events on group and project by REST API

Connected to #437188 (closed)

MR acceptance checklist

Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Screenshots or screen recordings

Screenshots are required for UI changes, and strongly recommended for all other merge requests.

Before	After

How to set up and validate locally

1. Create web hook event
2. Request to API

curl --request GET \
  --url http://gdk.test:3000/api/v4/<groups|projects>/<PARENT_ID>/hooks/<HOOK_ID>/events \
  --header 'PRIVATE-TOKEN: <TOKEN>' \

Example query plan from WebHooks::WebHookLogsFinder

Query plans

• no filter
• server failure filter

Example of use:

hook = WebHook.first
user = User.first

WebHooks::WebHookLogsFinder.new(hook, user, hook.parent, { status: ['client_failure', 200, 500] }).execute

Example of raw SQL (8075115 is a webhook ID owned by gitlab-org/gitlab):

SELECT "web_hook_logs".*
FROM   "web_hook_logs"
WHERE  "web_hook_logs"."web_hook_id" = 8075115
       AND ( "web_hook_logs"."response_status" BETWEEN '400' AND '499'
              OR "web_hook_logs"."response_status" = '200'
              OR "web_hook_logs"."response_status" = '500' ) 

Example of query plan:

# In postgres.ai, first create the index being added in this MR:
exec CREATE INDEX web_hook_logs_on_web_hook_id_and_response_status ON ONLY web_hook_logs USING btree (web_hook_id, response_status);

https://console.postgres.ai/gitlab/gitlab-production-main/sessions/28697/commands/89415

 Append  (cost=0.57..46247.79 rows=12050 width=1382) (actual time=11.559..111781.689 rows=77803 loops=1)
   Buffers: shared hit=27 read=78197 dirtied=1642
   I/O Timings: read=110568.641 write=0.000
   ->  Index Scan using web_hook_logs_202402_web_hook_id_created_at_idx on gitlab_partitions_dynamic.web_hook_logs_202402 web_hook_logs_1  (cost=0.57..37136.24 rows=9470 width=1389) (actual time=11.557..30403.693 rows=22217 loops=1)
         Index Cond: (web_hook_logs_1.web_hook_id = 8075115)
         Filter: ((((web_hook_logs_1.response_status)::text >= '400'::text) AND ((web_hook_logs_1.response_status)::text <= '499'::text)) OR ((web_hook_logs_1.response_status)::text = '200'::text) OR ((web_hook_logs_1.response_status)::text = '500'::text))
         Rows Removed by Filter: 4
         Buffers: shared hit=5 read=22318 dirtied=6
         I/O Timings: read=30217.506 write=0.000
   ->  Index Scan using web_hook_logs_202403_web_hook_id_created_at_idx on gitlab_partitions_dynamic.web_hook_logs_202403 web_hook_logs_2  (cost=0.57..2882.54 rows=741 width=1369) (actual time=8.838..21558.973 rows=15551 loops=1)
         Index Cond: (web_hook_logs_2.web_hook_id = 8075115)
         Filter: ((((web_hook_logs_2.response_status)::text >= '400'::text) AND ((web_hook_logs_2.response_status)::text <= '499'::text)) OR ((web_hook_logs_2.response_status)::text = '200'::text) OR ((web_hook_logs_2.response_status)::text = '500'::text))
         Rows Removed by Filter: 1
         Buffers: shared hit=10 read=15622 dirtied=15
         I/O Timings: read=21425.277 write=0.000
   ->  Index Scan using web_hook_logs_202404_web_hook_id_created_at_idx on gitlab_partitions_dynamic.web_hook_logs_202404 web_hook_logs_3  (cost=0.57..3141.61 rows=859 width=1368) (actual time=11.327..29921.386 rows=19370 loops=1)
         Index Cond: (web_hook_logs_3.web_hook_id = 8075115)
         Filter: ((((web_hook_logs_3.response_status)::text >= '400'::text) AND ((web_hook_logs_3.response_status)::text <= '499'::text)) OR ((web_hook_logs_3.response_status)::text = '200'::text) OR ((web_hook_logs_3.response_status)::text = '500'::text))
         Rows Removed by Filter: 6
         Buffers: shared hit=3 read=19486 dirtied=20
         I/O Timings: read=29730.146 write=0.000
   ->  Index Scan using web_hook_logs_202405_web_hook_id_created_at_idx on gitlab_partitions_dynamic.web_hook_logs_202405 web_hook_logs_4  (cost=0.57..3027.14 rows=974 width=1347) (actual time=9.138..29854.263 rows=20665 loops=1)
         Index Cond: (web_hook_logs_4.web_hook_id = 8075115)
         Filter: ((((web_hook_logs_4.response_status)::text >= '400'::text) AND ((web_hook_logs_4.response_status)::text <= '499'::text)) OR ((web_hook_logs_4.response_status)::text = '200'::text) OR ((web_hook_logs_4.response_status)::text = '500'::text))
         Rows Removed by Filter: 17
         Buffers: shared hit=9 read=20771 dirtied=1601
         I/O Timings: read=29195.713 write=0.000
   ->  Seq Scan on gitlab_partitions_dynamic.web_hook_logs_202406 web_hook_logs_5  (cost=0.00..0.00 rows=1 width=324) (actual time=0.015..0.015 rows=0 loops=1)
         Filter: ((web_hook_logs_5.web_hook_id = 8075115) AND ((((web_hook_logs_5.response_status)::text >= '400'::text) AND ((web_hook_logs_5.response_status)::text <= '499'::text)) OR ((web_hook_logs_5.response_status)::text = '200'::text) OR ((web_hook_logs_5.response_status)::text = '500'::text)))
         Rows Removed by Filter: 0
         I/O Timings: read=0.000 write=0.000
   ->  Seq Scan on gitlab_partitions_dynamic.web_hook_logs_202407 web_hook_logs_6  (cost=0.00..0.00 rows=1 width=324) (actual time=0.008..0.008 rows=0 loops=1)
         Filter: ((web_hook_logs_6.web_hook_id = 8075115) AND ((((web_hook_logs_6.response_status)::text >= '400'::text) AND ((web_hook_logs_6.response_status)::text <= '499'::text)) OR ((web_hook_logs_6.response_status)::text = '200'::text) OR ((web_hook_logs_6.response_status)::text = '500'::text)))
         Rows Removed by Filter: 0
         I/O Timings: read=0.000 write=0.000
   ->  Seq Scan on gitlab_partitions_dynamic.web_hook_logs_202408 web_hook_logs_7  (cost=0.00..0.00 rows=1 width=324) (actual time=0.007..0.007 rows=0 loops=1)
         Filter: ((web_hook_logs_7.web_hook_id = 8075115) AND ((((web_hook_logs_7.response_status)::text >= '400'::text) AND ((web_hook_logs_7.response_status)::text <= '499'::text)) OR ((web_hook_logs_7.response_status)::text = '200'::text) OR ((web_hook_logs_7.response_status)::text = '500'::text)))
         Rows Removed by Filter: 0
         I/O Timings: read=0.000 write=0.000
   ->  Seq Scan on gitlab_partitions_dynamic.web_hook_logs_202409 web_hook_logs_8  (cost=0.00..0.00 rows=1 width=324) (actual time=0.006..0.006 rows=0 loops=1)
         Filter: ((web_hook_logs_8.web_hook_id = 8075115) AND ((((web_hook_logs_8.response_status)::text >= '400'::text) AND ((web_hook_logs_8.response_status)::text <= '499'::text)) OR ((web_hook_logs_8.response_status)::text = '200'::text) OR ((web_hook_logs_8.response_status)::text = '500'::text)))
         Rows Removed by Filter: 0
         I/O Timings: read=0.000 write=0.000
   ->  Seq Scan on gitlab_partitions_dynamic.web_hook_logs_202410 web_hook_logs_9  (cost=0.00..0.00 rows=1 width=324) (actual time=0.007..0.007 rows=0 loops=1)
         Filter: ((web_hook_logs_9.web_hook_id = 8075115) AND ((((web_hook_logs_9.response_status)::text >= '400'::text) AND ((web_hook_logs_9.response_status)::text <= '499'::text)) OR ((web_hook_logs_9.response_status)::text = '200'::text) OR ((web_hook_logs_9.response_status)::text = '500'::text)))
         Rows Removed by Filter: 0
         I/O Timings: read=0.000 write=0.000
   ->  Seq Scan on gitlab_partitions_dynamic.web_hook_logs_202411 web_hook_logs_10  (cost=0.00..0.00 rows=1 width=324) (actual time=0.012..0.012 rows=0 loops=1)
         Filter: ((web_hook_logs_10.web_hook_id = 8075115) AND ((((web_hook_logs_10.response_status)::text >= '400'::text) AND ((web_hook_logs_10.response_status)::text <= '499'::text)) OR ((web_hook_logs_10.response_status)::text = '200'::text) OR ((web_hook_logs_10.response_status)::text = '500'::text)))
         Rows Removed by Filter: 0
         I/O Timings: read=0.000 write=0.000

doc/api/groups.md

@@ -1710,6 +1710,10 @@ DETAILS:
 Also called Group hooks and Webhooks.
 These are different from [system hooks](system_hooks.md) that are system wide and [project hooks](projects.md#hooks) that are limited to one project.
 
+Prerequisites:
+
+- You must be an Administrator or have the Owner role for the group.
+
 ### List group hooks
 
 Get a list of group hooks
@@ -1774,6 +1778,271 @@ GET /groups/:id/hooks/:hook_id
 }
 ```
 
+### Get group hook events
+
+> - [Introduced](https://gitlab.com/gitlab-org/gitlab/-/merge_requests/151048) in GitLab 17.2.
+
+Get a list of events for a specific group hook in the past 7 days from start date.
+
+```plaintext
+GET /groups/:id/hooks/:hook_id/events
+```
+
+| Attribute | Type              | Required | Description                                                                                                                                                                                 |
+|-----------|-------------------|----------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
+| `id`      | integer/string | yes      | The ID or [URL-encoded path of the group](rest/index.md#namespaced-path-encoding).                                                                                                          |
+| `hook_id` | integer           | Yes      | The ID of a project hook.                                                                                                                                                                   |
+| `status` | integer or string | No | The response status code of the events, for example: `200` or `500`. You can search by status category: `successful` (200-299), `client_failure` (400-499), and `server_failure` (500-599). |
+| `page`             | integer | No | Page to retrieve. Defaults to `1`.                                                                                                                                                          |
+| `per_page`         | integer | No | Number of records to return per page. Defaults to `20`.                                                                                                                                     |
+
+```json
+[
+  {
+    "id": 1,
+    "url": "https://example.net/",
+    "trigger": "push_hooks",
+    "request_headers": {
+      "Content-Type": "application/json",
+      "User-Agent": "GitLab/17.1.0-pre",
+      "X-Gitlab-Event": "Push Hook",
+      "X-Gitlab-Webhook-UUID": "3c5c0404-c866-44bc-a5f6-452bb1bfc76e",
+      "X-Gitlab-Instance": "https://gitlab.example.com",
+      "X-Gitlab-Event-UUID": "9cebe914-4827-408f-b014-cfa23a47a35f",
+      "X-Gitlab-Token": "[REDACTED]"
+    },
+    "request_data": {
+      "object_kind": "push",
+      "event_name": "push"
+    }
+      "after": "f15b32277d2c55c6c595845a87109b09c913c556",
+      "ref": "refs/heads/master",
+      "ref_protected": true,
+      "checkout_sha": "f15b32277d2c55c6c595845a87109b09c913c556",
+      "message": null,
+      "user_id": 1,
+      "user_name": "Administrator",
+      "user_username": "root",
+      "user_email": null,
+      "user_avatar": "https://www.gravatar.com/avatar/13efe0d4559475ba84ecc802061febbdea6e224fcbffd7ec7da9cd431845299c?s=80&d=identicon",
+      "project_id": 7,
+      "project": {
+        "id": 7,
+        "name": "Flight",
+        "description": "Incidunt ea ab officia a veniam.",
+        "web_url": "https://gitlab.example.com/flightjs/Flight",
+        "avatar_url": null,
+        "git_ssh_url": "ssh://git@gitlab.example.com:2222/flightjs/Flight.git",
+        "git_http_url": "https://gitlab.example.com/flightjs/Flight.git",
+        "namespace": "Flightjs",
+        "visibility_level": 10,
+        "path_with_namespace": "flightjs/Flight",
+        "default_branch": "master",
+        "ci_config_path": null,
+        "homepage": "https://gitlab.example.com/flightjs/Flight",
+        "url": "ssh://git@gitlab.example.com:2222/flightjs/Flight.git",
+        "ssh_url": "ssh://git@gitlab.example.com:2222/flightjs/Flight.git",
+        "http_url": "https://gitlab.example.com/flightjs/Flight.git"
+      },
+      "commits": [
+        {
+          "id": "f15b32277d2c55c6c595845a87109b09c913c556",
+          "message": "v1.5.2\n",
+          "title": "v1.5.2",
+          "timestamp": "2017-06-19T14:39:53-07:00",
+          "url": "https://gitlab.example.com/flightjs/Flight/-/commit/f15b32277d2c55c6c595845a87109b09c913c556",
+          "author": {
+            "name": "Andrew Lunny",
+            "email": "[REDACTED]"
+          },
+          "added": [],
+          "modified": [
+            "package.json"
+          ],
+          "removed": []
+        },
+        {
+          "id": "8749d49930866a4871fa086adbd7d2057fcc3ebb",
+          "message": "Merge pull request #378 from flightjs/alunny/publish_lib\n\npublish lib and index to npm",
+          "title": "Merge pull request #378 from flightjs/alunny/publish_lib",
+          "timestamp": "2017-06-16T10:26:39-07:00",
+          "url": "https://gitlab.example.com/flightjs/Flight/-/commit/8749d49930866a4871fa086adbd7d2057fcc3ebb",
+          "author": {
+            "name": "angus croll",
+            "email": "[REDACTED]"
+          },
+          "added": [],
+          "modified": [
+            "package.json"
+          ],
+          "removed": []
+        },
+        {
+          "id": "468abc807a2b2572f43e72c743b76cee6db24025",
+          "message": "publish lib and index to npm\n",
+          "title": "publish lib and index to npm",
+          "timestamp": "2017-06-16T10:23:04-07:00",
+          "url": "https://gitlab.example.com/flightjs/Flight/-/commit/468abc807a2b2572f43e72c743b76cee6db24025",
+          "author": {
+            "name": "Andrew Lunny",
+            "email": "[REDACTED]"
+          },
+          "added": [],
+          "modified": [
+            "package.json"
+          ],
+          "removed": []
+        }
+      ],
+      "total_commits_count": 3,
+      "push_options": {},
+      "repository": {
+        "name": "Flight",
+        "url": "ssh://git@gitlab.example.com:2222/flightjs/Flight.git",
+        "description": "Incidunt ea ab officia a veniam.",
+        "homepage": "https://gitlab.example.com/flightjs/Flight",
+        "git_http_url": "https://gitlab.example.com/flightjs/Flight.git",
+        "git_ssh_url": "ssh://git@gitlab.example.com:2222/flightjs/Flight.git",
+        "visibility_level": 10
+      }
+    },
+    "response_headers": {
+      "Date": "Sun, 26 May 2024 03:03:17 GMT",
+      "Content-Type": "application/json; charset=utf-8",
+      "Content-Length": "16",
+      "Connection": "close",
+      "X-Powered-By": "Express",
+      "Access-Control-Allow-Origin": "*",
+      "X-Pd-Status": "sent to primary"
+    },
+    "response_body": "{\"success\":true}",
+    "execution_duration": 1.0906479999999874,
+    "response_status": "200"
+  },
+  {
+    "id": 2,
+    "url": "https://example.net/",
+    "trigger": "push_hooks",
+    "request_headers": {
+      "Content-Type": "application/json",
+      "User-Agent": "GitLab/17.1.0-pre",
+      "X-Gitlab-Event": "Push Hook",
+      "X-Gitlab-Webhook-UUID": "a753eedb-1d72-4549-9ca7-eac8ea8e50dd",
+      "X-Gitlab-Instance": "https://gitlab.example.com:3000",
+      "X-Gitlab-Event-UUID": "842d7c3e-3114-4396-8a95-66c084d53cb1",
+      "X-Gitlab-Token": "[REDACTED]"
+    },
+    "request_data": {
+      "object_kind": "push",
+      "event_name": "push",
+      "before": "468abc807a2b2572f43e72c743b76cee6db24025",
+      "after": "f15b32277d2c55c6c595845a87109b09c913c556",
+      "ref": "refs/heads/master",
+      "ref_protected": true,
+      "checkout_sha": "f15b32277d2c55c6c595845a87109b09c913c556",
+      "message": null,
+      "user_id": 1,
+      "user_name": "Administrator",
+      "user_username": "root",
+      "user_email": null,
+      "user_avatar": "https://www.gravatar.com/avatar/13efe0d4559475ba84ecc802061febbdea6e224fcbffd7ec7da9cd431845299c?s=80&d=identicon",
+      "project_id": 7,
+      "project": {
+        "id": 7,
+        "name": "Flight",
+        "description": "Incidunt ea ab officia a veniam.",
+        "web_url": "https://gitlab.example.com/flightjs/Flight",
+        "avatar_url": null,
+        "git_ssh_url": "ssh://git@gitlab.example.com:2222/flightjs/Flight.git",
+        "git_http_url": "https://gitlab.example.com/flightjs/Flight.git",
+        "namespace": "Flightjs",
+        "visibility_level": 10,
+        "path_with_namespace": "flightjs/Flight",
+        "default_branch": "master",
+        "ci_config_path": null,
+        "homepage": "https://gitlab.example.com/flightjs/Flight",
+        "url": "ssh://git@gitlab.example.com:2222/flightjs/Flight.git",
+        "ssh_url": "ssh://git@gitlab.example.com:2222/flightjs/Flight.git",
+        "http_url": "https://gitlab.example.com/flightjs/Flight.git"
+      },
+      "commits": [
+        {
+          "id": "f15b32277d2c55c6c595845a87109b09c913c556",
+          "message": "v1.5.2\n",
+          "title": "v1.5.2",
+          "timestamp": "2017-06-19T14:39:53-07:00",
+          "url": "https://gitlab.example.com/flightjs/Flight/-/commit/f15b32277d2c55c6c595845a87109b09c913c556",
+          "author": {
+            "name": "Andrew Lunny",
+            "email": "[REDACTED]"
+          },
+          "added": [],
+          "modified": [
+            "package.json"
+          ],
+          "removed": []
+        },
+        {
+          "id": "8749d49930866a4871fa086adbd7d2057fcc3ebb",
+          "message": "Merge pull request #378 from flightjs/alunny/publish_lib\n\npublish lib and index to npm",
+          "title": "Merge pull request #378 from flightjs/alunny/publish_lib",
+          "timestamp": "2017-06-16T10:26:39-07:00",
+          "url": "https://gitlab.example.com/flightjs/Flight/-/commit/8749d49930866a4871fa086adbd7d2057fcc3ebb",
+          "author": {
+            "name": "angus croll",
+            "email": "[REDACTED]"
+          },
+          "added": [],
+          "modified": [
+            "package.json"
+          ],
+          "removed": []
+        },
+        {
+          "id": "468abc807a2b2572f43e72c743b76cee6db24025",
+          "message": "publish lib and index to npm\n",
+          "title": "publish lib and index to npm",
+          "timestamp": "2017-06-16T10:23:04-07:00",
+          "url": "https://gitlab.example.com/flightjs/Flight/-/commit/468abc807a2b2572f43e72c743b76cee6db24025",
+          "author": {
+            "name": "Andrew Lunny",
+            "email": "[REDACTED]"
+          },
+          "added": [],
+          "modified": [
+            "package.json"
+          ],
+          "removed": []
+        }
+      ],
+      "total_commits_count": 3,
+      "push_options": {},
+      "repository": {
+        "name": "Flight",
+        "url": "ssh://git@gitlab.example.com:2222/flightjs/Flight.git",
+        "description": "Incidunt ea ab officia a veniam.",
+        "homepage": "https://gitlab.example.com/flightjs/Flight",
+        "git_http_url": "https://gitlab.example.com/flightjs/Flight.git",
+        "git_ssh_url": "ssh://git@gitlab.example.com:2222/flightjs/Flight.git",
+        "visibility_level": 10
+      }
+    },
+    "response_headers": {
+      "Date": "Sun, 26 May 2024 03:03:19 GMT",
+      "Content-Type": "application/json; charset=utf-8",
+      "Content-Length": "16",
+      "Connection": "close",
+      "X-Powered-By": "Express",
+      "Access-Control-Allow-Origin": "*",
+      "X-Pd-Status": "sent to primary"
+    },
+    "response_body": "{\"success\":true}",
+    "execution_duration": 1.0716120000000728,
+    "response_status": "200"
+  }
+]
+```
+
 ### Add group hook
 
 Adds a hook to a specified group.