倿 èšé²ã絊äžã·ã¹ãã ãžèªå飿º
åºéå€ã¯teamsideã§æå»ãã絊äžã¯å¥ã®ã·ã¹ãã ã§èšç®ããŠããäŒç€Ÿãªããæ¯æå€æ ãããŠã³ããŒãããŠè»¢èšããäœæ¥ãã¹ã¯ãªãã1æ¬ã«çœ®ãæããããŸãã
æµã
- æ¯ææ±ºãŸã£ãæ¥ã«å®è¡ç€Ÿå ãµãŒããŒã®å®æãžã§ãïŒcronã»ã¿ã¹ã¯ã¹ã±ãžã¥ãŒã©ïŒãã¹ã¯ãªãããå®è¡ããŸãã
- ã¡ã³ããŒã®å¯Ÿå¿ä»ã
GET /membersã§ã¡ã³ããŒçªå·ãšãã°ã€ã³ã¢ã«ãŠã³ãã察å¿ä»ããŸãã - åæã®å€æ ãååŸ
GET /attendancesã§1ãæåãæåŸãŸã§ååŸããŸãã - ãã¡ã€ã«ã«æŽçäººã»æ¥ä»ããšã®åºå€ã»éå€ã»å€å€ã»äžåšãCSVã«æžãåºããŸãã
- æ åœè ã確èªããŠåæ ãèŠç¢ºèªãã®è¡ã ã確èªãã絊äžã·ã¹ãã ã«åã蟌ã¿ãŸãã
æºåãããã®
- ã¯ãŒã¯ã¹ããŒã¹ã®ãªãŒããŒã»ç®¡çè ã ç°å¢èšå® ⺠管çè èšå® ⺠ãå€éšé£æºããŒã ã§ããŒã1ã€äœæããŸãã
- èªã¿åãé
ç®ã¯
members:readãšattendances:readã®2ã€ã§ååã§ããäžèŠãªé ç®ã¯ãªã³ã«ããŸããã - ããŒã®åæã¯äœææã«äžåºŠã ã衚瀺ãããŸããã¹ã¯ãªããã«æžããããµãŒããŒã®ç°å¢å€æ°ïŒäŸïŒ
JC_API_KEYïŒã«å ¥ããŠãããŸãã
ååŸã§ããå€
| å€ | æå³ | 絊äžåŽã§ã®äœ¿ãæ¹ïŒäŸïŒ |
|---|---|---|
account | ãã°ã€ã³ã¢ã«ãŠã³ãïŒ/membersïŒ | 絊äžã·ã¹ãã ã®åŸæ¥å¡ãšç §åããã㌠|
clockIn · clockOut | åºå€ã»é倿å»ïŒéåœæšæºæ KSTã»UTC+9ãISO-8601ïŒ | å€åæ¥ã»æ»åšæéã®èšç® |
outside | ãã®æ¥ãå€å€äžãã ã£ãæéïŒHH:mmïŒ | å€å€æåœã»åºåŒµã®ç¢ºèª |
missed | ãã®æ¥ãäžåšäžãã ã£ãæéïŒHH:mmïŒ | å€åæéã®ç¢ºèª |
ãµã³ãã«ã¹ã¯ãªãã
Python 3.11以äžãæšæºã©ã€ãã©ãªã®ã¿äœ¿ããŸããå®è¡æ¥ãåºæºã«åæ1æ¥ããæ«æ¥ãŸã§ãååŸããattendance-YYYY-MM.csv ãäœæããŸãã
import csv, datetime as dt, json, os, urllib.parse, urllib.request
BASE = "https://<å°å
¥ãã¡ã€ã³>/serv/api/external/v1"
KEY = os.environ["JC_API_KEY"] # ããŒã¯ã³ãŒãã«æžããç°å¢å€æ°ã«
def get_all(path, params):
"""ããŒãžãæåŸãŸã§ããããdata ã1ä»¶ãã€è¿ãã"""
params = {**params, "limit": 200}
while True:
url = f"{BASE}{path}?{urllib.parse.urlencode(params)}"
req = urllib.request.Request(url, headers={"X-API-Key": KEY})
with urllib.request.urlopen(req, timeout=30) as res:
body = json.load(res)
yield from body["data"]
if not body["meta"]["hasMore"]:
return
params["cursor"] = body["meta"]["cursor"]
last = dt.date.today().replace(day=1) - dt.timedelta(days=1) # åæã®æ«æ¥
first = last.replace(day=1)
account = {m["memberSeq"]: m["account"] for m in get_all("/members", {})}
seen = set()
with open(f"attendance-{first:%Y-%m}.csv", "w", newline="", encoding="utf-8-sig") as f:
w = csv.writer(f)
w.writerow(["ã¢ã«ãŠã³ã", "åå", "æ¥ä»", "åºå€", "éå€", "æ»åš(å)", "å€å€", "äžåš", "èŠç¢ºèª"])
for a in get_all("/attendances", {"from": first.isoformat(), "to": last.isoformat()}):
if a["attendanceSeq"] in seen: # ããŒãžããããéã«éè€ããè¡
continue
seen.add(a["attendanceSeq"])
cin = dt.datetime.fromisoformat(a["clockIn"])
cout = dt.datetime.fromisoformat(a["clockOut"]) if "clockOut" in a else None
stay = int((cout - cin).total_seconds() // 60) if cout else ""
acct = account.get(a["memberSeq"], "")
why = "éå€èšé²ãªã" if not cout else ("ã¡ã³ããŒäžèЧã«ãªã" if not acct else "")
w.writerow([acct, a["memberName"], f"{cin:%Y-%m-%d}", f"{cin:%H:%M}",
f"{cout:%H:%M}" if cout else "", stay, a["outside"], a["missed"], why])ã¢ã«ãŠã³ã,åå,æ¥ä»,åºå€,éå€,æ»åš(å),å€å€,äžåš,èŠç¢ºèª
gildong.hong@example.com,ã®ã«ãã³,2026-10-19,08:57,18:03,546,01:20,00:00,
chulsoo.kim@example.com,ãã§ã«ã¹,2026-10-19,09:04,,,00:00,00:00,éå€èšé²ãªã0 4 3 * * cd /opt/jc-payroll && JC_API_KEY=... python3 export_attendance.py1ããŒãžã§æå€§200è¡ãååŸãããããããšãã°ã¡ã³ããŒ100人ã22æ¥å€åããæïŒ2,200è¡ïŒã¯ã倿 11åïŒã¡ã³ããŒ1åã®åŒã³åºãã§çµãããŸããããŒãããæ¯å60åã®äžéã«åååãŸããŸãã
ç¥ã£ãŠããããš
- æ»åšæéã¯åŽåæéãšã¯ç°ãªããŸããäŒæ©æéã®æ§é€ãæéå€ã»æ·±å€ã»äŒæ¥ã®å²å¢ãäŒæã¯ãã®APIã§ã¯æäŸããŸãããäŒç€Ÿã®èŠåã«æ²¿ã£ãèšç®ã¯çµŠäžã·ã¹ãã ã§è¡ããŸãã
- åºå€èšé²ãããæ¥ã ããè¿ããŸããæ¬ å€ã»äŒæãªã©åºå€ãæå»ããŠããªãæ¥ã¯äžèЧã«ãããŸããã
- 管çè ãä¿®æ£ããåºå€æå»ã¯ä¿®æ£åŸã®å€ã§è¿ããŸãã倿 ã®ç· ããçµãã£ãåŸïŒäžã®äŸã®ããã«æ¯æ3æ¥ïŒã«å®è¡ããã°ä¿®æ£å 容ãŸã§åæ ãããŸãã
- ã¡ã³ããŒäžèЧããå€ãã人ïŒéäŒãªã©ïŒã®èšé²ã¯ã¢ã«ãŠã³ãæ¬ã空ã«ãªãããèŠç¢ºèªããšè¡šç€ºãããŸãã
- èªã¿åãã ããªã®ã§ãäœåºŠå®è¡ãçŽããŠãteamsideã®ããŒã¿ã¯å€ãããŸããã倱æããããšã©ãŒã確èªããŠåå®è¡ããŠãã ããã
- 倿 ã®åèïŒã¡ã¢ïŒã¯å人æ å ±ãå«ãŸããå¯èœæ§ããããããAPIã§ã¯åºåããŸããã
決è£éç¥ãTeamsã»Slackã®ãã£ã³ãã«ãž
ãã£ããã¯TeamsãSlackãæ±ºè£ã¯teamsideã§è¡ã£ãŠããäŒç€Ÿãªããæ±ºè£äŸé ŒãèŠéããªãããããŒã ã®ãã£ã³ãã«ã«1è¡ã®éç¥ãæµããŸããéçºã¯äžèŠã§ã管çè ã®èšå®ã ãã§ã§ããŸãã
ãã£ã³ãã«ã«ã¯ãã衚瀺ãããŸã
ç»é¢äŸã§ãããã£ã³ãã«åã»æå»ã»ææžã¿ã€ãã«ã¯ãµã³ãã«ããŒã¿ã§ãæã®åœ¢ã¯å®éãšåãã§ããéç¥ã®æã¯çŸåšãéåœèªã§éä¿¡ãããŸãã
èšå®æé
- ãã£ã³ãã«ã®URLãäœæSlackã¯ãIncoming Webhooksãã§ãã£ã³ãã«ãéžã³ãTeamsã¯ãã£ã³ãã«ã®ãã¯ãŒã¯ãããŒããããWebhook èŠæ±ãåä¿¡ãããšãã«ãã£ãã«ã«æçš¿ãããã§URLãäœæããŸãã
- éä¿¡å ãç»é²ç°å¢èšå® ⺠管çè èšå®ã¿ãã®ãéç¥ã®å€éšéä¿¡ãã«URLã貌ãä»ããŸããSlackã»Teamsã¯URLããèªåã§å€å¥ãããŸãã
- ç¯å²ã»éç¥ãéžã¶ç¯å²ïŒãå šäœããŸãã¯ã決è£ãã©ãŒã ãïŒãšéãæ±ºè£éç¥ãéžã³ãŸãã
- ãã¹ãããŠä¿åããã¹ãéä¿¡ãã§ãã£ã³ãã«ã«ãã¹ãã¡ãã»ãŒãžãå±ãããšã確èªããŠä¿åããŸãã
æ§æäŸ
éä¿¡å ã¯ã¯ãŒã¯ã¹ããŒã¹ããšã«20ãæãŸã§ç»é²ã§ããã®ã§ããã£ã³ãã«ããšã«ç¯å²ãšéç¥ãå€ããããŸãã
| ãã£ã³ãã«ïŒäŸïŒ | ç¯å² | éãéç¥ | ã¿ã€ãã« |
|---|---|---|---|
| #決è£éç¥ | å šäœ | 決è£äŸé Œ approval.requested決è£ã®é çª approval.forwardedæééè¿ approval.due | 衚瀺 |
| #çµçããŒã | 決è£ãã©ãŒã ïŒçµè²»ç³è«æž | æ¿èª approval.approvedå·®ãæ»ã approval.rejected | é衚瀺 |
決è£éç¥ã¯äŸé Œã»é çªã»åç §ã»æ¿èªã»å·®ãæ»ãã»åãäžãã»åãæ¶ãã»åé€ã»ã³ã¡ã³ãã»æééè¿ã®10çš®é¡ã§ãã倿 ïŒé±52æéã®æ¥è¿ã»è¶ éïŒã»äŒè°ã»ãªãœãŒã¹äºçŽã»æ²ç€ºæ¿ã»ã¢ã³ã±ãŒãã®éç¥ãåãç»é¢ã§éžã¹ãŸããäžèЧã¯ãªãã¡ã¬ã³ã¹11ç« ã«ãããŸãã
ç¥ã£ãŠããããš
- èšå®ã§ããã®ã¯ãªãŒããŒã»ç®¡çè ã®ã¿ã§ãã
- 1è¡ã®éç¥ã«ã¯èª°ã®é çªãã¯å«ãŸããŸãããããŒã ã»ãã©ãŒã ããšã«ãã£ã³ãã«ãåãããšãåãåã人ãæç¢ºã«ãªããŸãã
- ãã£ã³ãã«ã®URLãç¥ã£ãŠãã人ã¯èª°ã§ããã®ãã£ã³ãã«ã«æçš¿ã§ããŸããURLã¯å€éšã«å ±æããªãã§ãã ããã
- éä¿¡ã«å€±æãããšãééãåºããªããåèš5åãŸã§è©Šã¿ãŸããé£ç¶ã§å€±æããŠãèªåã§ã¯ãªãã«ãªããªããããç»é¢ã®ç¶æ ããšãã©ã確èªããŠãã ããã
- ã¹ã€ããããªãã«ããŠããéã®éç¥ã¯èç©ãããããªã³ã«æ»ããåŸã®éç¥ããéãããŸãã
- Teamsã®ä»¥åã®ãã³ãã¯ã¿ãæ¹åŒã®URLã¯TeamsåŽã§å»æ¢ãããŸãããæ°ããURLã¯ãã¯ãŒã¯ãããŒãã§äœæããŠãã ããã
- èªç€ŸãµãŒããŒã§åãåã£ãŠåŠçããå Žåã¯ãäžè¬ã®JSONã®URLãç»é²ãã
X-JC-Signature眲åãæ€èšŒããŸãïŒãªãã¡ã¬ã³ã¹11ç« ïŒã - ãªã³ãã¬ãã¹çã§ã¯ãteamsideã®ãµãŒããŒãSlackã»Teamsã®URLãžã€ã³ã¿ãŒãããæ¥ç¶ã§ããå¿ èŠããããŸãã瀟å ã§å€éšæ¥ç¶ãå¶éããŠããå Žåã¯ããã®ã¢ãã¬ã¹ã ããèš±å¯ããŠãã ããã
AIã«è©±ããããŠå€æ ã»çµç¹ã®ç¶æ³ã確èª
ããã€ãã®ç»é¢ãéããŠè¡šãçªãåããã代ããã«ãAIã®ãã£ããã§ã仿¥ãŸã åºå€èšé²ããªã人ã¯ïŒããšå°ãããšãAIãteamsideã®ããŒã¿ãèªãã§çããŸããèªã¿åãã®ã¿ã§ãããŒã¿ã¯å€æŽããŸããã
list_memberslist_attendances · from=to=仿¥- ãŸã èšé²ãªãïŒã€ããããã§ãã
- åºå€åŸã«å€å€äžïŒãã ããïŒæ¬æ¥ã®å€å€ 01:10ïŒ
list_attendances · å
æ1æ¥ãæ«æ¥èª¬æçšã®äŒè©±äŸã§ãïŒå®éã®é¡§å®¢ããŒã¿ãšã¯ç¡é¢ä¿ã§ãïŒãã©ã®ããŒã«ãåŒã¶ãã¯ã質åã«å¿ããŠAIãéžã³ãŸãã
2ã€ã®æ¥ç¶æ¹æ³
ãAIãµãŒãã¹ã®é£æºãâ ã¡ã³ããŒåèª
Claude.aiãªã©AIãµãŒãã¹ã®Webç»é¢ããã³ãã¯ã¿ã§æ¥ç¶ · éçºäžèŠ
- æ¥ç¶ãããã®äººã®æš©éã§èªã¿åããŸããã¢ããªã§èŠãããªããã®ã¯AIãèŠãããŸããã
- ã¡ã³ããŒã»ã¹ããŒã¹ïŒéšçœ²ïŒäžèЧãèš±å¯ããå Žåã¯åºéå€èšé²
- 管çè
ããªã³ã«ãããšïŒã¿ã¹ã¯
list_my_tasks· 決è£äžèЧlist_approvals· é£çµ¡å list_contacts· å šç€Ÿæ²ç€ºæ¿list_board_posts - ã¡ã³ããŒã®ã¡ãŒã«ã¢ãã¬ã¹ã¯æž¡ããŸããã
APIã㌠â äŒç€Ÿåäœ
Claude Codeã»Claude APIã»OpenAI APIã»Gemini CLIã»Cursorãªã©ã«URLãšããŒãèšå®ããŠæ¥ç¶
- äºäŸ01ãšåããå€éšé£æºããŒãã䜿ããŸããããŒã§ãªã³ã«ããé ç®ã ããããŒã«ãšããŠè¡šç€ºãããŸãã
- ã¡ã³ããŒ
list_members· ã¹ããŒã¹list_spaces·get_space· 倿list_attendances - äŒç€Ÿå šäœãèªã¿åãããã瀟å ã®åæã»ã¬ããŒãèªååã«åããŠããŸããããŒæ¥ç¶ã§ã¯ã¡ã³ããŒäžèЧã«ãã°ã€ã³ã¢ã«ãŠã³ããå«ãŸããŸãã
æ¥ç¶æé
ãAIãµãŒãã¹ã®é£æºã
- 管çè ããªã³ã«ããç°å¢èšå® ⺠管çè èšå®ã¿ãã®ãAIãµãŒãã¹é£æºïŒäŒç€Ÿèšå®ïŒãã§ãªã³ã«ããèš±å¯ããAIãµãŒãã¹ã»åºéå€èšé²ã®èš±å¯ã»èªããé ç®ãéžã³ãŸãããªã³ã«ããéãæž¡ãæ å ±ãããäžåºŠç¢ºèªããŸãã
- URLãæ¡å åãã«ãŒãã®ãã¡ã³ããŒåã â ã³ãã¯ã¿ã®URLããã³ããŒããŠã¡ã³ããŒã«ç¥ãããŸãã
- ã¡ã³ããŒãæ¥ç¶AIãµãŒãã¹ã®ã³ãã¯ã¿è¿œå ç»é¢ïŒClaude.aiã§ã¯ãã«ã¹ã¿ã ã³ãã¯ã¿ãïŒã«URLãå ¥åããteamsideã®ã¢ã«ãŠã³ãã§ãã°ã€ã³ããŸãã
- åæç»é¢ã§èš±å¯æ¥ç¶ããã¯ãŒã¯ã¹ããŒã¹ãšèªã¿åãæ å ±ã確èªãããèš±å¯ããæŒããŸãã
ãªã³ãã¬ãã¹çã§ã¯ãã®æ©èœã¯åæç¶æ ã§ãªãã§ããªã³ã«ãããã©ããã¯äŒç€Ÿã決ããŸããAIãµãŒãã¹ã®Webç»é¢ããæ¥ç¶ããã«ã¯ãteamsideã®ãµãŒããŒã®ã¢ãã¬ã¹ã«ã€ã³ã¿ãŒãããããå°éã§ããå¿ èŠããããŸãã瀟å ãããã¯ãŒã¯å°çšã®ãµãŒããŒãªããäžã®APIããŒã®æ¹æ³ãã䜿ããã ããã
APIããŒïŒäŸïŒClaude CodeïŒ
claude mcp add --transport http teamside https://<å°å
¥ãã¡ã€ã³>/serv/api/external/v1/mcp \
--header "Authorization: Bearer ${JC_API_KEY}"ã»ãã®ããŒã«ã®æ¥ç¶æ¹æ³ãšMCPã®ã«ãŒã«ã¯ãªãã¡ã¬ã³ã¹12ç« ã«ãããŸãã
å®å¿ã®ããã¿
| å¿é | ããã¿ |
|---|---|
| AIãããŒã¿ãå€ããªãã | ãã®äºäŸã®ããŒã«ã¯ãã¹ãŠèªã¿åãå°çšã§ããç»é²ã»ä¿®æ£ã»åé€ã®ããŒã«ã¯ãããŸããã |
| èŠãŠã¯ãããªããã®ãèŠãªãã | ãAIãµãŒãã¹ã®é£æºãã¯æ¥ç¶ããäººã®æš©éã®ãŸãŸå€å®ããŸããæ±ºè£äžèŠ§ã¯æ¬æã»æ·»ä»ã»éé¡ãæž¡ããããã»ãã¥ãªãã£ãè¡šç€ºã®ææžã¯ããããåºãŠããŸãããé£çµ¡å ã¯ã¡ãŒã«ã»äœæãæž¡ããŸããã |
| æ¥ç¶ãæ®ãç¶ããªãã | 30æ¥é䜿ããªãã90æ¥ãéãããšåãããã¹ã¯ãŒããå€ããŠãåããŸããã¡ã³ããŒã¯ã飿ºäžã®AIãµãŒãã¹ãã管çè ã¯ãAI飿ºã®ç®¡çãã§æ¥ç¶ãšçŽè¿30æ¥ã®åŒã³åºãèšé²ã確èªããããã«è§£é€ã§ããŸãã |
| 誰ããåæã«æ¥ç¶ããªãã | æ¥ç¶ã¯æ¬äººããã°ã€ã³ããŠãèš±å¯ããæŒãããšãã ãäœããã管çè ãèš±å¯ããAIãµãŒãã¹ã ããæ¥ç¶ã§ããŸãã |
AIããŒã«ã§èªã¿åã£ãæ å ±ã¯ãã®AIãµãŒãã¹ã®éå¶äŒç€Ÿã«æž¡ã£ãŠåŠçãããŸãããªã³ã«ããåã«ã瀟å ã®å人æ å ±ã®åãæ±ãåºæºïŒã¡ã³ããŒãžã®æ¡å ã»åæãå§èšå¥çŽãªã©ïŒã確èªããŠãã ããã
ããã«è©³ãã
- å ¬éAPIãªãã¡ã¬ã³ã¹ â ãšã³ããã€ã³ãããšã®ãã©ã¡ãŒã¿ã»ã¬ã¹ãã³ã¹ã»ãšã©ãŒã³ãŒãã»Webhookçœ²åæ€èšŒ
èªç€Ÿã·ã¹ãã ãšã®é£æºæ¹æ³ã«ã€ããŠããæ°è»œã«ãåãåãããã ããã
飿ºã®ãåãåããæçµæŽæ° 2026-11-07 · API v1