kintone Café 福岡 Vol.3（kintone JavaScriptカスタマイズ・kintone.proxy()/SendGrid）

LJOUPOF$BGÉ෱Ԭ7PM ೥݄೔ LJOUPOFެೝΤόϯδΣϦετɹࢁԼཽ ˌLJOUPOFDBGF 5XJUUFS!ZBNBSZV '#IUUQTXXXGBDFCPPLDPNSZVZBNBTIJUB #MPHIUUQZBNBSZVIBUFOBCMPHDPN

ࣗݾ঺հ • جຊ৘ใ •ࢁԼ ཽʢ32ʣɹ෱Ԭݝେໂాࢢग़਎ • ࠷ઌ୺ͷແઢ௨৴͕΍Γ্ͨͯ͘ژʢֶੜ'05-06ʣ •ϚϧνϗοϓɺࠓͷSC-FDMAʹྨ͢Δ΋ͷʹۤઓʢ৴߸ॲཧத৺ʣ • ަ௨ࠞࡶͱۭؾ؀ڥʹ଱͑ΒΕͦ͏ʹͳ͘ɺUλʔϯʢ۝भిྗͷ௨৴෦໳'07-10ʣ
•௨৴γεςϜͷ޻ࣄ౳Λ3೥ؒʢઢ࿏/఻ަɺ཮ٕɺCCNP/DP→έʔϒϧɺిݯɺ ఻ૹަ׵ɾIP౳ʣ • M2MαʔϏεԽͷͨΊͷࣄۀ෦໳ʢχγϜͷαʔϏε෦໳'10-14.7ʣ •اըɾӦۀ͕ϝΠϯʢ͜Εେ੾ʣ • ͱͷग़ձ͍Λ͖͔͚ͬʹٕज़ࢧԉ΋ • ޫϑΝΠό৺ઢି͠ࣄۀΛߦ͏ݱ෦ॺ΁ʢ۝भిྗ௨৴෦໳'14.8-ݱࡏʣ • Ӧۀɾࣄۀ؅ཧɺܦӦࢿݯ౷߹ʹ൐͏ࣄۀҠ؅ Layer1 Layer1-3 Layer8? Layer1-8

ࣗݾ঺հ LJOUPOF$BGÉ෱Ԭ7PM LJOUPOF$BGÉ෱Ԭ7PM LJOUPOF$BGÉ7PMʙͷओ࠵ ˞։࠵ϨϙʔτIUUQZBNBSZVIBUFOBCMPHDPNBSDIJWFDBUFHPSZLJOUPOF$BG$"

w ͸͡Ίʹ w LJOUPOFͱ͸ʁαΠϘ΢ζͷΫϥ΢υࣄۀ΁ͷऔΓ૊ΈʢαΠϘ΢ζࠤ౻͞·ʣ w ͜ΜͳҊ݅ͰLJOUPOFಋೖ͖ͯ͠·ͨ͠ʂʢ"*4*$ٱถ͞·ʣ w ׬શఆֹʂLJOUPOF͔ͩΒͰ͖Δ৽͍͠4*ϏδωεʢδϣΠκʔ࢛ٶ͞·ʣ w LJOUPOF+BWB4DSJQUΧελϚΠζϋϯζΦϯʢࢁԼʣ
w 3VCZ༻3&45"1*ΫϥΠΞϯτͷ঺հʢχγϜిࢠ޻ۀ઒্͞·ʣ .FOVGPSUPEBZ

͸͡Ίʹ

LJOUPOFͱ͸ʁ

w ίϯηϓτ wʮϑΝετγεςϜʯ wʮ෼Ͱۀ຿վળΞϓϦʯ w ߏ੒ཁૉ wσʔλ wϫʔΫϑϩʔ wίϛϡχέʔγϣϯ LJOUPOFجຊ֓ཁ
ʮαΠϘ΢ζϓϩμΫτνʔϜΛڧ͘͢Δπʔϧʯ ͷதͰ΋൚༻ੑͱઐ໳ੑΛߦ͖དྷ͠ͳ͕Βɺ༷ʑͳ ۀ຿γʔϯͰ׆༻ग़དྷΔΫϥ΢υσʔλϕʔε ʢ8FC%#ʣαʔϏε ʢग़యɿʮLJOUPOFެࣜαΠτʯʣ

