本文介绍了未找到Project {project-id},无法用于API调用的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我有一个叫做Big Query API的google appscript。它工作正常,但我想复制工作表并用于不同的报告集。我已经在几个月前成功复制了该文件。

I have a google appscript that calls the Big Query API. It's working fine, but I want to duplicate the sheet and use for a different set of reports. I've duplicated the file once successfully a couple of months ago.

现在,当复制报表并使用Big Query API进行身份验证时,出现以下错误:

Now when duplicating the report and authenticating with the Big Query API I get the following error:

Project {project-id-different-to-below}找不到,不能用于API调用(第16行,文件reportModel)

"Project {project-id-different-to-below} is not found and cannot be used for API calls. (line 16, file "reportModel")"

我无法识别邮件中的项目ID,它与写入我的代码中的项目ID不同。另外,在我尝试使用API​​验证API之前,错误消息将我链接到相关的控制台页面以启用API,因此不再执行此操作。

I don't recognise the project id in the message, it's not the same as the one written into my code. Also before when I authenticated the API by trying to use it, the error message linked me to the relevant console page to enable use of the API, it no longer does this.

这是代码的相关部分:

  var projectId = '{project-id}';

  var request = {
    query: sql_code,
    useLegacySql : false
  };

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

为什么会发生这种情况,以及如何使用API​​验证新的Google表单文件?此外,为什么错误消息中列出的项目ID与代码中写入的项目ID不同?

Why is this happening and how can I authenticate the new google sheet file with the API? Also, why is the project id listed in the error message different to the one written in the code?

推荐答案

我已设法现在解决这个问题,我点击了资源 - >高级Google服务。这有一个链接到'谷歌API控制台',如果你按照它的控制台将选择正确的项目,你可以启用大查询API。

I have managed to resolve this now and I did so by clicking 'Resources->Advanced Google Services'. This had a link to the 'Google API Console', if you follow it the console will have the correct project selected and you can enable the Big Query API.

我couldn找不到另一种方式来选择正确的项目,但我确信有一个。

I couldn't find another way to get the correct project selected, although I'm sure there is one.

这篇关于未找到Project {project-id},无法用于API调用的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

09-03 02:20