search

pat310 / google-trends-api

An API layer on top of google trends
https://www.npmjs.com/package/google-trends-api
MIT License
894 stars 178 forks source link

Possible bug in parseJSON function #22

Closed therajumandapati closed 8 years ago

therajumandapati commented 8 years ago

There might be a possible bug in parseJSON function. https://github.com/pat310/google-trends-api/blob/master/src/resources/htmlParser.js#L38

  1. When querying with multiple keywords, the data returned by this function is wrong and doesn't match the data returned by Google Trends call made in browser. So there's a bug in this function.
  2. Why are you using Regex? I think parsing the JSON inside the function google.visualization.Query.setResponse is much safer and correct. This way you can easily separate the data for multiple keywords into their own array just by looping through the response once.

I'd like to make a fix to this by rewriting the parseJSON function to use the JSON parsing idea I have in point 2.

Would you like to accept a merge ?

dreyco676 commented 8 years ago

I'm working on a Python implementation of this and for your second point I can't get the JSON to parse, it seems like its not valid JSON structure according to JSONlint.com.

Suggestions?

therajumandapati commented 8 years ago

Can you provide a link to that JSON put somewhere ?

dreyco676 commented 8 years ago

It does not parse after removing the first 62 characters and the last 2 like

// Data table response
google.visualization.Query.setResponse();

This is the raw response. 