w 3&45"1* w Ϩίʔυ΍εϖʔεͷૢ࡞ʢొ࿥ɾߋ৽ɾ࡟আ౳ʣɺ όϧΫ"1* w Ϣʔβɾ૊৫ͷૢ࡞ w +BWB4DSJQU$44ΧελϚΠζ w
֤छΠϕϯτϋϯυϧɺ৘ใऔಘ w ϓϩΩγʹΑΔ֎෦"1*࿈ܞ w 63-ࢦఆʹΑΔϥΠϒϥϦͷಡΈࠐΈʢ)5514ରԠʣ LJOUPOFΧελϚΠζػೳʢελϯμʔυίʔεʣ σʔλ Ϩίʔυ εϖʔε Ϣʔβ 6* جװγεςϜ Excel ଞͷΫϥ΢υ REST API LJOUPOFQSPYZ

࠷ۙͷLJOUPOFಈ޲

*5QSP&910 ʮ*51SP&910"8"3%ʯͰ ʮ;%/FU+BQBO৆ʯΛड৆ ෼ͰΞϓϦ։ൃͰ͖Δ ૬ஊίʔφʔ ஍ਤͱσʔλͷ"1*ΛLJOUPOFͰ ϚογϡΞοϓͨ͠σϞ ʢग़యɿʮ*5QSPCZ೔ܦίϯϐϡʔλʯهࣄʣ

