未找到OAuth客户端 - Google Apps脚本 - BigQuery [英] The OAuth Client was not found - Google Apps Script - BigQuery

问题描述

我正尝试使用App Script将BigQuery结果加载到Google Spreadsheet中。这里是我的代码

  function runQuery（）{
 var projectId ='xxxxx'; 
 
 var request = {
 query：'select * from ASRLogs.LocationBasedClicks;'
}; 
 
 var queryResults = BigQuery.Jobs.query（request，projectId）; 
 var jobId = queryResults.jobReference.jobId; 
 
 //检查查询作业的状态。 
 var sleepTimeMs = 500; $！
 $ b while（！queryResults.jobComplete）
 {
 Utilities.sleep（sleepTimeMs）; 
 sleepTimeMs * = 2; 
 queryResults = BigQuery.Jobs.getQueryResults（projectId，jobId）; 
} 
 
 //获取结果的所有行。 
 var rows = queryResults.rows; 
 while（queryResults.pageToken）{
 queryResults = BigQuery.Jobs.getQueryResults（projectId，jobId，{
 pageToken：queryResults.pageToken 
}）; 
 rows = rows.concat（queryResults.rows）; 
 
 
 if（rows）{
 var spreadsheet = SpreadsheetApp.create（BigQuery Results）; 
 var sheet = spreadsheet.getActiveSheet（）; 
 
 //追加头文件
 var headers = queryResults.schema.fields.map（function（field）{
 return field.name; 
}）; 
 sheet.appendRow（headers）
 
 //追加结果。 
 var data = new Array（rows.length）; 
 for（var i = 0; i< rows.length; i ++）{
 var cols = rows [i] .f; 
 data [i] = new Array（cols.length）; （var j = 0; j< cols.length; j ++）{
 data [i] [j] = cols [j] .v; 
} 
} 
 sheet.getRange（2,1，rows.length，headers.length）.setValue（data）; 
 
 Logger.log（'Results spreadsheet created：％s'，spreadsheet.getUrl（））; 
} else {
 Logger.log（'No rows returned。'）
} 
} 
  

我得到的错误是：

错误：invalid_client

OAuth未找到客户。

请求详细信息

- cookie_policy_enforce = false

- 范围= https://www.googleapis.com/auth/bigquery https://www.googleapis.com/auth/spreadsheets

- response_type = code gsession

- redirect_uri = https://script.google.com/oauthcallback

- access_type =离线

- approval_prompt = force

- state = ACjPJvHwuS-sspO-j9b5vlH_Ul4VokI3QRANL-gwa7YWxz6-RFelZBuLQ2aiiGldHRgR89sMnvlgpsmSOnlquEY45oTt1IgZHWfoWq5e52Jf6l_G-5yPpPwCf40Dkv_JYR9welQPrQ

- client_id = [e-mail] eaccount.com

- hl = en

我错过了什么吗？我做了以下。
$ b

1. 在Google Serveices中启用BigQuery API
   在项目的开发人员控制台中启用BigQuery。

解决方案

我多次复制文档，然后复制其中的所有脚本，并将每个脚本附加到复制中。我最后得到的是副本副本副本副本。

作为最后的手段，我将脚本项目重命名为，并且嘿嘿，它很好。

我的理论是，由于Script项目名称被用作请求授权的应用程序的名称，所以在这里有一些字符限制。

重命名项目到一个较短的名称解决了这个问题？

I am trying to use App Script to load BigQuery results into a Google Spreadsheet. Here is my Code

function runQuery() {
var projectId = 'xxxxx';

var request = {
  query: 'select * from ASRLogs.LocationBasedClicks;'
};

var queryResults = BigQuery.Jobs.query(request,projectId);
var jobId = queryResults.jobReference.jobId;

// Check on status of the Query Job. 
var sleepTimeMs = 500;

while(!queryResults.jobComplete)
{
   Utilities.sleep(sleepTimeMs);
   sleepTimeMs *=2;
   queryResults = BigQuery.Jobs.getQueryResults(projectId, jobId);
}

// Get all the rows of the result. 
var rows = queryResults.rows;
while (queryResults.pageToken) {
   queryResults = BigQuery.Jobs.getQueryResults(projectId, jobId, {
       pageToken: queryResults.pageToken
   });
   rows = rows.concat(queryResults.rows);
}

if (rows) {
     var spreadsheet = SpreadsheetApp.create("BigQuery Results");
     var sheet = spreadsheet.getActiveSheet();

     // Append the headers
     var headers = queryResults.schema.fields.map(function(field) {
       return field.name;
     });
     sheet.appendRow(headers)

     // Append the results. 
     var data = new Array(rows.length);
     for (var i = 0; i < rows.length; i ++){
       var cols = rows[i].f;
       data[i] = new Array(cols.length);
       for (var j =0; j < cols.length; j++){
         data[i][j] = cols[j].v;
       }
     }
     sheet.getRange(2,1,rows.length,headers.length).setValue(data);

     Logger.log('Results spreadsheet created: %s', spreadsheet.getUrl());
} else {
  Logger.log('No rows returned.')
}
}

The error I get is

Error: invalid_client
The OAuth client was not found.
Request Details
- cookie_policy_enforce=false
- scope=https://www.googleapis.com/auth/bigquery https://www.googleapis.com/auth/spreadsheets
- response_type=code gsession
- redirect_uri=https://script.google.com/oauthcallback
- access_type=offline
- approval_prompt=force
- state=ACjPJvHwuS-sspO-j9b5vlH_Ul4VokI3QRANL-gwa7YWxz6-RFelZBuLQ2aiiGldHRgR89sMnvlgpsmSOnlquEY45oTt1IgZHWfoWq5e52Jf6l_G-5yPpPwCf40Dkv_JYR9welQPrQ
- client_id=[e-mail]
- hl=en

Am I missing something ? I have done the following.

1. Enabled BigQuery API in Google Serveices
2. Enabled BigQuery in the developer console for the project.

解决方案

I had this exact same issue yesterday.

I had been copying a document several times, which will in turn copy all the scripts inside of it, appending each with "Copy of". What I had ended up with was "Copy of Copy of Copy of Copy of Copy of ".

As a last resort, I renamed the Script project to "", and hey presto, it came good.

My theory is that since the Script project name is being used as the name of the application requesting authorisation, there is some character limit going on here.

Does renaming the project to a shorter name fix the issue?

这篇关于未找到OAuth客户端 - Google Apps脚本 - BigQuery的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！