def main():
#kintoneの認証情報
domain = 'example.cybozu.com'
token = ''
app = 329
query = 'flag in ("まだ！！")'
#kinotoneに新規レコードが存在するかチェック
try:
kintone = Kintone()
kintone.set_domain(domain)
kintone.set_token_auth(token)
response = kintone.get_records(app, query)
records = response['records']
except:
print('Error: kintone.get_records is failed.')
return 1
#存在した場合、赤外線LEDでONを送信
if (len(records) > 0):
#lircを実行
try:
cmd = 'irsend SEND_ONCE aircon on'
output = subprocess.check_output(cmd.strip().split(' '))
print('Info: irsend Success!')
except:
print(output)
print('Error: irsend Failed!')
return 1
#レコードのフラグを実行済みに更新
record_num = records[0]['レコード番号']['value']
try:
record = {'flag': {'value': '実行済！！'}}
put_resp = kintone.put_record(app, record_num, record)
print(put_resp)
except:
print('Error: kintone.put_record is failed.')
return 1
print('Info: success!!.')
#正常終了
return 0
else:
print('Info: no records.')
return 0
def main():
#kintoneの認証情報
domain = 'example.cybozu.com'
token = ''
app = 329
query = 'flag in ("まだ！！")'
#kinotoneに新規レコードが存在するかチェック
try:
kintone = Kintone()
kintone.set_domain(domain)
kintone.set_token_auth(token)
response = kintone.get_records(app, query)
records = response['records']
except:
print('Error: kintone.get_records is failed.')
return 1
#存在した場合、赤外線LEDでONを送信
if (len(records) > 0):
#lircを実行
try:
cmd = 'irsend SEND_ONCE aircon on'
output = subprocess.check_output(cmd.strip().split(' '))
print('Info: irsend Success!')
except:
print(output)
print('Error: irsend Failed!')
return 1
#レコードのフラグを実行済みに更新
record_num = records[0]['レコード番号']['value']
try:
record = {
'flag': {
'value': '実行済！！'
}
}
put_resp = kintone.put_record(app, record_num, record)
print(put_resp)
except:
print('Error: kintone.put_record is failed.')
return 1
print('Info: success!!.')
#正常終了
return 0
else:
print('Info: no records.')
return 0
import os
from kintone_sdk4python import Kintone
# 独自ライブラリ呼び出し
import sys
sys.path.append(os.getcwd() + '/state')
from state import state
kintone = Kintone()
kintone.set_domain(os.environ["KINTONE_DOMAIN"])
# kintone.set_token_auth('api-token')
tokenArray = {
2: os.environ["KINTONE_REGISTER_TOKEN"],
3: os.environ["KINTONE_CONNECT_TOKEN"],
4: os.environ["KINTONE_SCENARIO_TOKEN"],
5: os.environ["KINTONE_HINT_TOKEN"],
6: os.environ["KINTONE_USER_TOKEN"],
7: os.environ["KINTONE_USERSCENARIO_TOKEN"]
}
class kintoneController:
def getState(userId):
appId = 2
kintone.set_token_auth(tokenArray[appId])
# query = "groupId = \"" + groupId + "\" and userId = \"" + userId + "\""
query = 'userId="' + userId
ret = kintone.get_records(appId, query, [hwid], True, '')
print(ret)
#!/usr/bin/env python
# -*- coding: utf_8 -*-
import sys
import os
from kintone_sdk4python import Kintone
kintone = Kintone()
#Authentication
kintone.set_domain('example.cybozu.com') #required
kintone.set_basic_auth('id', 'password')
kintone.set_user_auth('login_name', 'password')
kintone.set_token_auth('token')
#GET
app_id = 10
record_id = 1
##Single Record
get_record_resp = kintone.get_record(app_id, record_id)
print(get_record_resp)
##Multi Records (~500 records)
query = 'レコード番号 > 10'
fields = ['$id', '作成日時']
get_records_resp = kintone.get_records(app_id, query, fields)
print(get_records_resp)
##All Records
get_all_records_resp = kintone.get_records(app_id, query, fields, all_records=True)
print(get_all_records_resp)
#POST
#!/usr/bin/env python
# -*- coding: utf_8 -*-
import sys
import os
from kintone_sdk4python import Kintone
kintone = Kintone()
#Authentication
kintone.set_domain('example.cybozu.com') #required
kintone.set_basic_auth('id', 'password')
kintone.set_user_auth('login_name', 'password')
kintone.set_token_auth('token')
#GET
app_id = 10
record_id = 1
##Single Record
get_record_resp = kintone.get_record(app_id, record_id)
print(get_record_resp)
##Multi Records (~500 records)
query = 'レコード番号 > 10'
fields = ['$id', '作成日時']
get_records_resp = kintone.get_records(app_id, query, fields)
print(get_records_resp)
##All Records
get_all_records_resp = kintone.get_records(app_id,
query,
fields,
all_records=True)
