{"action":"created","issue":{"url":"https://api.github.com/repos/caciviclab/disclosure-backend/issues/247","repository_url":"https://api.github.com/repos/caciviclab/disclosure-backend","labels_url":"https://api.github.com/repos/caciviclab/disclosure-backend/issues/247/labels{/name}","comments_url":"https://api.github.com/repos/caciviclab/disclosure-backend/issues/247/comments","events_url":"https://api.github.com/repos/caciviclab/disclosure-backend/issues/247/events","html_url":"https://github.com/caciviclab/disclosure-backend/issues/247","id":158056655,"number":247,"title":"KeyError 'filingStartDate'","user":{"login":"adborden","id":509703,"avatar_url":"https://avatars.githubusercontent.com/u/509703?v=3","gravatar_id":"","url":"https://api.github.com/users/adborden","html_url":"https://github.com/adborden","followers_url":"https://api.github.com/users/adborden/followers","following_url":"https://api.github.com/users/adborden/following{/other_user}","gists_url":"https://api.github.com/users/adborden/gists{/gist_id}","starred_url":"https://api.github.com/users/adborden/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/adborden/subscriptions","organizations_url":"https://api.github.com/users/adborden/orgs","repos_url":"https://api.github.com/users/adborden/repos","events_url":"https://api.github.com/users/adborden/events{/privacy}","received_events_url":"https://api.github.com/users/adborden/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/caciviclab/disclosure-backend/labels/MVP","name":"MVP","color":"CC0000"}],"state":"closed","locked":false,"assignee":{"login":"bcipolli","id":4072455,"avatar_url":"https://avatars.githubusercontent.com/u/4072455?v=3","gravatar_id":"","url":"https://api.github.com/users/bcipolli","html_url":"https://github.com/bcipolli","followers_url":"https://api.github.com/users/bcipolli/followers","following_url":"https://api.github.com/users/bcipolli/following{/other_user}","gists_url":"https://api.github.com/users/bcipolli/gists{/gist_id}","starred_url":"https://api.github.com/users/bcipolli/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bcipolli/subscriptions","organizations_url":"https://api.github.com/users/bcipolli/orgs","repos_url":"https://api.github.com/users/bcipolli/repos","events_url":"https://api.github.com/users/bcipolli/events{/privacy}","received_events_url":"https://api.github.com/users/bcipolli/received_events","type":"User","site_admin":false},"assignees":[{"login":"bcipolli","id":4072455,"avatar_url":"https://avatars.githubusercontent.com/u/4072455?v=3","gravatar_id":"","url":"https://api.github.com/users/bcipolli","html_url":"https://github.com/bcipolli","followers_url":"https://api.github.com/users/bcipolli/followers","following_url":"https://api.github.com/users/bcipolli/following{/other_user}","gists_url":"https://api.github.com/users/bcipolli/gists{/gist_id}","starred_url":"https://api.github.com/users/bcipolli/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bcipolli/subscriptions","organizations_url":"https://api.github.com/users/bcipolli/orgs","repos_url":"https://api.github.com/users/bcipolli/repos","events_url":"https://api.github.com/users/bcipolli/events{/privacy}","received_events_url":"https://api.github.com/users/bcipolli/received_events","type":"User","site_admin":false},{"login":"monkeyhippies","id":8634687,"avatar_url":"https://avatars.githubusercontent.com/u/8634687?v=3","gravatar_id":"","url":"https://api.github.com/users/monkeyhippies","html_url":"https://github.com/monkeyhippies","followers_url":"https://api.github.com/users/monkeyhippies/followers","following_url":"https://api.github.com/users/monkeyhippies/following{/other_user}","gists_url":"https://api.github.com/users/monkeyhippies/gists{/gist_id}","starred_url":"https://api.github.com/users/monkeyhippies/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/monkeyhippies/subscriptions","organizations_url":"https://api.github.com/users/monkeyhippies/orgs","repos_url":"https://api.github.com/users/monkeyhippies/repos","events_url":"https://api.github.com/users/monkeyhippies/events{/privacy}","received_events_url":"https://api.github.com/users/monkeyhippies/received_events","type":"User","site_admin":false}],"milestone":null,"comments":4,"created_at":"2016-06-02T04:23:04Z","updated_at":"2016-08-24T21:04:17Z","closed_at":"2016-08-24T21:04:17Z","body":"The title isn't quite correct, I lost the stack trace, but have seen this KeyError pop up. Looks like Netfile has changed some fields and added some new ones. Here's a diff of the column headers between old and new csvs, sorted.\r\n\r\n```\r\n--- data/netfile/csv/netfile_2015_CMA_cal201_export.csv.txt\t2016-06-01 21:11:12.002740733 -0700\r\n+++ data/netfile/csv/netfile_2015_CMA_cal201_export.new.csv.txt\t2016-06-01 21:11:12.005740798 -0700\r\n@@ -18,9 +18,12 @@\r\n end_Bal\r\n entity_Cd\r\n externalId\r\n-filerId\r\n+filerLocalId\r\n filerName\r\n+filerStateId\r\n+filingEndDate\r\n filingId\r\n+filingStartDate\r\n form_Type\r\n g_From_E_F\r\n int_CmteId\r\n```"},"comment":{"url":"https://api.github.com/repos/caciviclab/disclosure-backend/issues/comments/242207479","html_url":"https://github.com/caciviclab/disclosure-backend/issues/247#issuecomment-242207479","issue_url":"https://api.github.com/repos/caciviclab/disclosure-backend/issues/247","id":242207479,"user":{"login":"mikeubell","id":6759416,"avatar_url":"https://avatars.githubusercontent.com/u/6759416?v=3","gravatar_id":"","url":"https://api.github.com/users/mikeubell","html_url":"https://github.com/mikeubell","followers_url":"https://api.github.com/users/mikeubell/followers","following_url":"https://api.github.com/users/mikeubell/following{/other_user}","gists_url":"https://api.github.com/users/mikeubell/gists{/gist_id}","starred_url":"https://api.github.com/users/mikeubell/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mikeubell/subscriptions","organizations_url":"https://api.github.com/users/mikeubell/orgs","repos_url":"https://api.github.com/users/mikeubell/repos","events_url":"https://api.github.com/users/mikeubell/events{/privacy}","received_events_url":"https://api.github.com/users/mikeubell/received_events","type":"User","site_admin":false},"created_at":"2016-08-24T21:04:17Z","updated_at":"2016-08-24T21:04:17Z","body":"I believe this was fixed in my and/or Tom's commit last week."}}
{"actor":{"display_login":"mikeubell"}}