UPDATE: This is the fix:
var request = BigQuery.newQueryRequest();
request.query = sql
// Inserts a Query Job
try {
queryResults = BigQuery.Jobs.query(request,projectNumber);
}
catch (err) {
Logger.log(err);
Browser.msgBox(err);
return;
}
My BigQuery > Google Spreadsheet has been working fine until now, that I'm getting the error 'Required parameter is missing'
The line of code that is throwing the exception is:
try {
queryResults = BigQuery.Jobs.query(projectNumber, sql, {'timeoutMs':10000});
}
The full code is in this tutorial.
https://developers.google.com/apps-script/articles/bigquery_tutorial#section2
Has this happened to anyone else? Have you find a solution to this?