payload: {"action":"closed","number":44460,"pull_request":{"url":"https://api.github.com/repos/elastic/elasticsearch/pulls/44460","id":298226077,"node_id":"MDExOlB1bGxSZXF1ZXN0Mjk4MjI2MDc3","html_url":"https://github.com/elastic/elasticsearch/pull/44460","diff_url":"https://github.com/elastic/elasticsearch/pull/44460.diff","patch_url":"https://github.com/elastic/elasticsearch/pull/44460.patch","issue_url":"https://api.github.com/repos/elastic/elasticsearch/issues/44460","number":44460,"state":"closed","locked":false,"title":"Watcher reporting: add email warning if CSV attachment contains values that may be interperted as formulas","user":{"login":"jakelandis","id":976291,"node_id":"MDQ6VXNlcjk3NjI5MQ==","avatar_url":"https://avatars2.githubusercontent.com/u/976291?v=4","gravatar_id":"","url":"https://api.github.com/users/jakelandis","html_url":"https://github.com/jakelandis","followers_url":"https://api.github.com/users/jakelandis/followers","following_url":"https://api.github.com/users/jakelandis/following{/other_user}","gists_url":"https://api.github.com/users/jakelandis/gists{/gist_id}","starred_url":"https://api.github.com/users/jakelandis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jakelandis/subscriptions","organizations_url":"https://api.github.com/users/jakelandis/orgs","repos_url":"https://api.github.com/users/jakelandis/repos","events_url":"https://api.github.com/users/jakelandis/events{/privacy}","received_events_url":"https://api.github.com/users/jakelandis/received_events","type":"User","site_admin":false},"body":"This commit introduces a Warning message to the emails generated by Watcher's reporting action. This change complements Kibana's CSV formula notifications (see https://github.com/elastic/kibana/pull/37930). This is implemented by reading a header (kbn-csv-contains-formulas) provided by Kibana to notify to attach the Warning to the email. The wording of the warning is borrowed from Kibana's UI and may be overridden by a dynamic setting (`xpack.notification.reporting.warning.kbn-csv-contains-formulas.text`). This warning is enabled by default, but may be disabled via a dynamic setting `xpack.notification.reporting.warning.enabled`.\r\n\r\n_Note_ - the doc PR will need to be separate since the majority of this is documented included from the Kibana docs. \r\n\r\nKibana\r\n-------\r\n<img width=\"334\" alt=\"image\" src=\"https://user-images.githubusercontent.com/976291/61332992-477c6a80-a7eb-11e9-8f1f-3e2911e17c7e.png\">\r\n\r\n \r\n<img width=\"365\" alt=\"image\" src=\"https://user-images.githubusercontent.com/976291/61333007-5400c300-a7eb-11e9-9db1-ff907d85624e.png\">\r\n\r\n\r\nWatcher email - HTML\r\n-----\r\n<img width=\"1170\" alt=\"image\" src=\"https://user-images.githubusercontent.com/976291/61332916-169c3580-a7eb-11e9-82be-03aa11eea0c0.png\">\r\n\r\nWatcher email - Text\r\n-----\r\n<img width=\"1486\" alt=\"image\" src=\"https://user-images.githubusercontent.com/976291/61332936-261b7e80-a7eb-11e9-8962-582ad3aa44c5.png\">\r\n\r\n","created_at":"2019-07-16T21:54:00Z","updated_at":"2019-08-14T16:45:35Z","closed_at":"2019-08-14T16:45:35Z","merged_at":"2019-08-14T16:45:35Z","merge_commit_sha":"b28f0896c69d62eda948c2bf388595c75566eb22","assignee":null,"assignees":[],"requested_reviewers":[],"requested_teams":[],"labels":[{"id":912845062,"node_id":"MDU6TGFiZWw5MTI4NDUwNjI=","url":"https://api.github.com/repos/elastic/elasticsearch/labels/:Core/Features/Watcher","name":":Core/Features/Watcher","color":"0e8a16","default":false},{"id":23174,"node_id":"MDU6TGFiZWwyMzE3NA==","url":"https://api.github.com/repos/elastic/elasticsearch/labels/%3Eenhancement","name":">enhancement","color":"4a4ea8","default":false},{"id":1434538947,"node_id":"MDU6TGFiZWwxNDM0NTM4OTQ3","url":"https://api.github.com/repos/elastic/elasticsearch/labels/v7.4.0","name":"v7.4.0","color":"dddddd","default":false},{"id":1194435738,"node_id":"MDU6TGFiZWwxMTk0NDM1NzM4","url":"https://api.github.com/repos/elastic/elasticsearch/labels/v8.0.0","name":"v8.0.0","color":"dddddd","default":false}],"milestone":null,"commits_url":"https://api.github.com/repos/elastic/elasticsearch/pulls/44460/commits","review_comments_url":"https://api.github.com/repos/elastic/elasticsearch/pulls/44460/comments","review_comment_url":"https://api.github.com/repos/elastic/elasticsearch/pulls/comments{/number}","comments_url":"https://api.github.com/repos/elastic/elasticsearch/issues/44460/comments","statuses_url":"https://api.github.com/repos/elastic/elasticsearch/statuses/6261d538c2e4819c452c97193065cd1e2d82bad1","head":{"label":"jakelandis:watcher_reporting_email_warning","ref":"watcher_reporting_email_warning","sha":"6261d538c2e4819c452c97193065cd1e2d82bad1","user":{"login":"jakelandis","id":976291,"node_id":"MDQ6VXNlcjk3NjI5MQ==","avatar_url":"https://avatars2.githubusercontent.com/u/976291?v=4","gravatar_id":"","url":"https://api.github.com/users/jakelandis","html_url":"https://github.com/jakelandis","followers_url":"https://api.github.com/users/jakelandis/followers","following_url":"https://api.github.com/users/jakelandis/following{/other_user}","gists_url":"https://api.github.com/users/jakelandis/gists{/gist_id}","starred_url":"https://api.github.com/users/jakelandis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jakelandis/subscriptions","organizations_url":"https://api.github.com/users/jakelandis/orgs","repos_url":"https://api.github.com/users/jakelandis/repos","events_url":"https://api.github.com/users/jakelandis/events{/privacy}","received_events_url":"https://api.github.com/users/jakelandis/received_events","type":"User","site_admin":false},"repo":{"id":96800477,"node_id":"MDEwOlJlcG9zaXRvcnk5NjgwMDQ3Nw==","name":"elasticsearch","full_name":"jakelandis/elasticsearch","private":false,"owner":{"login":"jakelandis","id":976291,"node_id":"MDQ6VXNlcjk3NjI5MQ==","avatar_url":"https://avatars2.githubusercontent.com/u/976291?v=4","gravatar_id":"","url":"https://api.github.com/users/jakelandis","html_url":"https://github.com/jakelandis","followers_url":"https://api.github.com/users/jakelandis/followers","following_url":"https://api.github.com/users/jakelandis/following{/other_user}","gists_url":"https://api.github.com/users/jakelandis/gists{/gist_id}","starred_url":"https://api.github.com/users/jakelandis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jakelandis/subscriptions","organizations_url":"https://api.github.com/users/jakelandis/orgs","repos_url":"https://api.github.com/users/jakelandis/repos","events_url":"https://api.github.com/users/jakelandis/events{/privacy}","received_events_url":"https://api.github.com/users/jakelandis/received_events","type":"User","site_admin":false},"html_url":"https://github.com/jakelandis/elasticsearch","description":"Open Source, Distributed, RESTful Search Engine","fork":true,"url":"https://api.github.com/repos/jakelandis/elasticsearch","forks_url":"https://api.github.com/repos/jakelandis/elasticsearch/forks","keys_url":"https://api.github.com/repos/jakelandis/elasticsearch/keys{/key_id}","collaborators_url":"https://api.github.com/repos/jakelandis/elasticsearch/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/jakelandis/elasticsearch/teams","hooks_url":"https://api.github.com/repos/jakelandis/elasticsearch/hooks","issue_events_url":"https://api.github.com/repos/jakelandis/elasticsearch/issues/events{/number}","events_url":"https://api.github.com/repos/jakelandis/elasticsearch/events","assignees_url":"https://api.github.com/repos/jakelandis/elasticsearch/assignees{/user}","branches_url":"https://api.github.com/repos/jakelandis/elasticsearch/branches{/branch}","tags_url":"https://api.github.com/repos/jakelandis/elasticsearch/tags","blobs_url":"https://api.github.com/repos/jakelandis/elasticsearch/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/jakelandis/elasticsearch/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/jakelandis/elasticsearch/git/refs{/sha}","trees_url":"https://api.github.com/repos/jakelandis/elasticsearch/git/trees{/sha}","statuses_url":"https://api.github.com/repos/jakelandis/elasticsearch/statuses/{sha}","languages_url":"https://api.github.com/repos/jakelandis/elasticsearch/languages","stargazers_url":"https://api.github.com/repos/jakelandis/elasticsearch/stargazers","contributors_url":"https://api.github.com/repos/jakelandis/elasticsearch/contributors","subscribers_url":"https://api.github.com/repos/jakelandis/elasticsearch/subscribers","subscription_url":"https://api.github.com/repos/jakelandis/elasticsearch/subscription","commits_url":"https://api.github.com/repos/jakelandis/elasticsearch/commits{/sha}","git_commits_url":"https://api.github.com/repos/jakelandis/elasticsearch/git/commits{/sha}","comments_url":"https://api.github.com/repos/jakelandis/elasticsearch/comments{/number}","issue_comment_url":"https://api.github.com/repos/jakelandis/elasticsearch/issues/comments{/number}","contents_url":"https://api.github.com/repos/jakelandis/elasticsearch/contents/{+path}","compare_url":"https://api.github.com/repos/jakelandis/elasticsearch/compare/{base}...{head}","merges_url":"https://api.github.com/repos/jakelandis/elasticsearch/merges","archive_url":"https://api.github.com/repos/jakelandis/elasticsearch/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/jakelandis/elasticsearch/downloads","issues_url":"https://api.github.com/repos/jakelandis/elasticsearch/issues{/number}","pulls_url":"https://api.github.com/repos/jakelandis/elasticsearch/pulls{/number}","milestones_url":"https://api.github.com/repos/jakelandis/elasticsearch/milestones{/number}","notifications_url":"https://api.github.com/repos/jakelandis/elasticsearch/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/jakelandis/elasticsearch/labels{/name}","releases_url":"https://api.github.com/repos/jakelandis/elasticsearch/releases{/id}","deployments_url":"https://api.github.com/repos/jakelandis/elasticsearch/deployments","created_at":"2017-07-10T16:49:03Z","updated_at":"2019-07-08T17:08:43Z","pushed_at":"2019-08-14T00:48:06Z","git_url":"git://github.com/jakelandis/elasticsearch.git","ssh_url":"git@github.com:jakelandis/elasticsearch.git","clone_url":"https://github.com/jakelandis/elasticsearch.git","svn_url":"https://github.com/jakelandis/elasticsearch","homepage":"https://www.elastic.co/products/elasticsearch","size":587930,"stargazers_count":0,"watchers_count":0,"language":"Java","has_issues":false,"has_projects":true,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"disabled":false,"open_issues_count":0,"license":{"key":"other","name":"Other","spdx_id":"NOASSERTION","url":null,"node_id":"MDc6TGljZW5zZTA="},"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"elastic:master","ref":"master","sha":"20bc248054aa3cc9f5877e0b6be0224cc9237b4a","user":{"login":"elastic","id":6764390,"node_id":"MDEyOk9yZ2FuaXphdGlvbjY3NjQzOTA=","avatar_url":"https://avatars0.githubusercontent.com/u/6764390?v=4","gravatar_id":"","url":"https://api.github.com/users/elastic","html_url":"https://github.com/elastic","followers_url":"https://api.github.com/users/elastic/followers","following_url":"https://api.github.com/users/elastic/following{/other_user}","gists_url":"https://api.github.com/users/elastic/gists{/gist_id}","starred_url":"https://api.github.com/users/elastic/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/elastic/subscriptions","organizations_url":"https://api.github.com/users/elastic/orgs","repos_url":"https://api.github.com/users/elastic/repos","events_url":"https://api.github.com/users/elastic/events{/privacy}","received_events_url":"https://api.github.com/users/elastic/received_events","type":"Organization","site_admin":false},"repo":{"id":507775,"node_id":"MDEwOlJlcG9zaXRvcnk1MDc3NzU=","name":"elasticsearch","full_name":"elastic/elasticsearch","private":false,"owner":{"login":"elastic","id":6764390,"node_id":"MDEyOk9yZ2FuaXphdGlvbjY3NjQzOTA=","avatar_url":"https://avatars0.githubusercontent.com/u/6764390?v=4","gravatar_id":"","url":"https://api.github.com/users/elastic","html_url":"https://github.com/elastic","followers_url":"https://api.github.com/users/elastic/followers","following_url":"https://api.github.com/users/elastic/following{/other_user}","gists_url":"https://api.github.com/users/elastic/gists{/gist_id}","starred_url":"https://api.github.com/users/elastic/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/elastic/subscriptions","organizations_url":"https://api.github.com/users/elastic/orgs","repos_url":"https://api.github.com/users/elastic/repos","events_url":"https://api.github.com/users/elastic/events{/privacy}","received_events_url":"https://api.github.com/users/elastic/received_events","type":"Organization","site_admin":false},"html_url":"https://github.com/elastic/elasticsearch","description":"Open Source, Distributed, RESTful Search Engine","fork":false,"url":"https://api.github.com/repos/elastic/elasticsearch","forks_url":"https://api.github.com/repos/elastic/elasticsearch/forks","keys_url":"https://api.github.com/repos/elastic/elasticsearch/keys{/key_id}","collaborators_url":"https://api.github.com/repos/elastic/elasticsearch/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/elastic/elasticsearch/teams","hooks_url":"https://api.github.com/repos/elastic/elasticsearch/hooks","issue_events_url":"https://api.github.com/repos/elastic/elasticsearch/issues/events{/number}","events_url":"https://api.github.com/repos/elastic/elasticsearch/events","assignees_url":"https://api.github.com/repos/elastic/elasticsearch/assignees{/user}","branches_url":"https://api.github.com/repos/elastic/elasticsearch/branches{/branch}","tags_url":"https://api.github.com/repos/elastic/elasticsearch/tags","blobs_url":"https://api.github.com/repos/elastic/elasticsearch/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/elastic/elasticsearch/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/elastic/elasticsearch/git/refs{/sha}","trees_url":"https://api.github.com/repos/elastic/elasticsearch/git/trees{/sha}","statuses_url":"https://api.github.com/repos/elastic/elasticsearch/statuses/{sha}","languages_url":"https://api.github.com/repos/elastic/elasticsearch/languages","stargazers_url":"https://api.github.com/repos/elastic/elasticsearch/stargazers","contributors_url":"https://api.github.com/repos/elastic/elasticsearch/contributors","subscribers_url":"https://api.github.com/repos/elastic/elasticsearch/subscribers","subscription_url":"https://api.github.com/repos/elastic/elasticsearch/subscription","commits_url":"https://api.github.com/repos/elastic/elasticsearch/commits{/sha}","git_commits_url":"https://api.github.com/repos/elastic/elasticsearch/git/commits{/sha}","comments_url":"https://api.github.com/repos/elastic/elasticsearch/comments{/number}","issue_comment_url":"https://api.github.com/repos/elastic/elasticsearch/issues/comments{/number}","contents_url":"https://api.github.com/repos/elastic/elasticsearch/contents/{+path}","compare_url":"https://api.github.com/repos/elastic/elasticsearch/compare/{base}...{head}","merges_url":"https://api.github.com/repos/elastic/elasticsearch/merges","archive_url":"https://api.github.com/repos/elastic/elasticsearch/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/elastic/elasticsearch/downloads","issues_url":"https://api.github.com/repos/elastic/elasticsearch/issues{/number}","pulls_url":"https://api.github.com/repos/elastic/elasticsearch/pulls{/number}","milestones_url":"https://api.github.com/repos/elastic/elasticsearch/milestones{/number}","notifications_url":"https://api.github.com/repos/elastic/elasticsearch/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/elastic/elasticsearch/labels{/name}","releases_url":"https://api.github.com/repos/elastic/elasticsearch/releases{/id}","deployments_url":"https://api.github.com/repos/elastic/elasticsearch/deployments","created_at":"2010-02-08T13:20:56Z","updated_at":"2019-08-14T16:44:45Z","pushed_at":"2019-08-14T16:45:35Z","git_url":"git://github.com/elastic/elasticsearch.git","ssh_url":"git@github.com:elastic/elasticsearch.git","clone_url":"https://github.com/elastic/elasticsearch.git","svn_url":"https://github.com/elastic/elasticsearch","homepage":"https://www.elastic.co/products/elasticsearch","size":646943,"stargazers_count":43340,"watchers_count":43340,"language":"Java","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":14569,"mirror_url":null,"archived":false,"disabled":false,"open_issues_count":2132,"license":{"key":"other","name":"Other","spdx_id":"NOASSERTION","url":null,"node_id":"MDc6TGljZW5zZTA="},"forks":14569,"open_issues":2132,"watchers":43340,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/elastic/elasticsearch/pulls/44460"},"html":{"href":"https://github.com/elastic/elasticsearch/pull/44460"},"issue":{"href":"https://api.github.com/repos/elastic/elasticsearch/issues/44460"},"comments":{"href":"https://api.github.com/repos/elastic/elasticsearch/issues/44460/comments"},"review_comments":{"href":"https://api.github.com/repos/elastic/elasticsearch/pulls/44460/comments"},"review_comment":{"href":"https://api.github.com/repos/elastic/elasticsearch/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/elastic/elasticsearch/pulls/44460/commits"},"statuses":{"href":"https://api.github.com/repos/elastic/elasticsearch/statuses/6261d538c2e4819c452c97193065cd1e2d82bad1"}},"author_association":"CONTRIBUTOR","merged":true,"mergeable":null,"rebaseable":null,"mergeable_state":"unknown","merged_by":{"login":"jakelandis","id":976291,"node_id":"MDQ6VXNlcjk3NjI5MQ==","avatar_url":"https://avatars2.githubusercontent.com/u/976291?v=4","gravatar_id":"","url":"https://api.github.com/users/jakelandis","html_url":"https://github.com/jakelandis","followers_url":"https://api.github.com/users/jakelandis/followers","following_url":"https://api.github.com/users/jakelandis/following{/other_user}","gists_url":"https://api.github.com/users/jakelandis/gists{/gist_id}","starred_url":"https://api.github.com/users/jakelandis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jakelandis/subscriptions","organizations_url":"https://api.github.com/users/jakelandis/orgs","repos_url":"https://api.github.com/users/jakelandis/repos","events_url":"https://api.github.com/users/jakelandis/events{/privacy}","received_events_url":"https://api.github.com/users/jakelandis/received_events","type":"User","site_admin":false},"comments":2,"review_comments":10,"maintainer_can_modify":false,"commits":6,"additions":392,"deletions":32,"changed_files":7}}
other: {"actor":{"display_login":"jakelandis"}}