Hi,
I am trying to exclude many Keys in the JSON field. The data is actually of a Github payload. As the contributors are bit high, the details it carries is also high. For example, the total fields/kvp are around 720 but I want to shrink it it 300.
I know the field types but now sure how to mention it one by one and also is a tedious process.
I have mentioned below the JSON file. As it has arrays of data. I might have to need to mention the keys in the same format. For example :- array1[key1], array1[key1[key2]],
Almost all the arrays inside the JSON has data key name as "event_url", is there any i can mention a place where if there is a key name as "event_url" . it needs to be excluded. If you see the JSON has multiple entries with the Key value "event_url"
JSON File.
{
"forks": 2,
"open_issues": 2,
"watchers": 0,
"default_branch": "master"
}
},
"_links": {
"self": {
"href": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/pulls/194"
},
"html": {
"href": "https://Startup_GitLab/StartupORG/REPO_Name/pull/194"
},
"issue": {
"href": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/issues/194"
},
"comments": {
"href": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/issues/194/comments"
},
"review_comments": {
"href": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/pulls/194/comments"
},
"review_comment": {
"href": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/pulls/comments{/number}"
},
"commits": {
"href": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/pulls/194/commits"
},
"statuses": {
"href": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/statuses/cc7e20be3af91ed318cbe4e6e06da94d34ba085b"
}
},
"author_association": "CONTRIBUTOR",
"draft": false,
"merged": false,
"mergeable": null,
"rebaseable": null,
"mergeable_state": "unknown",
"merged_by": null,
"comments": 0,
"review_comments": 0,
"maintainer_can_modify": false,
"commits": 1,
"additions": 932,
"deletions": 172,
"changed_files": 24
},
"requested_reviewer": {
"login": "Ernest_Young",
"id": 3786,
"node_id": "MDQ6VXNlcjM3ODY=",
"avatar_url": "https://avatars.Startup_GitLab/u/3786?",
"gravatar_id": "",
"url": "https://Startup_GitLab/api/v3/users/Ernest_Young",
"html_url": "https://Startup_GitLab/Ernest_Young",
"followers_url": "https://Startup_GitLab/api/v3/users/Ernest_Young/followers",
"following_url": "https://Startup_GitLab/api/v3/users/Ernest_Young/following{/other_user}",
"gists_url": "https://Startup_GitLab/api/v3/users/Ernest_Young/gists{/gist_id}",
"starred_url": "https://Startup_GitLab/api/v3/users/Ernest_Young/starred{/owner}{/repo}",
"subscriptions_url": "https://Startup_GitLab/api/v3/users/Ernest_Young/subscriptions",
"organizations_url": "https://Startup_GitLab/api/v3/users/Ernest_Young/orgs",
"repos_url": "https://Startup_GitLab/api/v3/users/Ernest_Young/repos",
"events_url": "https://Startup_GitLab/api/v3/users/Ernest_Young/events{/privacy}",
"received_events_url": "https://Startup_GitLab/api/v3/users/Ernest_Young/received_events",
"type": "User",
"site_admin": false,
"ldap_dn": "CN=young\\, eric,OU=Engineering,OU=MA Hopkinton,OU=US Users,DC=corp,DC=Company_Name,DC=com"
},
"repository": {
"id": 16234,
"node_id": "MDEwOlJlcG9zaXRvcnkxNjIzNA==",
"name": "REPO_Name",
"full_name": "StartupORG/REPO_Name",
"private": true,
"owner": {
"login": "StartupORG",
"id": 2356,
"node_id": "MDEyOk9yZ2FuaXphdGlvbjIzNTY=",
"avatar_url": "https://avatars.Startup_GitLab/u/2356?",
"gravatar_id": "",
"url": "https://Startup_GitLab/api/v3/users/StartupORG",
"html_url": "https://Startup_GitLab/StartupORG",
"followers_url": "https://Startup_GitLab/api/v3/users/StartupORG/followers",
"following_url": "https://Startup_GitLab/api/v3/users/StartupORG/following{/other_user}",
"gists_url": "https://Startup_GitLab/api/v3/users/StartupORG/gists{/gist_id}",
"starred_url": "https://Startup_GitLab/api/v3/users/StartupORG/starred{/owner}{/repo}",
"subscriptions_url": "https://Startup_GitLab/api/v3/users/StartupORG/subscriptions",
"organizations_url": "https://Startup_GitLab/api/v3/users/StartupORG/orgs",
"repos_url": "https://Startup_GitLab/api/v3/users/StartupORG/repos",
"events_url": "https://Startup_GitLab/api/v3/users/StartupORG/events{/privacy}",
"received_events_url": "https://Startup_GitLab/api/v3/users/StartupORG/received_events",
"type": "Organization",
"site_admin": false
},
"html_url": "https://Startup_GitLab/StartupORG/REPO_Name",
"description": "Repository for CSI Plugin development project",
"fork": false,
"url": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name",
"forks_url": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/forks",
"keys_url": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/keys{/key_id}",
"collaborators_url": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/collaborators{/collaborator}",
"teams_url": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/teams",
"hooks_url": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/hooks",
"issue_events_url": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/issues/events{/number}",
"events_url": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/events",
"assignees_url": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/assignees{/user}",
"branches_url": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/branches{/branch}",
"tags_url": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/tags",
"blobs_url": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/git/blobs{/sha}",
"git_tags_url": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/git/tags{/sha}",
"git_refs_url": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/git/refs{/sha}",
"trees_url": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/git/trees{/sha}",
"statuses_url": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/statuses/{sha}",
"languages_url": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/languages",
"stargazers_url": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/stargazers",
"contributors_url": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/contributors",
"subscribers_url": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/subscribers",
"subscription_url": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/subscription",
"commits_url": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/commits{/sha}",
"git_commits_url": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/git/commits{/sha}",
"comments_url": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/comments{/number}",
"issue_comment_url": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/issues/comments{/number}",
"contents_url": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/contents/{+path}",
"compare_url": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/compare/{base}...{head}",
"merges_url": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/merges",
"archive_url": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/{archive_format}{/ref}",
"downloads_url": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/downloads",
"issues_url": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/issues{/number}",
"pulls_url": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/pulls{/number}",
"milestones_url": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/milestones{/number}",
"notifications_url": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/notifications{?since,all,participating}",
"labels_url": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/labels{/name}",
"releases_url": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/releases{/id}",
"deployments_url": "https://Startup_GitLab/api/v3/repos/StartupORG/REPO_Name/deployments",
"created_at": "2019-03-25T03:52:51Z",
"updated_at": "2020-06-25T10:37:13Z",
"pushed_at": "2020-06-25T13:10:16Z",
"git_url": "git://Startup_GitLab/StartupORG/REPO_Name.git",
"ssh_url": "git@eos2git.cec.lab.Company_Name.com:StartupORG/REPO_Name.git",
"clone_url": "https://Startup_GitLab/StartupORG/REPO_Name.git",
"svn_url": "https://Startup_GitLab/StartupORG/REPO_Name",
"homepage": null,
"size": 1770,
"stargazers_count": 0,
"watchers_count": 0,
"language": "Go",
"has_issues": true,
"has_projects": true,
"has_downloads": true,
"has_wiki": true,
"has_pages": false,
"forks_count": 2,
"mirror_url": null,
"archived": false,
"disabled": false,
"open_issues_count": 2,
"license": {
"key": "apache-2.0",
"name": "Apache License 2.0",
"spdx_id": "Apache-2.0",
"url": "https://Startup_GitLab/api/v3/licenses/apache-2.0",
"node_id": "MDc6TGljZW5zZTI="
},
"forks": 2,
"open_issues": 2,
"watchers": 0,
"default_branch": "master"
},
"organization": {
"login": "StartupORG",
"id": 2356,
"node_id": "MDEyOk9yZ2FuaXphdGlvbjIzNTY=",
"url": "https://Startup_GitLab/api/v3/orgs/StartupORG",
"repos_url": "https://Startup_GitLab/api/v3/orgs/StartupORG/repos",
"events_url": "https://Startup_GitLab/api/v3/orgs/StartupORG/events",
"hooks_url": "https://Startup_GitLab/api/v3/orgs/StartupORG/hooks",
"issues_url": "https://Startup_GitLab/api/v3/orgs/StartupORG/issues",
"members_url": "https://Startup_GitLab/api/v3/orgs/StartupORG/members{/member}",
"public_members_url": "https://Startup_GitLab/api/v3/orgs/StartupORG/public_members{/member}",
"avatar_url": "https://avatars.Startup_GitLab/u/2356?",
"description": null
},
"enterprise": {
"id": 1,
"slug": "Company_Name-eos2",
"name": "Company_Name EOS2",
"node_id": "MDEwOkVudGVycHJpc2Ux",
"avatar_url": "https://avatars.Startup_GitLab/b/1?",
"description": null,
"website_url": null,
"html_url": "https://Startup_GitLab/enterprises/Company_Name-eos2",
"created_at": "2019-04-28T18:39:22Z",
"updated_at": "2019-04-28T18:39:22Z"
},
"sender": {
"login": "Prakash-Dubey",
"id": 6384,
"node_id": "MDQ6VXNlcjYzODQ=",
"avatar_url": "https://avatars.Startup_GitLab/u/6384?",
"gravatar_id": "",
"url": "https://Startup_GitLab/api/v3/users/Prakash-Dubey",
"html_url": "https://Startup_GitLab/Prakash-Dubey",
"followers_url": "https://Startup_GitLab/api/v3/users/Prakash-Dubey/followers",
"following_url": "https://Startup_GitLab/api/v3/users/Prakash-Dubey/following{/other_user}",
"gists_url": "https://Startup_GitLab/api/v3/users/Prakash-Dubey/gists{/gist_id}",
"starred_url": "https://Startup_GitLab/api/v3/users/Prakash-Dubey/starred{/owner}{/repo}",
"subscriptions_url": "https://Startup_GitLab/api/v3/users/Prakash-Dubey/subscriptions",
"organizations_url": "https://Startup_GitLab/api/v3/users/Prakash-Dubey/orgs",
"repos_url": "https://Startup_GitLab/api/v3/users/Prakash-Dubey/repos",
"events_url": "https://Startup_GitLab/api/v3/users/Prakash-Dubey/events{/privacy}",
"received_events_url": "https://Startup_GitLab/api/v3/users/Prakash-Dubey/received_events",
"type": "User",
"site_admin": false,
"ldap_dn": "CN=Prakash_Dubey,OU=AsiaPac,OU=_Dell,OU=International Users,DC=corp,DC=Company_Name,DC=com"
}
}
My Current HTTP_Filter is below.
input {
http {
host => "ELK_Host_IP"
port => "8080"
type => "json"
}
}
filter {
json {
source => "message"
}
mutate {
remove_field => [ "events_url"]
}
}