ʮDZCP[VDPNEFWFMPQFSOFUXPSLʯͱʮLJOUPOF$BGFʯ ʢग़యɿʮαΠϘ΢ζϓϨεϦϦʔεʯʣ ։ൃίϛϡχςΟαΠτʮDZCP[VDPNEFWFMPQFS OFUXPSLʯͷొ࿥ϝϯόʔ਺͕ *%Λಥഁ LJOUPOF༗ࢤษڧձʮLJOUPOF$BGÉʯ͕ શࠃͰճ։࠵ɺԆ΂ਓࢀՃ ʢҾ༻ɾը૾ఏڙɿLJOUPOF$BGÉ·ͱΊ IUUQSBEJDBMCSJEHFDPNLJOUPOFCMPHLJOUPOF$BGF@NBUPNFIUNMʣ

LJOUPOFͷ +BWB4DSJQUΧελϚΠζ

αʔόΛ४උ͠ͳͯ͘΋Ͱ͖Δ LJOUPOFͷ+BWB4DSJQUΧελϚΠζ ·ͣ͸ɹɹ ͓͞Β͍

+BWB4DSJQUΧελϚΠζ ଞαʔϏεΛऔࠐΈͭͭɺ ಈըΛϒΫϚͨ͠Γ σʔλΛόΠϯυͯ͠ ϥΠϒϥϦͰάϥϑԽ͠௚ͨ͠Γ μΠφϛοΫͳϓϥάΠϯϥΠϒϥϦͰ ݟͨ໨ΛΦγϟϨʹͨ͠Γ

+BWB4DSJQUΧελϚΠζ [subdomain] ϞόΠϧͷརศੑΛ޲্ͤ͞Δ ஍ਤΛར༻ͨ͠Γ

+BWB4DSJQU$44ΧελϚΠζ σʔλΛόΠϯυͯ͠ɺ$44ϑϨʔϜϫʔΫ Ͱࣾ಺$.4ɾϙʔλϧʹͯ͠ΈͨΓ

LJOUPOF+BWB4DSJQU ΧελϚΠζͷՄೳੑΛߋʹ޿͛Δ

޽ͷαʔϏεͱ࿈ܞͯ͠ΞϓϦ࡞Γ͍ͨ࣌͋Γ·ͤΜ͔ʁ ϝʔϧ ి࿩4.4 Πϕϯτπʔϧ ʢ؀ڥʣσʔλ ిࢠձܭ ίϥϘϨʔγϣϯπʔϧ ݱࡏ."΋ ։࠵தͰ͢Ͷʂ

LJOUPOFQSPYZ ͕ࠓ೤͍ʂ ͦΜͳࢥ͍ΛαʔόϨε Ͱ׎͑ͯ͘ΕΔ ʮLJOUPOF$BGFদࢁʯͰ͸σϞ͚ͩͰ͕ͨ͠ɺ ࠓ೔͸࣮ફ͍͖ͯ͠·͠ΐ͏ʂ

جૅ஌ࣝ

LJOUPOFQSPYZ ʹ͓͚Δ1045165ͷϙΠϯτ ߲໨ ϑΥʔϜܗࣜσʔλ +40/ܗࣜσʔλ ϦΫΤετϔομ .*.&λΠϓ $POUFOU5ZQFBQQMJDBUJPOYXXXGPSN VSMFODPEFE $POUFOU5ZQFBQQMJDBUJPO
KTPO ϦΫΤετϘσΟ هࡌํ๏ \LFZ^\WBMVF^\LFZ^\WBMVF^ ʢจࣈྻʣ ˞\WBMVF^͸63-Τϯίʔυ +40/ ʢจࣈྻɺΦϒδΣΫτʣ αʔϏεྫ 5XJMJPɺ4FOE(SJEɺ5ZQFUBML LJOUPOFɺ4RVBSFɺYJWFMZ ˞(&5ͷϨεϙϯε͸ຆͲ͕+40/

DVSMίϚϯυͱLJOUPOFQSPYZ ͷରԠؔ܎ ʢग़యɿʮLJOUPOFϚογϡΞοϓͷͨΊͷ౾஌ࣝʢDVSMίϚϯυͱLJOUPOFQSPYZ ͷରԠʣʯʣ

ϦΫΤετ63- DVSMίϚϯυͰ͸ਖ਼ຯͷҾ਺ʹͳΓ·͢ͷͰɺίϚϯυΦϓγϣϯ͸͋Γ·ͤΜɻ ϦΫΤετϝιου (&5ɺ1045ɺ165ɺ%&-&5&ͷ͍ͣΕ͔ΛࢦఆͰ͖·͢ɻ ϦΫΤετϔομ ෳ਺ࢦఆ͢Δඞཁ͕͋Δͱ͖ʹ͸ɺDVSMίϚϯυͰ͸ʮ) \IFBEFS,FZ^\IFBEFS7BMVF^ʯΛηοτͱͯ͠ɺඞཁ਺ॻ͖ฒ΂ΒΕ·͢ɻ
LJOUPOFQSPYZ Ͱ͸ʮ\\IFBEFS,FZ^\IFBEFS7BMVF^ \IFBEFS,FZ^\IFBEFS7BMVF^ ɾɾɾ^ʯͱ͍ͬͨΑ͏ʹίϯϚͰඞཁ਺Λ࿈݁͠ ͍ͯͩ͘͞ɻ DVSMίϚϯυͱLJOUPOFQSPYZ ͷରԠؔ܎ ʢग़యɿʮLJOUPOFϚογϡΞοϓͷͨΊͷ౾஌ࣝʢDVSMίϚϯυͱLJOUPOFQSPYZ ͷରԠʣʯʣ

ϦΫΤετσʔλ ϑΥʔϜܗࣜ DVSMίϚϯυͰʮEʯͷΦϓγϣϯͰ͸௨ৗϑΥʔϜܗࣜσʔλΛݴ͓ͬͯΓɺରԠ͢Δ $POUFOU5ZQF͸ʮBQQMJDBUJPOYXXXGPSNVSMFODPEFEʯͱͯ͠ॲཧ͞Ε͍ͯ·͢ʢʮ )ʯͰͷ໌ࣔෆཁʣͷͰɺLJOUPOFQSPYZ Ͱ͸͜ΕΛϔομʹ௥Ճ͓ͯ͘͠ͱྑ͍Ͱ͢ɻ ෳ਺ࢦఆ͢Δඞཁ͕͋Δͱ͖ʹ͸ɺDVSMίϚϯυͰ͸ʮE\LFZ^\WBMVF^ʯΛηοτͱ͠ ͯɺඞཁ਺ॻ͖ฒ΂ΒΕ·͢ɻLJOUPOFQSPYZ
Ͱ͸ɺ ʮ\LFZ^\WBMVF^\LFZ^\WBMVF^ɾɾɾʯͱ͍ͬͨΑ͏ʹʮʯͰඞཁ਺࿈݁ͯ͠ ͍ͩ͘͞ɻ DVSMίϚϯυͰ͸\WBMVF^෦෼Λ63-ΤϯίʔυԽ͢ΔʮEBUBVSMFODPEFʯͱ͍ͬͨΦ ϓγϣϯ͕࢖ΘΕΔ͜ͱ͕͋Γ·͕͢ɺ͜ΕʹରԠ͢ΔͨΊʹ͸LJOUPOFQSPYZ Ͱ͸ɺ +BWB4DSJQUதͰʮFODPEF63*$PNQPOFOU \WBMVF^ ʯΛܦ༝͓ͤͯ͘͞ͱྑ͍Ͱ͢ɻ DVSMίϚϯυͱLJOUPOFQSPYZ ͷରԠؔ܎ ʢग़యɿʮLJOUPOFϚογϡΞοϓͷͨΊͷ౾஌ࣝʢDVSMίϚϯυͱLJOUPOFQSPYZ ͷରԠʣʯʣ

ϦΫΤετσʔλ +40/ܗࣜ DVSMίϚϯυͰʮEʯͷΦϓγϣϯ͸+40/ܗࣜͷσʔλʹ΋ରԠ͍ͯ͠·͢ɻͨͩɺઌ΄ͲͷϑΥʔ ϜܗࣜͱҟͳΓɺରԠ͢Δ$POUFOU5ZQFͰ͋ΔʮBQQMJDBUJPOKTPOʯ͸DVSMίϚϯυͰ΋ʮ)ʯʹΑͬ ͯ໌ࣔ͞ΕΔ͜ͱʹͳΓ·͢ɻҰํɺLJOUPOFQSPYZ Ͱ΋͜ΕΛϔομʹ௥Ճ͓ͯ͘͠ඞཁ͕͋Γ·͢ DVSMίϚϯυͰ͸ʮ+40/จࣈྻʯͰ͔͠ࢦఆͷ͠Α͏͕͋Γ·ͤΜ͕ɺLJOUPOFQSPYZ Ͱ͸ɺ
ʮ+40/จࣈྻʯͰ΋ʮ+40/ΦϒδΣΫτʯͰ΋େৎ෉Ͱ͢ɻ #BTJDೝূ DVSMίϚϯυͰʮVʯͷΦϓγϣϯ͸#BTJDೝূʹ༻͍ΒΕ͍ͯ·͢ɻ͜ΕΛLJOUPOFQSPYZ ͰରԠ ͤ͞Δʹ͸ɺϔομͷํʹʮ"VUIPSJ[BUJPO#BTJD\#BTJD5PLFO^ʯͱ͍ͬͨ۩߹ʹ௥Ճͯ͋͛͠Δ ͜ͱͰղܾ͞Ε·͢ɻͳ͓ɺʮ\#BTJD5PLFO^ʯ͸ʮ\JE^\QBTTXPSE^ʯΛ#"4&Τϯίʔυͨ͠΋ͷ ͱͳΓ·͢ɻ ଞʹɺ63-෦෼ʹ࿈݁ͯ͠ʮ\JE^\QBTTXPSE^!63-ʯͱॻ͘ํ๏΋͋Γ·͢ɻ DVSMίϚϯυͱLJOUPOFQSPYZ ͷରԠؔ܎ ʢग़యɿʮLJOUPOFϚογϡΞοϓͷͨΊͷ౾஌ࣝʢDVSMίϚϯυͱLJOUPOFQSPYZ ͷରԠʣʯʣ

ϋϯζΦϯ

ʮి࿩ϝϞʯΛLJOUPOFΞϓϦͰ࡞Δ ʮ(BSPPOʯ΍ ʮαΠϘ΢ζ0⒏DFʯ ͷʮి࿩ϝϞʯΛ ʮLJOUPOFʯͰ΋ʂ

ίϛϡχςΟ΁ͷ໰͍߹Θͤ ΋ଟ͍Ͱ͢Ͷʂ

LJOUPOFQSPYZ Ͱϝʔϧ"1*࿈ܞ ᶃLJOUPOFQSPYZ Ͱ 4FOE(SJEͷϝʔϧૹ৴ "1*Λୟ͘ ʮి࿩ϝϞʯΞϓϦ ϝʔϧ"1* αʔϏε ᶄొ࿥৘ใΛݩʹϝʔϧૹ৴
ϝʔϧͷѼઌ

ΞϓϦͷؔ܎ੑ ϧοΫΞοϓ ࣾһ໊฽ ి࿩ϝϞ ϝʔϧૹ৴ "1*Λ࢖͍෼͚ͯɺϝʔϧɾԻ੠ϝοηʔδɾ4.4౳ ϝσΟΞΛબ୒͢ΔΑ͏ʹ͢Δͷ΋ྑͦ͞͏Ͱ͢ʂ

αϯϓϧμ΢ϯϩʔυ ᶃʮIUUQTHJUIVCDPNZBNBSZV LJOUPOF$BGF'VLVPLBʯʹΞΫηε ᶄʮ%PXOMPBE;*1ʯΛΫϦοΫͯ͠ɺ ϑΝΠϧҰࣜΛμ΢ϯϩʔυ

LJOUPOFΞϓϦ ϑΥʔϜ߲໨ ϑΟʔϧυͷछྨ ࣾһ൪߸ จࣈྻʢߦʣ ࢯ໊ จࣈྻʢߦʣ ;Γ͕ͳ จࣈྻʢߦʣ ੑผ
ϥδΦϘλϯ ੜ೥݄೔ ೔෇ ೖࣾ೥݄೔ ೔෇ ༣ศ൪߸ จࣈྻʢߦʣ ॅॴ จࣈྻʢߦʣ 5&- ϦϯΫ ϝʔϧΞυϨε ϦϯΫ ϑΥʔϜ߲໨ ϑΟʔϧυͷछྨ ϑΟʔϧυίʔυ ࢯ໊ ϧοΫΞοϓ OBNF ϝʔϧΞυϨε ϦϯΫ ʢϧοΫΞοϓʣ UP λΠτϧ จࣈྻʢߦʣ UJUMF ϝοηʔδ จࣈྻʢෳ਺ߦʣ UFYU ࣾһ໊฽ ి࿩ϝϞ ˞LJOUPOFΞϓϦετΞʮࣾһ໊฽ʯΞϓϦͷվ଄ ɹˠʮ5&-ʯͱʮϝʔϧΞυϨεʯΛϦϯΫϑΟʔϧυʹมߋ

ࠓճͷ+BWB4DSJQU෦෼ղઆ ύϥϝʔλͷઃఆ 4FOE(SJEͰ͸ɺ ɹᶃϢʔβʔ໊<"1*@64&3> ɹᶄ"1*Ωʔ<"1*@,&:> ɹᶅૹ৴ऀ໊<50@/".&> ɹᶆૹ৴ऀϝʔϧΞυϨε<'30.> Λઃఆ͓͖ͯ͠·͢ ʢࢀߟɿʮ4FOE(SJE"1*υΩϡϝϯτʯʣ Ұ෦Λࣄલʹ63-Τϯίʔυ

ࠓճͷ+BWB4DSJQU෦෼ղઆ 4FOE(SJE࿈ܞ෦෼ ϦΫΤετ63- ϔομͰϑΥʔϜܗࣜͷࢦఆ ϦΫΤετϘσΟ LJOUPOFQSPYZ

ࠓճͷ+BWB4DSJQU෦෼ղઆ ৄࡉը໘Πϕϯτ Ϩίʔυৄࡉը໘ʹ ʮϝʔϧૹ৴ʯϘλϯΛ௥Ճ

ࠓճͷ+BWB4DSJQU෦෼ղઆ $ISPNFͷ։ൃπʔϧʢ/FUXPSLʣ LJOUPOFQSPYZ ͷϦΫΤετ಺༰ ˞͜͜ͷ಺෦࢓༷͸มߋʹͳΔՄೳੑ͕͋Γ·͢ ϑΥʔϜܗࣜͷ ϘσΟ͸จࣈྻ

w LJOUPOFQSPYZ ͷهड़ํ๏ʢ)࣌఺ʣ w ϑΥʔϜܗࣜͷ1045165ϝιουͷهड़ํ๏ w .*.&λΠϓ͕BQQMJDBUJPOYXXXGPSNVSMFODPEFEͰ͸Ϙ σΟ͸จࣈྻѻ͍ͱͳΓɺ \LFZ^\WBMVF^\LFZ^\WBMVF^ͷΑ͏ͳهࡌ͕Մೳ w
.*.&λΠϓ͕NVMUJQBSUGPSNEBUBʢ+4Ͱ͸'PSN%BUBΦϒ δΣΫτʣͷϑΥʔϜܗࣜʹ͸ݱঢ়ରԠͳ͠ w ϘσΟ͸ૹ৴͞Εͳ͍(&5ϝιου ϙΠϯτ·ͱΊ

ϋϯζΦϯ͸Ҏ্Ͱ͢

w ։ൃίϛϡχςΟαΠτʮDZCP[VDPNEFWFMPQFSOFUXPSLʯ<IUUQT DZCP[VEFW[FOEFTLDPNIDKB> w ίϛϡχςΟʢ࣭໰౳ʣɺϦϑΝϨϯεɺ5JQTɺαϯϓϧɺ։ൃऀϥΠηϯεਃࠐ w 4FOE(SJE"1*υΩϡϝϯτ<IUUQTTFOEHSJEDPNEPDT"1*@3FGFSFODF 8FC@"1*NBJMIUNM> w ʮDZCP[VDPNEFWFMPQFSOFUXPSL5JQTLJOUPOF+BWB4DSJQU"1*LJOUPOFϚο
γϡΞοϓͷͨΊͷ౾஌ࣝʢDVSMίϚϯυͱLJOUPOFQSPYZ ͷରԠʣʯ<IUUQT DZCP[VEFW[FOEFTLDPNIDKBBSUJDMFT> w LJOUPOFQSPYZ Λ༻͍ͨ5XJMJP"1*࿈ܞαϯϓϧ༗ w ʮLJOUPOFͰֶͿ3&45"1*ͷϦΫΤετํ๏ʢςετʗσόά༻ʣʯ<IUUQ ZBNBSZVIBUFOBCMPHDPNFOUSZ> ࢀߟ৘ใ

͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠ɻ

kintone Café 福岡 Vol.3（kintone JavaScriptカスタマイズ・...

kintone Café 福岡 Vol.3（kintone JavaScriptカスタマイズ・kintone.proxy()/SendGrid）

More Decks by Ryu Yamashita

Other Decks in Programming

Featured

Transcript