为远程计算机执行Google App脚本

2024-03-29 14:46:14 发布

您现在位置:Python中文网/ 问答频道 /正文

我正在根据给定的文档here编写脚本。我的想法是触发一个google应用程序脚本,在google电子表格中做一些更新工作。在

我有触发应用程序脚本所需的所有细节(如下所示)。在

  1. 范围
  2. 在凭证.json(包含客户机号、客户机号、项目号和其他必需的详细信息)
  3. 脚本ID
  4. 提供了范围正确的OAuth令牌和
  5. 将脚本项目部署为API可执行文件

我的Python脚本:

from __future__ import print_function
from apiclient import errors
from apiclient.discovery import build
from httplib2 import Http
from oauth2client import file as oauth_file, client, tools

def main():
    """Runs the sample.
    """
    SCRIPT_ID = '1v3598375_skjghksfjg79_97365XXXXS'

    # Setup the Apps Script API
    # SCOPES = 'https://www.googleapis.com/auth/script.projects'
    SCOPES = 'https://www.googleapis.com/auth/spreadsheets'
    store = oauth_file.Storage('token.json')
    creds = store.get()
    if not creds or creds.invalid:
        flow = client.flow_from_clientsecrets(r'C:\Users\Test\Desktop\credentials.json', SCOPES)
        creds = tools.run_flow(flow, store)
    service = build('script', 'v1', http=creds.authorize(Http()))

    # Create an execution request object.
    request = {"function": "doGet"}

    try:
        # Make the API request.
        response = service.scripts().run(body=request,
                scriptId=SCRIPT_ID).execute()

        if 'error' in response:
            # The API executed, but the script returned an error.
            # Extract the first (and only) set of error details. The values of
            # this object are the script's 'errorMessage' and 'errorType', and
            # an list of stack trace elements.
            error = response['error']['details'][0]
            print("Script error message: {0}".format(error['errorMessage']))

            if 'scriptStackTraceElements' in error:
                # There may not be a stacktrace if the script didn't start
                # executing.
                print("Script error stacktrace:")
                for trace in error['scriptStackTraceElements']:
                    print("\t{0}: {1}".format(trace['function'],
                        trace['lineNumber']))
        else:
            # The structure of the result depends upon what the Apps Script
            # function returns. Here, the function returns an Apps Script Object
            # with String keys and values, and so the result is treated as a
            # Python dictionary (folderSet).
            print ("DONE")

    except errors.HttpError as e:
        # The API encountered a problem before the script started executing.
        print(e.content)


if __name__ == '__main__':
    main()

我在这里的查询是,当我执行这个脚本时

  • 它将我重定向到登录页面,而不是授权它(附加的快照)。在
  • 只要我触发脚本,它就会启动一个浏览器。这里的想法是在不打开浏览器的情况下运行它。在

enter image description here

如何确保即使从远程计算机调用此脚本也能正常工作(这里的想法是远程触发它,并在组织内的任何用户打开它时打开它),并使其成为无浏览器事务。 请澄清。在


Tags: andthefromimport脚本anapiif