Naveen Kumar
Reputation: 1
How to fix the "SyntaxError: Unexpected token: a" with importjson in Google Sheets
I am trying to import the following link into Google Sheets with importjson and am facing the following error:
https://sas.indiatimes.com/TechnicalsClient/getMACD.htm?crossovertype=MACD_CROSSED_ABOVE_SIGNAL&pagesize=25&exchange=50&pageno=1&sortby=volume&sortorder=desc&indexid=2365&company=true&ctype=MACD&callback=ajaxResponse
SyntaxError: Unexpected token: a (line 128).
Any ways to fix this?
Upvotes: 0
Views: 600
Answers (1)
Jesse Sliter
Reputation: 243
Well the stuff being returned to you is JSONP, not just regular JSON, so that could be your issue. jsonp is bascially a json object being wrapped by a function, in this case ajaxResponse.
Upvotes: 2
Related Questions
- Exception: The number of columns in the data does not match the number of columns in the range ImportJson API call issue
- Importing Importing API data via importJSON
- I am running into an issue using ImportJSON w/ Google Sheets to import data
- importJSON returns error code 429 (rate limited) from the server while I'm not
- ImportJSON for Google Sheets Can't Handle File WIthout Properties?
- Using importjson when cell is an URL, JSON format in Gsheets
- Json import in googlesheet
- SyntaxError: Unexpected number when pulling JSON data
- SyntaxError: Unexpected token < in JSON at position 0 in Google Sheets Apps Script Tutorial
- Error While Inserting json data into Google SpreadSheet