// Data table response
google.visualization.Query.setResponse({"version":"0.6","status":"ok","sig":"1141460238","table":{"cols":[{"id":"date","label":"Date","type":"date","pattern":""},{"id":"query0","label":"pizza","type":"number","pattern":""},{"id":"query1","label":"italian","type":"number","pattern":""},{"id":"query2","label":"spaghetti","type":"number","pattern":""},{"id":"query3","label":"breadsticks","type":"number","pattern":""},{"id":"query4","label":"sausage","type":"number","pattern":""}],"rows":[{"c":[{"v":new Date(2004,0,1),"f":"December 2003"},{"v":33.0,"f":"33"},{"v":9.0,"f":"9"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2004,1,1),"f":"January 2004"},{"v":31.0,"f":"31"},{"v":10.0,"f":"10"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2004,2,1),"f":"February 2004"},{"v":31.0,"f":"31"},{"v":9.0,"f":"9"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":2.0,"f":"2"}]},{"c":[{"v":new Date(2004,3,1),"f":"March 2004"},{"v":32.0,"f":"32"},{"v":9.0,"f":"9"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":2.0,"f":"2"}]},{"c":[{"v":new Date(2004,4,1),"f":"April 2004"},{"v":32.0,"f":"32"},{"v":9.0,"f":"9"},{"v":2.0,"f":"2"},{"v":0.0,"f":"0"},{"v":2.0,"f":"2"}]},{"c":[{"v":new Date(2004,5,1),"f":"May 2004"},{"v":30.0,"f":"30"},{"v":8.0,"f":"8"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":2.0,"f":"2"}]},{"c":[{"v":new Date(2004,6,1),"f":"June 2004"},{"v":34.0,"f":"34"},{"v":9.0,"f":"9"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":2.0,"f":"2"}]},{"c":[{"v":new Date(2004,7,1),"f":"July 2004"},{"v":33.0,"f":"33"},{"v":9.0,"f":"9"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":2.0,"f":"2"}]},{"c":[{"v":new Date(2004,8,1),"f":"August 2004"},{"v":31.0,"f":"31"},{"v":9.0,"f":"9"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":2.0,"f":"2"}]},{"c":[{"v":new Date(2004,9,1),"f":"September 2004"},{"v":36.0,"f":"36"},{"v":10.0,"f":"10"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2004,10,1),"f":"October 2004"},{"v":33.0,"f":"33"},{"v":11.0,"f":"11"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":4.0,"f":"4"}]},{"c":[{"v":new Date(2004,11,1),"f":"November 2004"},{"v":35.0,"f":"35"},{"v":11.0,"f":"11"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":4.0,"f":"4"}]},{"c":[{"v":new Date(2005,0,1),"f":"December 2004"},{"v":37.0,"f":"37"},{"v":9.0,"f":"9"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2005,1,1),"f":"January 2005"},{"v":40.0,"f":"40"},{"v":10.0,"f":"10"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2005,2,1),"f":"February 2005"},{"v":37.0,"f":"37"},{"v":10.0,"f":"10"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":2.0,"f":"2"}]},{"c":[{"v":new Date(2005,3,1),"f":"March 2005"},{"v":37.0,"f":"37"},{"v":9.0,"f":"9"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":2.0,"f":"2"}]},{"c":[{"v":new Date(2005,4,1),"f":"April 2005"},{"v":36.0,"f":"36"},{"v":9.0,"f":"9"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":2.0,"f":"2"}]},{"c":[{"v":new Date(2005,5,1),"f":"May 2005"},{"v":35.0,"f":"35"},{"v":8.0,"f":"8"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":2.0,"f":"2"}]},{"c":[{"v":new Date(2005,6,1),"f":"June 2005"},{"v":39.0,"f":"39"},{"v":8.0,"f":"8"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":2.0,"f":"2"}]},{"c":[{"v":new Date(2005,7,1),"f":"July 2005"},{"v":38.0,"f":"38"},{"v":9.0,"f":"9"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":2.0,"f":"2"}]},{"c":[{"v":new Date(2005,8,1),"f":"August 2005"},{"v":39.0,"f":"39"},{"v":9.0,"f":"9"},{"v":4.0,"f":"4"},{"v":0.0,"f":"0"},{"v":2.0,"f":"2"}]},{"c":[{"v":new Date(2005,9,1),"f":"September 2005"},{"v":40.0,"f":"40"},{"v":10.0,"f":"10"},{"v":4.0,"f":"4"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2005,10,1),"f":"October 2005"},{"v":40.0,"f":"40"},{"v":10.0,"f":"10"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":4.0,"f":"4"}]},{"c":[{"v":new Date(2005,11,1),"f":"November 2005"},{"v":43.0,"f":"43"},{"v":11.0,"f":"11"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":4.0,"f":"4"}]},{"c":[{"v":new Date(2006,0,1),"f":"December 2005"},{"v":43.0,"f":"43"},{"v":9.0,"f":"9"},{"v":4.0,"f":"4"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2006,1,1),"f":"January 2006"},{"v":44.0,"f":"44"},{"v":10.0,"f":"10"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2006,2,1),"f":"February 2006"},{"v":42.0,"f":"42"},{"v":9.0,"f":"9"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":2.0,"f":"2"}]},{"c":[{"v":new Date(2006,3,1),"f":"March 2006"},{"v":41.0,"f":"41"},{"v":9.0,"f":"9"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":2.0,"f":"2"}]},{"c":[{"v":new Date(2006,4,1),"f":"April 2006"},{"v":40.0,"f":"40"},{"v":9.0,"f":"9"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":2.0,"f":"2"}]},{"c":[{"v":new Date(2006,5,1),"f":"May 2006"},{"v":41.0,"f":"41"},{"v":8.0,"f":"8"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":2.0,"f":"2"}]},{"c":[{"v":new Date(2006,6,1),"f":"June 2006"},{"v":44.0,"f":"44"},{"v":9.0,"f":"9"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":2.0,"f":"2"}]},{"c":[{"v":new Date(2006,7,1),"f":"July 2006"},{"v":44.0,"f":"44"},{"v":9.0,"f":"9"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":2.0,"f":"2"}]},{"c":[{"v":new Date(2006,8,1),"f":"August 2006"},{"v":44.0,"f":"44"},{"v":9.0,"f":"9"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2006,9,1),"f":"September 2006"},{"v":45.0,"f":"45"},{"v":9.0,"f":"9"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2006,10,1),"f":"October 2006"},{"v":47.0,"f":"47"},{"v":9.0,"f":"9"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2006,11,1),"f":"November 2006"},{"v":52.0,"f":"52"},{"v":10.0,"f":"10"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":4.0,"f":"4"}]},{"c":[{"v":new Date(2007,0,1),"f":"December 2006"},{"v":49.0,"f":"49"},{"v":9.0,"f":"9"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2007,1,1),"f":"January 2007"},{"v":50.0,"f":"50"},{"v":9.0,"f":"9"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2007,2,1),"f":"February 2007"},{"v":49.0,"f":"49"},{"v":8.0,"f":"8"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":2.0,"f":"2"}]},{"c":[{"v":new Date(2007,3,1),"f":"March 2007"},{"v":49.0,"f":"49"},{"v":8.0,"f":"8"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":2.0,"f":"2"}]},{"c":[{"v":new Date(2007,4,1),"f":"April 2007"},{"v":47.0,"f":"47"},{"v":8.0,"f":"8"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":2.0,"f":"2"}]},{"c":[{"v":new Date(2007,5,1),"f":"May 2007"},{"v":48.0,"f":"48"},{"v":8.0,"f":"8"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":2.0,"f":"2"}]},{"c":[{"v":new Date(2007,6,1),"f":"June 2007"},{"v":49.0,"f":"49"},{"v":8.0,"f":"8"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":2.0,"f":"2"}]},{"c":[{"v":new Date(2007,7,1),"f":"July 2007"},{"v":48.0,"f":"48"},{"v":8.0,"f":"8"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":2.0,"f":"2"}]},{"c":[{"v":new Date(2007,8,1),"f":"August 2007"},{"v":48.0,"f":"48"},{"v":8.0,"f":"8"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":2.0,"f":"2"}]},{"c":[{"v":new Date(2007,9,1),"f":"September 2007"},{"v":50.0,"f":"50"},{"v":8.0,"f":"8"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2007,10,1),"f":"October 2007"},{"v":51.0,"f":"51"},{"v":8.0,"f":"8"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2007,11,1),"f":"November 2007"},{"v":57.0,"f":"57"},{"v":10.0,"f":"10"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":4.0,"f":"4"}]},{"c":[{"v":new Date(2008,0,1),"f":"December 2007"},{"v":53.0,"f":"53"},{"v":8.0,"f":"8"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2008,1,1),"f":"January 2008"},{"v":54.0,"f":"54"},{"v":8.0,"f":"8"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2008,2,1),"f":"February 2008"},{"v":54.0,"f":"54"},{"v":8.0,"f":"8"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":2.0,"f":"2"}]},{"c":[{"v":new Date(2008,3,1),"f":"March 2008"},{"v":52.0,"f":"52"},{"v":8.0,"f":"8"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":2.0,"f":"2"}]},{"c":[{"v":new Date(2008,4,1),"f":"April 2008"},{"v":54.0,"f":"54"},{"v":8.0,"f":"8"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":2.0,"f":"2"}]},{"c":[{"v":new Date(2008,5,1),"f":"May 2008"},{"v":54.0,"f":"54"},{"v":7.0,"f":"7"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":2.0,"f":"2"}]},{"c":[{"v":new Date(2008,6,1),"f":"June 2008"},{"v":51.0,"f":"51"},{"v":8.0,"f":"8"},{"v":3.0,"f":"3"},{"v":0.0,"f":"0"},{"v":2.0,"f":"2"}]},{"c":[{"v":new Date(2008,7,1),"f":"July 2008"},{"v":53.0,"f":"53"},{"v":7.0,"f":"7"},{"v":4.0,"f":"4"},{"v":0.0,"f":"0"},{"v":2.0,"f":"2"}]},{"c":[{"v":new Date(2008,8,1),"f":"August 2008"},{"v":51.0,"f":"51"},{"v":7.0,"f":"7"},{"v":4.0,"f":"4"},{"v":0.0,"f":"0"},{"v":2.0,"f":"2"}]},{"c":[{"v":new Date(2008,9,1),"f":"September 2008"},{"v":52.0,"f":"52"},{"v":7.0,"f":"7"},{"v":4.0,"f":"4"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2008,10,1),"f":"October 2008"},{"v":52.0,"f":"52"},{"v":8.0,"f":"8"},{"v":4.0,"f":"4"},{"v":0.0,"f":"0"},{"v":4.0,"f":"4"}]},{"c":[{"v":new Date(2008,11,1),"f":"November 2008"},{"v":55.0,"f":"55"},{"v":9.0,"f":"9"},{"v":4.0,"f":"4"},{"v":0.0,"f":"0"},{"v":4.0,"f":"4"}]},{"c":[{"v":new Date(2009,0,1),"f":"December 2008"},{"v":57.0,"f":"57"},{"v":8.0,"f":"8"},{"v":4.0,"f":"4"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2009,1,1),"f":"January 2009"},{"v":54.0,"f":"54"},{"v":8.0,"f":"8"},{"v":4.0,"f":"4"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2009,2,1),"f":"February 2009"},{"v":52.0,"f":"52"},{"v":7.0,"f":"7"},{"v":4.0,"f":"4"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2009,3,1),"f":"March 2009"},{"v":53.0,"f":"53"},{"v":7.0,"f":"7"},{"v":4.0,"f":"4"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2009,4,1),"f":"April 2009"},{"v":54.0,"f":"54"},{"v":7.0,"f":"7"},{"v":4.0,"f":"4"},{"v":0.0,"f":"0"},{"v":2.0,"f":"2"}]},{"c":[{"v":new Date(2009,5,1),"f":"May 2009"},{"v":51.0,"f":"51"},{"v":7.0,"f":"7"},{"v":4.0,"f":"4"},{"v":0.0,"f":"0"},{"v":2.0,"f":"2"}]},{"c":[{"v":new Date(2009,6,1),"f":"June 2009"},{"v":54.0,"f":"54"},{"v":7.0,"f":"7"},{"v":4.0,"f":"4"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2009,7,1),"f":"July 2009"},{"v":54.0,"f":"54"},{"v":8.0,"f":"8"},{"v":5.0,"f":"5"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2009,8,1),"f":"August 2009"},{"v":50.0,"f":"50"},{"v":7.0,"f":"7"},{"v":5.0,"f":"5"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2009,9,1),"f":"September 2009"},{"v":52.0,"f":"52"},{"v":8.0,"f":"8"},{"v":5.0,"f":"5"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2009,10,1),"f":"October 2009"},{"v":50.0,"f":"50"},{"v":7.0,"f":"7"},{"v":4.0,"f":"4"},{"v":0.0,"f":"0"},{"v":4.0,"f":"4"}]},{"c":[{"v":new Date(2009,11,1),"f":"November 2009"},{"v":53.0,"f":"53"},{"v":8.0,"f":"8"},{"v":4.0,"f":"4"},{"v":0.0,"f":"0"},{"v":5.0,"f":"5"}]},{"c":[{"v":new Date(2010,0,1),"f":"December 2009"},{"v":57.0,"f":"57"},{"v":8.0,"f":"8"},{"v":5.0,"f":"5"},{"v":0.0,"f":"0"},{"v":4.0,"f":"4"}]},{"c":[{"v":new Date(2010,1,1),"f":"January 2010"},{"v":56.0,"f":"56"},{"v":8.0,"f":"8"},{"v":5.0,"f":"5"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2010,2,1),"f":"February 2010"},{"v":52.0,"f":"52"},{"v":7.0,"f":"7"},{"v":4.0,"f":"4"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2010,3,1),"f":"March 2010"},{"v":52.0,"f":"52"},{"v":7.0,"f":"7"},{"v":4.0,"f":"4"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2010,4,1),"f":"April 2010"},{"v":55.0,"f":"55"},{"v":7.0,"f":"7"},{"v":4.0,"f":"4"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2010,5,1),"f":"May 2010"},{"v":54.0,"f":"54"},{"v":7.0,"f":"7"},{"v":4.0,"f":"4"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2010,6,1),"f":"June 2010"},{"v":62.0,"f":"62"},{"v":8.0,"f":"8"},{"v":4.0,"f":"4"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2010,7,1),"f":"July 2010"},{"v":64.0,"f":"64"},{"v":8.0,"f":"8"},{"v":5.0,"f":"5"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2010,8,1),"f":"August 2010"},{"v":61.0,"f":"61"},{"v":8.0,"f":"8"},{"v":5.0,"f":"5"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2010,9,1),"f":"September 2010"},{"v":64.0,"f":"64"},{"v":8.0,"f":"8"},{"v":5.0,"f":"5"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2010,10,1),"f":"October 2010"},{"v":62.0,"f":"62"},{"v":8.0,"f":"8"},{"v":5.0,"f":"5"},{"v":0.0,"f":"0"},{"v":4.0,"f":"4"}]},{"c":[{"v":new Date(2010,11,1),"f":"November 2010"},{"v":69.0,"f":"69"},{"v":9.0,"f":"9"},{"v":5.0,"f":"5"},{"v":0.0,"f":"0"},{"v":5.0,"f":"5"}]},{"c":[{"v":new Date(2011,0,1),"f":"December 2010"},{"v":68.0,"f":"68"},{"v":8.0,"f":"8"},{"v":5.0,"f":"5"},{"v":0.0,"f":"0"},{"v":4.0,"f":"4"}]},{"c":[{"v":new Date(2011,1,1),"f":"January 2011"},{"v":68.0,"f":"68"},{"v":9.0,"f":"9"},{"v":5.0,"f":"5"},{"v":0.0,"f":"0"},{"v":4.0,"f":"4"}]},{"c":[{"v":new Date(2011,2,1),"f":"February 2011"},{"v":64.0,"f":"64"},{"v":8.0,"f":"8"},{"v":5.0,"f":"5"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2011,3,1),"f":"March 2011"},{"v":69.0,"f":"69"},{"v":8.0,"f":"8"},{"v":4.0,"f":"4"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2011,4,1),"f":"April 2011"},{"v":67.0,"f":"67"},{"v":8.0,"f":"8"},{"v":4.0,"f":"4"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2011,5,1),"f":"May 2011"},{"v":70.0,"f":"70"},{"v":8.0,"f":"8"},{"v":4.0,"f":"4"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2011,6,1),"f":"June 2011"},{"v":75.0,"f":"75"},{"v":8.0,"f":"8"},{"v":5.0,"f":"5"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2011,7,1),"f":"July 2011"},{"v":73.0,"f":"73"},{"v":8.0,"f":"8"},{"v":5.0,"f":"5"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2011,8,1),"f":"August 2011"},{"v":69.0,"f":"69"},{"v":8.0,"f":"8"},{"v":5.0,"f":"5"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2011,9,1),"f":"September 2011"},{"v":73.0,"f":"73"},{"v":8.0,"f":"8"},{"v":6.0,"f":"6"},{"v":0.0,"f":"0"},{"v":4.0,"f":"4"}]},{"c":[{"v":new Date(2011,10,1),"f":"October 2011"},{"v":73.0,"f":"73"},{"v":8.0,"f":"8"},{"v":5.0,"f":"5"},{"v":0.0,"f":"0"},{"v":5.0,"f":"5"}]},{"c":[{"v":new Date(2011,11,1),"f":"November 2011"},{"v":80.0,"f":"80"},{"v":9.0,"f":"9"},{"v":5.0,"f":"5"},{"v":0.0,"f":"0"},{"v":5.0,"f":"5"}]},{"c":[{"v":new Date(2012,0,1),"f":"December 2011"},{"v":72.0,"f":"72"},{"v":8.0,"f":"8"},{"v":6.0,"f":"6"},{"v":0.0,"f":"0"},{"v":4.0,"f":"4"}]},{"c":[{"v":new Date(2012,1,1),"f":"January 2012"},{"v":75.0,"f":"75"},{"v":9.0,"f":"9"},{"v":5.0,"f":"5"},{"v":0.0,"f":"0"},{"v":4.0,"f":"4"}]},{"c":[{"v":new Date(2012,2,1),"f":"February 2012"},{"v":72.0,"f":"72"},{"v":8.0,"f":"8"},{"v":5.0,"f":"5"},{"v":0.0,"f":"0"},{"v":4.0,"f":"4"}]},{"c":[{"v":new Date(2012,3,1),"f":"March 2012"},{"v":76.0,"f":"76"},{"v":8.0,"f":"8"},{"v":5.0,"f":"5"},{"v":0.0,"f":"0"},{"v":4.0,"f":"4"}]},{"c":[{"v":new Date(2012,4,1),"f":"April 2012"},{"v":71.0,"f":"71"},{"v":8.0,"f":"8"},{"v":5.0,"f":"5"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2012,5,1),"f":"May 2012"},{"v":74.0,"f":"74"},{"v":8.0,"f":"8"},{"v":5.0,"f":"5"},{"v":0.0,"f":"0"},{"v":3.0,"f":"3"}]},{"c":[{"v":new Date(2012,6,1),"f":"June 2012"},{"v":75.0,"f":"75"},{"v":8.0,"f":"8"},{"v":5.0,"f":"5"},{"v":0.0,"f":"0"},{"v":4.0,"f":"4"}]},{"c":[{"v":new Date(2012,7,1),"f":"July 2012"},{"v":75.0,"f":"75"},{"v":9.0,"f":"9"},{"v":6.0,"f":"6"},{"v":0.0,"f":"0"},{"v":4.0,"f":"4"}]},{"c":[{"v":new Date(2012,8,1),"f":"August 2012"},{"v":75.0,"f":"75"},{"v":8.0,"f":"8"},{"v":6.0,"f":"6"},{"v":0.0,"f":"0"},{"v":4.0,"f":"4"}]},{"c":[{"v":new Date(2012,9,1),"f":"September 2012"},{"v":71.0,"f":"71"},{"v":8.0,"f":"8"},{"v":7.0,"f":"7"},{"v":0.0,"f":"0"},{"v":4.0,"f":"4"}]},{"c":[{"v":new Date(2012,10,1),"f":"October 2012"},{"v":69.0,"f":"69"},{"v":8.0,"f":"8"},{"v":6.0,"f":"6"},{"v":0.0,"f":"0"},{"v":5.0,"f":"5"}]},{"c":[{"v":new Date(2012,11,1),"f":"November 2012"},{"v":77.0,"f":"77"},{"v":9.0,"f":"9"},{"v":5.0,"f":"5"},{"v":0.0,"f":"0"},{"v":6.0,"f":"6"}]},{"c":[{"v":new Date(2013,0,1),"f":"December 2012"},{"v":74.0,"f":"74"},{"v":8.0,"f":"8"},{"v":6.0,"f":"6"},{"v":0.0,"f":"0"},{"v":5.0,"f":"5"}]},{"c":[{"v":new Date(2013,1,1),"f":"January 2013"},{"v":77.0,"f":"77"},{"v":8.0,"f":"8"},{"v":6.0,"f":"6"},{"v":0.0,"f":"0"},{"v":5.0,"f":"5"}]},{"c":[{"v":new Date(2013,2,1),"f":"February 2013"},{"v":77.0,"f":"77"},{"v":8.0,"f":"8"},{"v":6.0,"f":"6"},{"v":0.0,"f":"0"},{"v":4.0,"f":"4"}]},{"c":[{"v":new Date(2013,3,1),"f":"March 2013"},{"v":71.0,"f":"71"},{"v":8.0,"f":"8"},{"v":6.0,"f":"6"},{"v":0.0,"f":"0"},{"v":4.0,"f":"4"}]},{"c":[{"v":new Date(2013,4,1),"f":"April 2013"},{"v":73.0,"f":"73"},{"v":8.0,"f":"8"},{"v":5.0,"f":"5"},{"v":0.0,"f":"0"},{"v":4.0,"f":"4"}]},{"c":[{"v":new Date(2013,5,1),"f":"May 2013"},{"v":77.0,"f":"77"},{"v":8.0,"f":"8"},{"v":5.0,"f":"5"},{"v":0.0,"f":"0"},{"v":4.0,"f":"4"}]},{"c":[{"v":new Date(2013,6,1),"f":"June 2013"},{"v":77.0,"f":"77"},{"v":8.0,"f":"8"},{"v":6.0,"f":"6"},{"v":0.0,"f":"0"},{"v":4.0,"f":"4"}]},{"c":[{"v":new Date(2013,7,1),"f":"July 2013"},{"v":78.0,"f":"78"},{"v":8.0,"f":"8"},{"v":6.0,"f":"6"},{"v":0.0,"f":"0"},{"v":4.0,"f":"4"}]},{"c":[{"v":new Date(2013,8,1),"f":"August 2013"},{"v":73.0,"f":"73"},{"v":8.0,"f":"8"},{"v":7.0,"f":"7"},{"v":0.0,"f":"0"},{"v":4.0,"f":"4"}]},{"c":[{"v":new Date(2013,9,1),"f":"September 2013"},{"v":74.0,"f":"74"},{"v":8.0,"f":"8"},{"v":7.0,"f":"7"},{"v":0.0,"f":"0"},{"v":5.0,"f":"5"}]},{"c":[{"v":new Date(2013,10,1),"f":"October 2013"},{"v":78.0,"f":"78"},{"v":8.0,"f":"8"},{"v":7.0,"f":"7"},{"v":0.0,"f":"0"},{"v":6.0,"f":"6"}]},{"c":[{"v":new Date(2013,11,1),"f":"November 2013"},{"v":81.0,"f":"81"},{"v":9.0,"f":"9"},{"v":6.0,"f":"6"},{"v":0.0,"f":"0"},{"v":6.0,"f":"6"}]},{"c":[{"v":new Date(2014,0,1),"f":"December 2013"},{"v":80.0,"f":"80"},{"v":8.0,"f":"8"},{"v":7.0,"f":"7"},{"v":0.0,"f":"0"},{"v":5.0,"f":"5"}]},{"c":[{"v":new Date(2014,1,1),"f":"January 2014"},{"v":79.0,"f":"79"},{"v":9.0,"f":"9"},{"v":7.0,"f":"7"},{"v":0.0,"f":"0"},{"v":5.0,"f":"5"}]},{"c":[{"v":new Date(2014,2,1),"f":"February 2014"},{"v":81.0,"f":"81"},{"v":8.0,"f":"8"},{"v":7.0,"f":"7"},{"v":0.0,"f":"0"},{"v":5.0,"f":"5"}]},{"c":[{"v":new Date(2014,3,1),"f":"March 2014"},{"v":78.0,"f":"78"},{"v":8.0,"f":"8"},{"v":6.0,"f":"6"},{"v":0.0,"f":"0"},{"v":4.0,"f":"4"}]},{"c":[{"v":new Date(2014,4,1),"f":"April 2014"},{"v":78.0,"f":"78"},{"v":8.0,"f":"8"},{"v":6.0,"f":"6"},{"v":0.0,"f":"0"},{"v":4.0,"f":"4"}]},{"c":[{"v":new Date(2014,5,1),"f":"May 2014"},{"v":78.0,"f":"78"},{"v":8.0,"f":"8"},{"v":6.0,"f":"6"},{"v":0.0,"f":"0"},{"v":4.0,"f":"4"}]},{"c":[{"v":new Date(2014,6,1),"f":"June 2014"},{"v":82.0,"f":"82"},{"v":8.0,"f":"8"},{"v":6.0,"f":"6"},{"v":0.0,"f":"0"},{"v":4.0,"f":"4"}]},{"c":[{"v":new Date(2014,7,1),"f":"July 2014"},{"v":82.0,"f":"82"},{"v":8.0,"f":"8"},{"v":7.0,"f":"7"},{"v":0.0,"f":"0"},{"v":4.0,"f":"4"}]},{"c":[{"v":new Date(2014,8,1),"f":"August 2014"},{"v":75.0,"f":"75"},{"v":8.0,"f":"8"},{"v":7.0,"f":"7"},{"v":0.0,"f":"0"},{"v":4.0,"f":"4"}]},{"c":[{"v":new Date(2014,9,1),"f":"September 2014"},{"v":78.0,"f":"78"},{"v":8.0,"f":"8"},{"v":8.0,"f":"8"},{"v":0.0,"f":"0"},{"v":5.0,"f":"5"}]},{"c":[{"v":new Date(2014,10,1),"f":"October 2014"},{"v":84.0,"f":"84"},{"v":8.0,"f":"8"},{"v":7.0,"f":"7"},{"v":0.0,"f":"0"},{"v":6.0,"f":"6"}]},{"c":[{"v":new Date(2014,11,1),"f":"November 2014"},{"v":86.0,"f":"86"},{"v":10.0,"f":"10"},{"v":6.0,"f":"6"},{"v":0.0,"f":"0"},{"v":6.0,"f":"6"}]},{"c":[{"v":new Date(2015,0,1),"f":"December 2014"},{"v":85.0,"f":"85"},{"v":9.0,"f":"9"},{"v":7.0,"f":"7"},{"v":0.0,"f":"0"},{"v":6.0,"f":"6"}]},{"c":[{"v":new Date(2015,1,1),"f":"January 2015"},{"v":86.0,"f":"86"},{"v":8.0,"f":"8"},{"v":7.0,"f":"7"},{"v":0.0,"f":"0"},{"v":5.0,"f":"5"}]},{"c":[{"v":new Date(2015,2,1),"f":"February 2015"},{"v":80.0,"f":"80"},{"v":8.0,"f":"8"},{"v":6.0,"f":"6"},{"v":0.0,"f":"0"},{"v":5.0,"f":"5"}]},{"c":[{"v":new Date(2015,3,1),"f":"March 2015"},{"v":83.0,"f":"83"},{"v":8.0,"f":"8"},{"v":6.0,"f":"6"},{"v":0.0,"f":"0"},{"v":5.0,"f":"5"}]},{"c":[{"v":new Date(2015,4,1),"f":"April 2015"},{"v":85.0,"f":"85"},{"v":8.0,"f":"8"},{"v":6.0,"f":"6"},{"v":0.0,"f":"0"},{"v":5.0,"f":"5"}]},{"c":[{"v":new Date(2015,5,1),"f":"May 2015"},{"v":84.0,"f":"84"},{"v":8.0,"f":"8"},{"v":6.0,"f":"6"},{"v":0.0,"f":"0"},{"v":5.0,"f":"5"}]},{"c":[{"v":new Date(2015,6,1),"f":"June 2015"},{"v":88.0,"f":"88"},{"v":9.0,"f":"9"},{"v":6.0,"f":"6"},{"v":0.0,"f":"0"},{"v":5.0,"f":"5"}]},{"c":[{"v":new Date(2015,7,1),"f":"July 2015"},{"v":87.0,"f":"87"},{"v":9.0,"f":"9"},{"v":7.0,"f":"7"},{"v":0.0,"f":"0"},{"v":5.0,"f":"5"}]},{"c":[{"v":new Date(2015,8,1),"f":"August 2015"},{"v":85.0,"f":"85"},{"v":9.0,"f":"9"},{"v":8.0,"f":"8"},{"v":0.0,"f":"0"},{"v":5.0,"f":"5"}]},{"c":[{"v":new Date(2015,9,1),"f":"September 2015"},{"v":87.0,"f":"87"},{"v":9.0,"f":"9"},{"v":8.0,"f":"8"},{"v":0.0,"f":"0"},{"v":6.0,"f":"6"}]},{"c":[{"v":new Date(2015,10,1),"f":"October 2015"},{"v":84.0,"f":"84"},{"v":8.0,"f":"8"},{"v":7.0,"f":"7"},{"v":0.0,"f":"0"},{"v":6.0,"f":"6"}]},{"c":[{"v":new Date(2015,11,1),"f":"November 2015"},{"v":90.0,"f":"90"},{"v":10.0,"f":"10"},{"v":7.0,"f":"7"},{"v":0.0,"f":"0"},{"v":7.0,"f":"7"}]},{"c":[{"v":new Date(2016,0,1),"f":"December 2015"},{"v":91.0,"f":"91"},{"v":9.0,"f":"9"},{"v":8.0,"f":"8"},{"v":0.0,"f":"0"},{"v":6.0,"f":"6"}]},{"c":[{"v":new Date(2016,1,1),"f":"January 2016"},{"v":93.0,"f":"93"},{"v":9.0,"f":"9"},{"v":8.0,"f":"8"},{"v":0.0,"f":"0"},{"v":5.0,"f":"5"}]},{"c":[{"v":new Date(2016,2,1),"f":"February 2016"},{"v":88.0,"f":"88"},{"v":9.0,"f":"9"},{"v":7.0,"f":"7"},{"v":0.0,"f":"0"},{"v":6.0,"f":"6"}]},{"c":[{"v":new Date(2016,3,1),"f":"March 2016"},{"v":90.0,"f":"90"},{"v":9.0,"f":"9"},{"v":7.0,"f":"7"},{"v":0.0,"f":"0"},{"v":5.0,"f":"5"}]},{"c":[{"v":new Date(2016,4,1),"f":"April 2016"},{"v":88.0,"f":"88"},{"v":9.0,"f":"9"},{"v":6.0,"f":"6"},{"v":0.0,"f":"0"},{"v":5.0,"f":"5"}]},{"c":[{"v":new Date(2016,5,1),"f":"May 2016"},{"v":94.0,"f":"94"},{"v":9.0,"f":"9"},{"v":7.0,"f":"7"},{"v":0.0,"f":"0"},{"v":5.0,"f":"5"}]},{"c":[{"v":new Date(2016,6,1),"f":"June 2016"},{"v":100.0,"f":"100"},{"v":10.0,"f":"10"},{"v":7.0,"f":"7"},{"v":0.0,"f":"0"},{"v":6.0,"f":"6"}]},{"c":[{"v":new Date(2016,7,1),"f":"July 2016"},{"v":89.0,"f":"89"},{"v":9.0,"f":"9"},{"v":7.0,"f":"7"},{"v":0.0,"f":"0"},{"v":12.0,"f":"12"}]},{"c":[{"v":new Date(2016,8,1),"f":"August 2016"},,,,,{"v":null}]}]}});
dreyco676 commented 8 years ago

I should also mention its for 5 keywords. It looks like its complaining about "new Date(2016,8,1)"

dreyco676 commented 8 years ago

Again, I'm working in Python for Pytrends, but here is how I got the JSON to parse.

def _trend_helper(self):
    # strip off js function call 'google.visualization.Query.setResponse();
    text = self.results[62:-2]
    # replace series of commas ',,,,'
    text = text.replace(',,,,', '')
    # replace js new Date(YYYY, M, 1) calls with ISO 8601 date as string
    pattern = re.compile(r'new Date\(\d{4},\d{1,2},1\)')
    for match in re.finditer(pattern, text):
        # slice off 'new Date(' and ')' and split by comma
        csv_date = match.group(0)[9:-1].split(',')
        year = csv_date[0]
        # js date function is 0 based... why...
        month = str(int(csv_date[1]) + 1).zfill(2)
        # covert into "YYYY-MM-DD" including quotes
        str_dt = '"' + year + '-' + month + '-01"'
        text = text.replace(match.group(0), str_dt)
    self.results = json.loads(text)

https://github.com/GeneralMills/pytrends

New version in json_returns branch

therajumandapati commented 8 years ago

Unfortunately I have 0 expertise in Python and I'm afraid I won't be able to help.

dreyco676 commented 8 years ago

Oh, so I should have been clearer, I've got it working. I'm trying to provide help incase you want this to work in js as well. If you want it to parse to JSON you need to do the following:

//Data Table
google.visualization.Query.setResponse(

After this it will pass JSON (RFC 4627)