Here is the exhaustive list of all Data Source Errors you can encounter while using ImportFromWeb. When such an error occurs, no request is counted.
| Errors | Reason | Tips |
|---|---|---|
| #PENDING_REQUEST | Your data is still loading! | Keep the sidebar open for the cell to automatically refresh |
| #PAGE_REQUEST_FAILED | ImportFromWeb did not manage to load the page | Try using the jsRendering option. |
| #PAGE_NOT_FOUND | ImportFromWeb did not manage to find or load the page (sometimes simply because the page does not exist) | Try the page in your browser and check that the url is correct. |
| #PAGE_IS_EMPTY | The page that has been loaded by the function is empty | The targeted website may load content through Javascript. Try using the jsRendering option. |
| #URL_NOT_FILLED | No URL has been filled | You need to indicate one or a list of urls |
| URL_NOT_VALID | The url you have entered is not a valid url. | Check that the url includes the protocols http:// or https:// |
| #OTHER_REQUEST_ERROR | The function didn’t manage to reach the page. | Try the page in your browser and check that the url is correct. |
| #PARSING_FAILED | The page could have been loaded but the HTML/ JSON has not been correctly decoded | Try using the jsRendering option. |
| #CURL_REQUEST_NOT_VALID | The input seems to be a cUrl request, but the format could not be validated by the function. | Check that you’ve entered a valid cUrl request. If you are sure your input is correct, please contact us |
| #TOO_MANY_URLS | You cannot put more than 50 urls by formula | Make sure you have no more than 50 urls. |