我正在根据给定的文档here编写脚本。我的想法是触发一个google应用程序脚本,在google电子表格中做一些更新工作。在
我有触发应用程序脚本所需的所有细节(如下所示)。在
我的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()
我在这里的查询是,当我执行这个脚本时
如何确保即使从远程计算机调用此脚本也能正常工作(这里的想法是远程触发它,并在组织内的任何用户打开它时打开它),并使其成为无浏览器事务。 请澄清。在
目前没有回答
相关问题 更多 >
编程相关推荐