{"action":"created","issue":{"url":"https://api.github.com/repos/theoephraim/node-google-spreadsheet/issues/159","repository_url":"https://api.github.com/repos/theoephraim/node-google-spreadsheet","labels_url":"https://api.github.com/repos/theoephraim/node-google-spreadsheet/issues/159/labels{/name}","comments_url":"https://api.github.com/repos/theoephraim/node-google-spreadsheet/issues/159/comments","events_url":"https://api.github.com/repos/theoephraim/node-google-spreadsheet/issues/159/events","html_url":"https://github.com/theoephraim/node-google-spreadsheet/issues/159","id":239798032,"number":159,"title":"TypeError: Cannot read property '$' of undefined when using sheet.del();","user":{"login":"maciej-w","id":12381590,"avatar_url":"https://avatars0.githubusercontent.com/u/12381590?v=4","gravatar_id":"","url":"https://api.github.com/users/maciej-w","html_url":"https://github.com/maciej-w","followers_url":"https://api.github.com/users/maciej-w/followers","following_url":"https://api.github.com/users/maciej-w/following{/other_user}","gists_url":"https://api.github.com/users/maciej-w/gists{/gist_id}","starred_url":"https://api.github.com/users/maciej-w/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/maciej-w/subscriptions","organizations_url":"https://api.github.com/users/maciej-w/orgs","repos_url":"https://api.github.com/users/maciej-w/repos","events_url":"https://api.github.com/users/maciej-w/events{/privacy}","received_events_url":"https://api.github.com/users/maciej-w/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2017-06-30T14:36:59Z","updated_at":"2017-10-17T20:45:12Z","closed_at":null,"author_association":"NONE","body":"I just run your example code on a sheet of mine, and it works fine, changing the values of the rows, then adds a sheet but looks like it fails on this line of code:\r\n`sheet.del(); //async `\r\n\r\nIf above line is commented out, error doesn't appear.\r\n\r\n```\r\nsheet 1: Sheet1 990x26\r\nRead 40 rows\r\nCell R1C1 = 1\r\nevents.js:141\r\n      throw er; // Unhandled 'error' event\r\n      ^\r\n\r\nTypeError: Cannot read property '$' of undefined\r\n    at self.updateValuesFromResponseData (C:\\Users\\user\\Documents\\Visual Studio 2017\\Projects\\NodejsConsoleApp1\\NodejsConsoleApp1\\node_modules\\google-spreadsheet\\index.js:539:37)\r\n    at C:\\Users\\user\\Documents\\Visual Studio 2017\\Projects\\NodejsConsoleApp1\\NodejsConsoleApp1\\node_modules\\google-spreadsheet\\index.js:436:50\r\n    at Array.forEach (native)\r\n    at C:\\Users\\user\\Documents\\Visual Studio 2017\\Projects\\NodejsConsoleApp1\\NodejsConsoleApp1\\node_modules\\google-spreadsheet\\index.js:435:55\r\n    at C:\\Users\\user\\Documents\\Visual Studio 2017\\Projects\\NodejsConsoleApp1\\NodejsConsoleApp1\\node_modules\\google-spreadsheet\\index.js:166:15\r\n    at Parser.<anonymous> (C:\\Users\\user\\Documents\\Visual Studio 2017\\Projects\\NodejsConsoleApp1\\NodejsConsoleApp1\\node_modules\\xml2js\\lib\\xml2js.js:489:18)\r\n    at emitOne (events.js:77:13)\r\n    at Parser.emit (events.js:169:7)\r\n    at Object.onclosetag (C:\\Users\\user\\Documents\\Visual Studio 2017\\Projects\\NodejsConsoleApp1\\NodejsConsoleApp1\\node_modules\\xml2js\\lib\\xml2js.js:447:26)\r\n    at emit (C:\\Users\\user\\Documents\\Visual Studio 2017\\Projects\\NodejsConsoleApp1\\NodejsConsoleApp1\\node_modules\\sax\\lib\\sax.js:624:35)\r\n```"},"comment":{"url":"https://api.github.com/repos/theoephraim/node-google-spreadsheet/issues/comments/337365185","html_url":"https://github.com/theoephraim/node-google-spreadsheet/issues/159#issuecomment-337365185","issue_url":"https://api.github.com/repos/theoephraim/node-google-spreadsheet/issues/159","id":337365185,"user":{"login":"maciej-w","id":12381590,"avatar_url":"https://avatars0.githubusercontent.com/u/12381590?v=4","gravatar_id":"","url":"https://api.github.com/users/maciej-w","html_url":"https://github.com/maciej-w","followers_url":"https://api.github.com/users/maciej-w/followers","following_url":"https://api.github.com/users/maciej-w/following{/other_user}","gists_url":"https://api.github.com/users/maciej-w/gists{/gist_id}","starred_url":"https://api.github.com/users/maciej-w/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/maciej-w/subscriptions","organizations_url":"https://api.github.com/users/maciej-w/orgs","repos_url":"https://api.github.com/users/maciej-w/repos","events_url":"https://api.github.com/users/maciej-w/events{/privacy}","received_events_url":"https://api.github.com/users/maciej-w/received_events","type":"User","site_admin":false},"created_at":"2017-10-17T20:45:12Z","updated_at":"2017-10-17T20:45:12Z","author_association":"NONE","body":"@theoephraim - sorry for late reply and thanks for help and writing great software!"}}
{"actor":{"display_login":"maciej-w"}}