{"action":"created","issue":{"url":"https://api.github.com/repos/alphagov/publishing-api/issues/321","repository_url":"https://api.github.com/repos/alphagov/publishing-api","labels_url":"https://api.github.com/repos/alphagov/publishing-api/issues/321/labels{/name}","comments_url":"https://api.github.com/repos/alphagov/publishing-api/issues/321/comments","events_url":"https://api.github.com/repos/alphagov/publishing-api/issues/321/events","html_url":"https://github.com/alphagov/publishing-api/pull/321","id":156236981,"number":321,"title":"Support new linkables endpoint","user":{"login":"elliotcm","id":109225,"avatar_url":"https://avatars.githubusercontent.com/u/109225?v=3","gravatar_id":"","url":"https://api.github.com/users/elliotcm","html_url":"https://github.com/elliotcm","followers_url":"https://api.github.com/users/elliotcm/followers","following_url":"https://api.github.com/users/elliotcm/following{/other_user}","gists_url":"https://api.github.com/users/elliotcm/gists{/gist_id}","starred_url":"https://api.github.com/users/elliotcm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/elliotcm/subscriptions","organizations_url":"https://api.github.com/users/elliotcm/orgs","repos_url":"https://api.github.com/users/elliotcm/repos","events_url":"https://api.github.com/users/elliotcm/events{/privacy}","received_events_url":"https://api.github.com/users/elliotcm/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2016-05-23T09:28:15Z","updated_at":"2016-05-23T12:03:21Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/alphagov/publishing-api/pulls/321","html_url":"https://github.com/alphagov/publishing-api/pull/321","diff_url":"https://github.com/alphagov/publishing-api/pull/321.diff","patch_url":"https://github.com/alphagov/publishing-api/pull/321.patch"},"body":"https://trello.com/c/3PfssMJ2/716-more-robust-linkables-endpoint\r\n\r\nBuilds a slightly denormalised table to support quick reads for the `/v2/linkables` endpoint.  This is the sort of approach I'd like to recommend for many of our read endpoints where possible, since even a single table approach would require dealing with grouping and sub-sorting to find e.g. the latest of a given content item with state fallbacks.\r\n\r\nThere's another branch to switch the endpoint over to reading from this table once everything is deployed and ready: https://github.com/alphagov/publishing-api/tree/activate-new-linkables-endpoint"},"comment":{"url":"https://api.github.com/repos/alphagov/publishing-api/issues/comments/220961470","html_url":"https://github.com/alphagov/publishing-api/pull/321#issuecomment-220961470","issue_url":"https://api.github.com/repos/alphagov/publishing-api/issues/321","id":220961470,"user":{"login":"elliotcm","id":109225,"avatar_url":"https://avatars.githubusercontent.com/u/109225?v=3","gravatar_id":"","url":"https://api.github.com/users/elliotcm","html_url":"https://github.com/elliotcm","followers_url":"https://api.github.com/users/elliotcm/followers","following_url":"https://api.github.com/users/elliotcm/following{/other_user}","gists_url":"https://api.github.com/users/elliotcm/gists{/gist_id}","starred_url":"https://api.github.com/users/elliotcm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/elliotcm/subscriptions","organizations_url":"https://api.github.com/users/elliotcm/orgs","repos_url":"https://api.github.com/users/elliotcm/repos","events_url":"https://api.github.com/users/elliotcm/events{/privacy}","received_events_url":"https://api.github.com/users/elliotcm/received_events","type":"User","site_admin":false},"created_at":"2016-05-23T12:03:21Z","updated_at":"2016-05-23T12:03:21Z","body":"I think we could do with having a team chat about how to handle all the things that happen during publish (and other actions) more cleanly rather than this one specifically.  As you say it's a very long list."}}
{"actor":{"display_login":"elliotcm"}}