Last active
October 12, 2017 04:41
-
-
Save tak-km/3a0b28daaa8187c52e306d3ff0f39ef9 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
from __future__ import print_function | |
from future.standard_library import install_aliases | |
install_aliases() | |
from urllib.parse import urlparse, urlencode | |
from urllib.request import urlopen, Request | |
from urllib.error import HTTPError | |
import json | |
import os | |
from flask import Flask | |
from flask import request | |
from flask import make_response, jsonify | |
import gspread | |
from oauth2client.service_account import ServiceAccountCredentials | |
# Flask app should start in global layout | |
app = Flask(__name__) | |
@app.route('/webhook', methods=['POST']) | |
def webhook(): | |
req = request.get_json(silent=True, force=True) | |
result = req.get("result") | |
parameters = result.get("parameters") | |
weapon_name = parameters.get("weapon_name") | |
scope = ['https://spreadsheets.google.com/feeds'] | |
#ダウンロードしたjsonファイルを同じフォルダに格納して指定する | |
credentials = ServiceAccountCredentials.from_json_keyfile_name('xxxxxxxxxx.json', scope) | |
gc = gspread.authorize(credentials) | |
# # 共有設定したスプレッドシートの名前を指定する | |
worksheet = gc.open("Google Assistant Commands").get_worksheet(1) | |
cell = worksheet.find(weapon_name) | |
text = str(cell.value) + str(worksheet.cell(cell.row,cell.col+1).value) + "パーセント" | |
r = make_response(jsonify({'speech':text,'displayText':text})) | |
r.headers['Content-Type'] = 'application/json' | |
return r | |
if __name__ == '__main__': | |
port = int(os.getenv('PORT', 5000)) | |
print("Starting app on port %d" % port) | |
app.run(debug=False, port=port, host='0.0.0.0') |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment