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
#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 post_record = { 'title': { 'value': 'title1' } } post_records = [ { 'title': { 'value': 'title1'
#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 post_record = {'title': {'value': 'title1'}} post_records = [{'title': {'value': 'title1'}}, {'title': {'value': 'title2'}}] ##Single Record post_record_resp = kintone.post_record(app_id, post_record) print(post_record_resp) ##Multi Records (~100 records)