{"action":"opened","issue":{"url":"https://api.github.com/repos/chriszarate/sheetrock/issues/85","repository_url":"https://api.github.com/repos/chriszarate/sheetrock","labels_url":"https://api.github.com/repos/chriszarate/sheetrock/issues/85/labels{/name}","comments_url":"https://api.github.com/repos/chriszarate/sheetrock/issues/85/comments","events_url":"https://api.github.com/repos/chriszarate/sheetrock/issues/85/events","html_url":"https://github.com/chriszarate/sheetrock/issues/85","id":131725847,"number":85,"title":"Header row is included in results","user":{"login":"fatuhoku","id":430233,"avatar_url":"https://avatars.githubusercontent.com/u/430233?v=3","gravatar_id":"","url":"https://api.github.com/users/fatuhoku","html_url":"https://github.com/fatuhoku","followers_url":"https://api.github.com/users/fatuhoku/followers","following_url":"https://api.github.com/users/fatuhoku/following{/other_user}","gists_url":"https://api.github.com/users/fatuhoku/gists{/gist_id}","starred_url":"https://api.github.com/users/fatuhoku/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fatuhoku/subscriptions","organizations_url":"https://api.github.com/users/fatuhoku/orgs","repos_url":"https://api.github.com/users/fatuhoku/repos","events_url":"https://api.github.com/users/fatuhoku/events{/privacy}","received_events_url":"https://api.github.com/users/fatuhoku/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2016-02-05T18:59:30Z","updated_at":"2016-02-05T18:59:30Z","closed_at":null,"body":"README says:\r\n> - One header row. Sheetrock expects a single header row of column labels in the first row of the Sheet. Any other configuration (e.g., no header row, multiple or offset header rows) can cause problems with the request and complicates templating.\r\n\r\nBut when I run example:\r\n\r\n```\r\nsheetrock({\r\n  url: \"https://docs.google.com/spreadsheets/d/1qT1LyvoAcb0HTsi2rHBltBVpUBumAUzT__rhMvrz5Rk/edit#gid=0\",\r\n  query: \"select A,B,C,D,E,L where E = 'Both' order by L desc\",\r\n  callback: myCallback\r\n});\r\n```\r\n\r\nYou get:\r\n\r\n```\r\n[ { cells: \r\n     { Team: 'Team',\r\n       Pos: 'Pos',\r\n       First: 'First',\r\n       Last: 'Last',\r\n       Bats: 'Bats',\r\n       BA: 'BA' },\r\n    cellsArray: [ 'Team', 'Pos', 'First', 'Last', 'Bats', 'BA' ],\r\n    labels: [ 'Team', 'Pos', 'First', 'Last', 'Bats', 'BA' ],\r\n    num: 0 },\r\n...\r\n```"}}