Forum Discussion
_anomDiebolt_
11 years agoQrew Elite
Google would be executing ImportHTML fetch of the URL from its server (not your browser). Since Google does not have a valid ticket the request will not return your report data and the spreadsheet cell will not fill. Even if the request was successful ImportHTML requires you identify which table to extract (there are four dozen tables in a simple report page) and place in the formula's cell and you will be hard pressed to identify which table your data is in (and its position will likely change as QuickBase tweaks their page layout).
You are more likely to have success using ImportXML or ImportData but you still have the ticket issue to deal with. If you want to pursue this I would suggest you first import public CSV or XML data from a QuickBase URL. Next tackle the ticket issue or devise a scheme where the data you want to import or proxied through a server or service which you have access control to.
You are more likely to have success using ImportXML or ImportData but you still have the ticket issue to deal with. If you want to pursue this I would suggest you first import public CSV or XML data from a QuickBase URL. Next tackle the ticket issue or devise a scheme where the data you want to import or proxied through a server or service which you have access control to.