Here is the exhaustive list of all General Errors you can encounter while using ImportJSON.
Errors | Reason | Tips |
#ACTIVATE | You need to activate the function through the google sheets menu: click on extensions and then drag your mouse on ImportJson and click on (Re)activate add on. | Make sure that when you use ImportJson, always activate the add-on. |
#NAME | The add-on has not been properly activated for this spreadsheet. | “short”: “Go to menu > Extensions > ImportJson> (Re)Activate add-on |
#ERROR! | This is a generic error and unfortunately it doesn’t give valuable information! | Tips: Wait a minute and use the “Shake” button to refresh. If the error persists, please contact |
#SERVICE_TEMPORARILY_UNAVAILABLE | The add-on failed to communicate with our servers. It may be due to some maintenance on the system. | Wait a few minutes and use the Recalculate button to refresh. If the error persists, please contact us |
#UNIDENTIFIED_USER | You are not identified with the google account that is subscribed to ImportJson. | Make sure you are on the google account in which you subscribed to ImportJson. |
#GOOGLE_QUOTA_EXCEEDED | Google has limited daily quotas for some operations required by the function. The function usually does its best to limit these operations but you may have other scripts that consume your account resources. Quotas are reset on a daily basis. | Find more information about the error in Sidebar > Monitor. |
#REQUEST_NOT_AVAILABLE_FOR_THIS_TEMPLATE | You are currently working on a special spreadsheet template that has its own limitations. | Open a new spreadsheet to use your formula. |
#TOO_MANY_REQUESTS_AT_THE_SAME_TIME | Too many people may be trying to reach the domain | Wait a few minutes and retry |
#OTHER_ERROR | We could not identify the error. | Contact us at https://nodatanobusiness.com/contact-us. |