Upgrade to Pro — share decks privately, control downloads, hide ads and more …

kintone Café 東京 Vol.4 ハンズオン資料(kintone & AWS API...

Ryu Yamashita
September 04, 2015

kintone Café 東京 Vol.4 ハンズオン資料(kintone & AWS API Gateway/Lambda/Machine Learning)

kintone Café 東京 Vol.4のハンズオンパートの資料です。

Ryu Yamashita

September 04, 2015
Tweet

More Decks by Ryu Yamashita

Other Decks in Technology

Transcript

  1. w LJOUPOFͷ֓ཁ w LJOUPOFͷΧελϚΠζػೳ w "84ͷ֓ཁ w LJOUPOFͱ"84 w LJOUPOF+BWB4DSJQU"1*

    w LJOUPOFQSPYZ  w αϯϓϧμ΢ϯϩʔυ w ػցֶशͷϞσϧ࡞੒ͷͨΊͷσʔλ४උ 5PEBZ`T$BGÉ.VOF 2 w "84ͷઃఆ w 4ɾόέοτͷઃఆ w .BDIJOF-FBSOJOHͷઃఆ w -BNCEBɾΠϕϯτͷઃఆ w "1*(BUFXBZͷઃఆ w LJOUPOFΞϓϦͷΧελϚΠζ w ϦΞϧλΠϜ༧ଌͷ࣮ߦ ˞εϥΠυ಺ϦϯΫ͸1%'μ΢ϯϩʔυ࣌ʹ༗ޮʹͳΓ·͢
  2. ࣗݾ঺հ 3  *05ͱάϧʔϓ΢ΣΞʢσξΤʣͷ࿈ܞΛࢼΈͯLJOUPOFɹʹग़ձ͏  LJOUPOFΤόϯδΣϦετʹ  LJOUPOF޷͖͕ߴͯ͡ɺք۾ॳͷLJOUPOFస৬  LJOUPOF$BGÉӡӦࣄ຿ہ։ઃɺࣄ຿ہϝϯόʔʹ

     LJOUPOF$BGÉ෱Ԭ7PMΛओ࠵ ݱࡏʢLJOUPOFྺ೥ͪΐͬͱɺ"84ྺ਺िؒʣ ଟ෼ɺl೔ຊͰ།ҰLJOUPOFͰ͝൧৯΂ͯΔਓz גࣜձࣾδϣΠκʔɹࢁԼཽʢʣ෱Ԭݝେໂాࢢग़਎ ʮϒϧʔ΢Σʔ ϒʯ ͱ͍͏ڞ௨఺
  3. LJOUPOFͱ͸ʁʢͬ͘͟Γʣ 11 w ίϯηϓτ wʮϑΝετγεςϜʯ wʮ෼Ͱۀ຿վળΞϓϦʯ w ߏ੒ཁૉ wσʔλ w

    ϓϩηε؅ཧʢϫʔΫϑϩʔʣ wίϛϡχέʔγϣϯ ʢग़యɿʮLJOUPOFެࣜαΠτʯʣ ʮαΠϘ΢ζϓϩμΫτνʔϜΛڧ͘͢Δπʔϧʯ ͷதͰ΋൚༻ੑͱઐ໳ੑΛߦ͖དྷ͠ͳ͕Βɺ༷ʑͳ ۀ຿γʔϯͰ׆༻ग़དྷΔΫϥ΢υσʔλϕʔε ʢ8FC%#ʣαʔϏε
  4. LJOUPOFΧελϚΠζػೳ 14 w 3&45"1* w Ϩίʔυ΍εϖʔεͷૢ࡞ʢొ࿥ɾߋ৽ɾ࡟আ౳ʣɺ όϧΫ"1*ɺΞϓϦ࡞੒ɺϫʔΫϑϩʔૢ࡞ w Ϣʔβɾ૊৫ͷૢ࡞ w

    +BWB4DSJQU$44ΧελϚΠζ w ֤छΠϕϯτϋϯυϧɺ৘ใऔಘ w ϓϩΩγʹΑΔ֎෦"1*࿈ܞ w 63-ࢦఆʹΑΔϥΠϒϥϦͷಡΈࠐΈʢ)5514ରԠʣ σʔλ Ϩίʔυ εϖʔε Ϣʔβ 6* جװγεςϜ Excel ଞͷΫϥ΢υ REST API LJOUPOFQSPYZ
  5. LJOUPOFͱ"84 21 w ΞϓϦέʔγϣϯدΓ1BB4 4BB4  w ΫϥΠΞϯταΠυϑϩϯτΤϯυ ʢ6*69ʣ w

    ߦಈతղऍͷڞ༗ͰΞΫγϣϯΛى͜͠ɺ ίϛϡχέʔγϣϯͰۀ຿Λճ͢ w ΠϯϑϥدΓ1BBT *BB4ɺ#BB4  w αʔόʔαΠυόοΫΤϯυɹɹɹ ίϚϯυ  w ࢥߟతσʔλΛࡹ͖ࣄ৅Λղऍ͢Δ "1*Ͱ ݁߹ɾิ׬
  6. *P5Ͱߟ͑Δ݁߹ɾิ׬Πϝʔδ 22 ɾ೶ۀʢะ৔ʣ ɾݟकΓ ɾݐઃɾ޻ࣄݱ৔ ɾ޻৔ઃඋ ɾΤωϧΪʔઃඋ ݱ৔ ηϯαʔ ɾԹ౓

    ɾ࣪౓ ɾর౓ ɾՃ଎౓ ɾ૽Ի ηϯαʔ Ϋϥ΢υ LJOUPOF ɾ௨஌ ɾϫʔΫϑϩʔ ɾεϨου ɾΧελϚΠζϏϡʔ ࣄ৅ɾσʔλ͕ൃੜ͢Δ σʔλΛࡹ͖ɺ ࣄ৅Λղऍ͢Δ ղऍͷڞ༗ͰΞΫγϣϯΛ ى͜͠ɺίϛϡχέʔγϣ ϯͰۀ຿Λճ͢
  7. ԦಓͬΆ͍"84ͱLJOUPOFͷ࿈ܞύλʔϯ 23 "NB[PO%ZOBNP%# 4USFBN "NB[PO4/4 "NB[PO4 "NB[PO,JOFTJT "84-BNCEB "NB[PO&$ -BNCEB

    Πϕϯτιʔε 3&45"1* LJOUPOFPODZCP[VDPN ɾϨίʔυૢ࡞ ɾϫʔΫϑϩʔૢ࡞ ɾεϖʔεૢ࡞ ɾΞϓϦૢ࡞ 3&45"1* LJOUPOFQSPYZ  "NB[PO"1*(BUFXBZܦ༝͸ྑͦ͞͏ɾɾɾ 3 &45" 1* ϓϦϛςΟϒͳ࿈ܞ ɾϗεςΟϯά ɾόονॲཧ
  8. "NB[PO4 5PEBZ`T$BGÉ.FOV 24 "NB[PO%ZOBNP%# 4USFBN "NB[PO4/4 "NB[PO,JOFTJT "NB[PO&$ -BNCEB Πϕϯτιʔε

    ɾϨίʔυૢ࡞ ɾϫʔΫϑϩʔૢ࡞ ɾεϖʔεૢ࡞ ɾΞϓϦૢ࡞ 3 &45" 1* ϓϦϛςΟϒͳ࿈ܞ ɾϗεςΟϯά ɾόονॲཧ "84-BNCEB 3&45"1* LJOUPOFPODZCP[VDPN LJOUPOFQSPYZ  "NB[PO"1*(BUFXBZܦ༝͸ྑͦ͞͏ɾɾɾ 3&45"1* ɾϨίʔυૢ࡞ 3&45"1* "NB[PO .BDIJOF-FBSOJOH 3&45"1*
  9. w &$ʹ࡞ΓࠐΈ͠ͳͯ͘΋༰қ ʹ"1*͕࡞ΕΔ w ΤϯυϙΠϯτͷ׬શެ։΍ "1*Ωʔ౳ΞΫηεɾೝূϨϕ ϧΛॊೈʹઃఆͰ͖Δ w $034ઃఆʹରԠ w

    "1*ͷόʔδϣϯ؅ཧ͕Ͱ͖Δ "NB[PO"1*(BUFXBZ 26 ΤίγεςϜܗ੒ɾγεςϜؒ࿈ܞΛՄೳʹ͢Δ"1*ͦͷ΋ͷ Λ༰қʹ࡞ΕΔͷͰɺΤίγεςϜܗ੒ͷෑډ͕ߋʹԼ͕Δʂ
  10. w छྨͷ༧ଌϞσϧ w ೋ߲ʢϩδεςΟοΫճؼʣ w ଟΫϥε෼ྨʢଟ߲ϩϩδεςΟοΫճؼʣ w ճؼ෼ੳʢઢܗճؼʣ w ༧ଌͷ࣮ߦ

    w όονʢෳ਺σʔλΛ·ͱΊͯ༧ଌʣ w ϦΞϧλΠϜʢ"1*ܦ༝Ͱ݅ͣͭ༧ଌʣ "NB[PO.BDIJOF-FBSOJOH 28 4΍3FETIJGUͷσʔλΛར༻ͯ͠ɺϞσϧ࡞੒ɾ༧ଌ ͕༰қʹ࣮ߦͰ͖ΔͷͰɺػցֶशͷෑډ͕Լ͕Δʂ
  11. 5PEBZ`T$BGÉ.FOV 31 "84 -BNCEB LJOUPOF PODZCP[VDPN ᶃLJOUPOFσʔλͰ ༧ଌϞσϧ࡞੒ "NB[PO "1*(BUFXBZ

    "NB[PO .BDIJOF-FBSOJOH ᶄLJOUPOFʹσʔλొ࿥ ᶅ"1*ʢΫΤϦʣͰ ύϥϝʔλΛ౉͢ ᶆ&WFOUͰύϥϝʔλΛड͚औΓɺ "1*ͰϦΞϧλΠϜ༧ଌ΁ 3&45"1* &WFOU 3&45"1* ᶇ༧ଌ࣮ߦޙ ༧ଌ஋Λฦ͢ ˞ॳಈͷϞσϧ࡞੒͸௚઀࣮ࢪ ɹʢ-BNCEBະܦ༝ʣ LJOUPOFͷσʔλ؅ཧʹ༧ଌػೳΛ௥Ճʂ ର৅ͷ͓٬͞Μ͕LJOUPOFΛܖ໿ͯ͘͠Εͦ͏͔͕෼͔Δ  ᶈ༧ଌ஋Ληοτ LJOUPOFQSPYZ
  12. w LJOUPOF w +BWB4DSJQU͔Β֎෦"1*Λίʔϧ͢ΔLJOUPOFQSPYZ ͷར༻ํ๏ w "84 w "1*(BUFXBZͷઃఆํ๏ w

    .BQQJOH5FNQMBUFͷઃఆʢ-BNCEBؔ਺ͱͷڠௐʣ w .BDIJOF-FBSOJOHͷઃఆํ๏ w EBUBTPVSDFɺ.-NPEFMɺQSFEJDUJPOͷ࡞੒ɾઃఆͷํ๏ͱྲྀΕ w -BNCEB͔Βͷ.-ϦΞϧλΠϜ༧ଌ࣮ߦํ๏ w "1*(BUFXBZ͔ΒͷFWFOUύϥϝʔλͷडऔʢ-BNCEBؔ਺ͱͷڠௐʣ ࠓճͷϋϯζΦϯʹඞཁͱ͞ΕΔεΩϧηοτʢ໨ඪɾ੒Ռ෺ʣ 32
  13. LJOUPOFQSPYZ ʹ͓͚Δ1045165ͷϙΠϯτ 35 ߲໨ ϑΥʔϜܗࣜσʔλ +40/ܗࣜσʔλ ϦΫΤετϔομ .*.&λΠϓ $POUFOU5ZQFBQQMJDBUJPOYXXXGPSN VSMFODPEFE

    $POUFOU5ZQFBQQMJDBUJPO KTPO ϦΫΤετϘσΟ هࡌํ๏ \LFZ^\WBMVF^\LFZ^\WBMVF^ ʢจࣈྻʣ ˞\WBMVF^͸63-Τϯίʔυ +40/ ʢจࣈྻɺΦϒδΣΫτʣ αʔϏεྫ 5XJMJPɺ4FOE(SJEɺ5ZQFUBML LJOUPOFɺ4RVBSFɺ9JWFMZ ˞(&5ͷϨεϙϯε͸ຆͲ͕+40/
  14. DVSMίϚϯυͱLJOUPOFQSPYZ ͷରԠؔ܎ 37  ϦΫΤετ63- DVSMίϚϯυͰ͸ਖ਼ຯͷҾ਺ʹͳΓ·͢ͷͰɺίϚϯυΦϓγϣϯ͸͋Γ·ͤΜɻ  ϦΫΤετϝιου (&5ɺ1045ɺ165ɺ%&-&5&ͷ͍ͣΕ͔ΛࢦఆͰ͖·͢ɻ 

    ϦΫΤετϔομ ෳ਺ࢦఆ͢Δඞཁ͕͋Δͱ͖ʹ͸ɺDVSMίϚϯυͰ͸ʮ) \IFBEFS,FZ^\IFBEFS7BMVF^ʯΛηοτͱͯ͠ɺඞཁ਺ॻ͖ฒ΂ΒΕ·͢ɻ LJOUPOFQSPYZ Ͱ͸ʮ\\IFBEFS,FZ^\IFBEFS7BMVF^  \IFBEFS,FZ^\IFBEFS7BMVF^ ɾɾɾ^ʯͱ͍ͬͨΑ͏ʹίϯϚͰඞཁ਺Λ࿈݁͠ ͍ͯͩ͘͞ɻ ʢग़యɿʮLJOUPOFϚογϡΞοϓͷͨΊͷ౾஌ࣝʢDVSMίϚϯυͱLJOUPOFQSPYZ ͷରԠʣʯʣ
  15. DVSMίϚϯυͱLJOUPOFQSPYZ ͷରԠؔ܎ 38  ϦΫΤετσʔλ ϑΥʔϜܗࣜ  DVSMίϚϯυͰʮEʯͷΦϓγϣϯͰ͸௨ৗϑΥʔϜܗࣜσʔλΛݴ͓ͬͯΓɺରԠ͢Δ $POUFOU5ZQF͸ʮBQQMJDBUJPOYXXXGPSNVSMFODPEFEʯͱͯ͠ॲཧ͞Ε͍ͯ·͢ʢʮ )ʯͰͷ໌ࣔෆཁʣͷͰɺLJOUPOFQSPYZ

    Ͱ͸͜ΕΛϔομʹ௥Ճ͓ͯ͘͠ͱྑ͍Ͱ͢ɻ ෳ਺ࢦఆ͢Δඞཁ͕͋Δͱ͖ʹ͸ɺDVSMίϚϯυͰ͸ʮE\LFZ^\WBMVF^ʯΛηοτͱ͠ ͯɺඞཁ਺ॻ͖ฒ΂ΒΕ·͢ɻLJOUPOFQSPYZ Ͱ͸ɺ ʮ\LFZ^\WBMVF^\LFZ^\WBMVF^ɾɾɾʯͱ͍ͬͨΑ͏ʹʮʯͰඞཁ਺࿈݁ͯ͠ ͍ͩ͘͞ɻ DVSMίϚϯυͰ͸\WBMVF^෦෼Λ63-ΤϯίʔυԽ͢ΔʮEBUBVSMFODPEFʯͱ͍ͬͨΦ ϓγϣϯ͕࢖ΘΕΔ͜ͱ͕͋Γ·͕͢ɺ͜ΕʹରԠ͢ΔͨΊʹ͸LJOUPOFQSPYZ Ͱ͸ɺ +BWB4DSJQUதͰʮFODPEF63*$PNQPOFOU \WBMVF^ ʯΛܦ༝͓ͤͯ͘͞ͱྑ͍Ͱ͢ɻ ʢग़యɿʮLJOUPOFϚογϡΞοϓͷͨΊͷ౾஌ࣝʢDVSMίϚϯυͱLJOUPOFQSPYZ ͷରԠʣʯʣ
  16. DVSMίϚϯυͱLJOUPOFQSPYZ ͷରԠؔ܎ 39  ϦΫΤετσʔλ +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-ʯͱॻ͘ํ๏΋͋Γ·͢ɻ ʢग़యɿʮLJOUPOFϚογϡΞοϓͷͨΊͷ౾஌ࣝʢDVSMίϚϯυͱLJOUPOFQSPYZ ͷରԠʣʯʣ
  17. ϋϯζΦϯʹ͓͚Δ࡞ۀͷྲྀΕ 45 ϞνϕʔγϣϯγφϦΦ ςΫχΧϧͳߏ੒ ର৅ͷ͓٬͞Μ͕ LJOUPOFΛ ܖ໿ͯ͘͠Εͦ͏͔Λ ༧ଌ͢Δʂ  ܖ໿࣮੷ʢ໨తม਺ʣͱސ٬৘ใ΍ଐੑʢઆ໌ม਺ʣ͕ೖྗ͞ΕͨϨίʔυҰཡΛLJOUPOFΞ

    ϓϦ͔Βμ΢ϯϩʔυ  Ͱμ΢ϯϩʔυͨ͠σʔλ͔Βػցֶशͷ༧ଌϞσϧΛ࡞੒ʢ4.-ʣ  ର৅ސ٬ʹର͢ΔϦΞϧλΠϜ༧ଌ͕ग़དྷΔ"1*Λ࡞੒͢Δʢ"1*(BUFXBZ-BNCEB.-ʣ  LJOUPOFʹొ࿥ͨ͠ର৅ސ٬ͷϨίʔυ৘ใΛ΋ͱʹͷ"1*Λίʔϧ͢ΔʢLJOUPOFQSPYZʣ
  18. "1*(BUFXBZͷઃఆʢଓ͖ɿࠓճͷ.BQQJOH5FNQMBUFʹ͍ͭͯʣ 99 w ϦΫΤετύϥϝʔλͷऔಘ w 1045165͸JOQVUKTPO   w (&5͸JOQVUQBSBNT

    RVFSZTUSJOH w ύε΍ϔομͷ஋΋औಘՄ w ৄࡉ͸ʮ.BQQJOH5FNQMBUF 3FGFSFODFʯΛ֬ೝ -BNCEBͷFWFOU΁౉Δύϥϝʔλͷઃఆ
  19. ʲऔ૊Έ಺༰֬ೝʳϋϯζΦϯʹ͓͚Δ࡞ۀͷྲྀΕ 107 ϞνϕʔγϣϯγφϦΦ ςΫχΧϧͳߏ੒ ର৅ͷ͓٬͞Μ͕ LJOUPOFΛ ܖ໿ͯ͘͠Εͦ͏͔Λ ༧ଌ͢Δʂ  ܖ໿࣮੷ʢ໨తม਺ʣͱސ٬৘ใ΍ଐੑʢઆ໌ม਺ʣ͕ೖྗ͞ΕͨϨίʔυҰཡΛLJOUPOFΞ

    ϓϦ͔Βμ΢ϯϩʔυ  Ͱμ΢ϯϩʔυͨ͠σʔλ͔Βػցֶशͷ༧ଌϞσϧΛ࡞੒ʢ4.-ʣ  ର৅ސ٬ʹର͢ΔϦΞϧλΠϜ༧ଌ͕ग़དྷΔ"1*Λ࡞੒͢Δʢ"1*(BUFXBZ-BNCEB.-ʣ  LJOUPOFʹొ࿥ͨ͠ର৅ސ٬ͷϨίʔυ৘ใΛ΋ͱʹͷ"1*Λίʔϧ͢ΔʢLJOUPOFQSPYZʣ
  20. ॴײ 110 w .-ͷσʔλιʔεͷ΋ͱʹͳΔ4΁ͷLJOUPOF͔Βͷ$47ग़ྗ͸σʔ λྔ͕ଟ͍ͷͰ"1*ΑΓ6*Ͱͷग़ೖྗ͕࣮֬ͦ͏ʢ-BNCEBͰDMJ LJOUPOFΛͨͨ͘ͷ͸λΠϜΞ΢τͨ͠ʣ w ࠓճɺLJOUPOF+4͔Β"1*(BUFXBZ΁ͷϦΫΤετΛ LJOUPOFQSPYZ Ͱߦ͕ͬͨɺ$034ઃఆͰ͖ΔͷͰBKBY౳͔Βͷ

    ϦΫΤετͰ΋େৎ෉ͦ͏ w LJOUPOFQSPYZ ͰͷϦΫΤετ͸جຊςΩετϕʔεͰɺNVMUJQBSU GPSNEBUBܗࣜ౳ͷରԠ͸ݱঢ়ͳ͍ͨΊɺ"1*(BUFXBZ-BNCEBͰ ఴ෇ϑΝΠϧͷऔѻ͍౳Λิ͏ͷ΋ྑͦ͞͏
  21. ࢀߟ৘ใ 111 w ։ൃίϛϡχςΟαΠτʮDZCP[VDPNEFWFMPQFSOFUXPSLʯ<IUUQT DZCP[VEFW[FOEFTLDPNIDKB> w ίϛϡχςΟʢ࣭໰౳ʣɺϦϑΝϨϯεɺ5JQTɺαϯϓϧɺ։ൃऀϥΠηϯ εਃࠐ w ʮLJOUPOF"1*ʯ<IUUQTDZCP[VEFW[FOEFTLDPNIDKBDBUFHPSJFT

    > w LJOUPOF"1*ͷϦϑΝϨϯεʢDZCP[VDPNEFWOX಺ʣ w ʮΞϓϦ࡞੒ͱઃఆͷมߋʯ<IUUQTDZCP[VEFW[FOEFTLDPNIDKB BSUJDMFT> w LJOUPOFΞϓϦ࡞੒ܥ"1*ϦϑΝϨϯεʢDZCP[VDPNEFWOX಺ʣ