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)