Share
Embed
kintoneで楽々交通費精算!駅すぱあとWebサービス連携ハンズオン #kintonedevcamp / 20180802
HikaruMaruyama
August 03, 2018
Transcript
63 slides
-
ຊͷΞδΣϯμ • kintoneͰަ௨අਫ਼ࢉΞϓϦΛ࡞Ζ͏ - ֓ཁ • Ӻ͢ͺ͋ͱWebαʔϏεͱʁ • ϋϯζΦϯ 1.
ΞϓϦςϯϓϨʔτΛಡΈࠐ͏ 2. ఆظ݊Λར༻ͨ͠ӡܭࢉΛ͠Α͏ 3. ୳ࡧ݅ઃఆϘλϯΛՃ͠Α͏ 4. ܦ࿏Λ࠶ݱ͢ΔػೳΛՃ͠Α͏ -
Ӻ͢ͺ͋ͱWebαʔϏε Ӻσʔλɺܦ࿏ݕࡧͷWebAPI Ӻ͢ͺ͋ͱ͕࣋ͭػೳΛ WebAPIͱͯ͠ఏڙ ٕज़తͳϙΠϯτ • RESTfuʢ෩ʣ • ϨεϙϯεXML or
JSON • ϦϑΝϨϯεWebͰެ։ • αϯϓϧGithubͰެ։ • ҊαʔϏε • ཱྀඅަ௨අਫ਼ࢉγεςϜ ར༻γʔϯ બΔ2ͭͷϓϥϯ • ແྉͰ͑ΔϑϦʔϓϥϯ • શͯͷػೳ͕͑Δελϯμʔυϓϥϯ -
Ӻ͢ͺ͋ͱWebαʔϏε Ӻσʔλɺܦ࿏ݕࡧͷWebAPI Ӻ͢ͺ͋ͱ͕࣋ͭػೳΛ WebAPIͱͯ͠ఏڙ ٕज़తͳϙΠϯτ • RESTfuʢ෩ʣ • ϨεϙϯεXML or
JSON • ϦϑΝϨϯεWebͰެ։ • αϯϓϧGithubͰެ։ • ҊαʔϏε • ௨ۈඅཧγεςϜ • ཱྀඅަ௨අਫ਼ࢉγεςϜ ར༻γʔϯ ࠓճͷϋϯζΦϯͰ ελϯμʔυϓϥϯͷػೳΛར༻͠·͢ Ӻ͢ͺ͋ͱWebαʔϏεͷελϯμʔυϓϥϯ 90ؒແྉͰ͓ࢼ͠Ͱ͖·͢ ͓ਃ͠ࠐΈͪ͜Βˣ https://ekiworld.net/trial/index.php?case=6 -
1. ࣗͷڥͰΞϓϦ͕ಈ͘ঢ়ଶʹ͠Α͏ ZIPϑΝΠϧͷμϯϩʔυ IBOETPO ᵓᴷᴷ ᴹᵓᴷᴷFLJTQFSUKT ᴹᵋᴷᴷަ௨අਃΞϓϦ[JQ ᵓᴷᴷ ᴹᵓᴷᴷFLJTQFSUKT ᴹᵋᴷᴷFYQ(VJ$POEJUJPO
ᴹᵓᴷᴷFYQ$TT ᴹᴹᵋᴷᴷFYQ(VJ$POEJUJPODTT ᴹᵓᴷᴷFYQ(VJ$POEJUJPOKT ᴹᵋᴷᴷFYQ*NBHFT ᵋᴷᴷ ᵓᴷᴷFLJTQFSUKT ᵓᴷᴷFLJTQFSU%FUBJMKT ᵋᴷᴷަ௨අਃৄࡉΞϓϦ[JQ ;*1ϑΝΠϧͷதͷ σΟϨΫτϦߏͰ͢ -
1. ࣗͷڥͰΞϓϦ͕ಈ͘ঢ়ଶʹ͠Α͏ ZIPϑΝΠϧͷߏ IBOETPO ᵓᴷᴷ ᴹᵓᴷᴷFLJTQFSUKT ᴹᵋᴷᴷަ௨අਃΞϓϦ[JQ ᵓᴷᴷ ᴹᵓᴷᴷFLJTQFSUKT ᴹᵋᴷᴷFYQ(VJ$POEJUJPO
ᴹᵓᴷᴷFYQ$TT ᴹᴹᵋᴷᴷFYQ(VJ$POEJUJPODTT ᴹᵓᴷᴷFYQ(VJ$POEJUJPOKT ᴹᵋᴷᴷFYQ*NBHFT ᵋᴷᴷ ᵓᴷᴷFLJTQFSUKT ᵓᴷᴷFLJTQFSU%FUBJMKT ᵋᴷᴷަ௨අਃৄࡉΞϓϦ[JQ ࣍ͷఔͰ ʮަ௨අਃΞϓϦ[JQʯ Λར༻͠·͢ -
JavaScriptϑΝΠϧͷฤू QBUIUPIBOETPOFLJTQFSUKTϑΝΠϧΛ ΤσΟλͰ։͖·͢ (function($) { "use strict"; // Ӻ͢ͺ͋ͱWebαʔϏεͷΞΫηεΩʔ var
ekispertAccessKey = ‘xxx..’; // ަ௨අਃৄࡉΞϓϦID var detailAppId = ''; ަ௨අਃৄࡉΞϓϦͷ ΞϓϦ*%Λೖྗ͠·͢ ϑΝΠϧΛอଘ 1. ࣗͷڥͰΞϓϦ͕ಈ͘ঢ়ଶʹ͠Α͏ -
1. ࣗͷڥͰΞϓϦ͕ಈ͘ঢ়ଶʹ͠Α͏ ิ ݪҼɿ ʮ)5.-ΠϯλʔϑΣʔεαϯϓϧʯͰɺ $44͔Βར༻͢Δը૾Λ૬ରύεͰಡΈࠐΜͰ͍Δɻ LJOUPOFͰը૾ϑΝΠϧͷΞοϓϩʔυ͕Ͱ͖ͳ͍ͨΊಡΈࠐΈΤϥʔͱͳΔ ରࡦɿ ը૾ϑΝΠϧΛؚΉϑΝΠϧ܈ΛϗεςΟϯάͯ͠ 63-ࢦఆͰLJOUPOF͔ΒΞΫηε͢Δ
ϋϯζΦϯதಛʹରࡦͤͣɺ͜ͷ··ਐΊͪΌ͍·͢Ͷʂ ࣮ࡍʹΞϓϦΛར༻͞ΕΔࡍ͝ݕ౼͍ͩ͘͞ -
2. ఆظ݊Λར༻ͨ͠ӡܭࢉΛ͠Α͏ APIͷ༷ https://api.ekispert.jp/v1/json/search/course/extreme? key=xxx&viaList=22905:22884&date=20180720&searc hType=plain ϒϥβ͔Β ΞΫηεͯ͠ΈΑ͏ +40/σʔλͷϨεϙϯε͕ݟͮΒ͍ʁ LJOUPOFΞϓϦͰ࣮ࡍʹୟ͍͍ͯΔͷ͖ͬ͞ͷ63-Ͱ͕͢
9.-σʔλͷํ͕ݟ͍͔͢ͳͷͰ ͔͜͜Β9.-σʔλͰઆ໌͠·͢Ͷ ˞σʔλϑΥʔϚοτ͕ҟͳΔ͚ͩͰதಉ͡Ͱ͢ https://api.ekispert.jp/v1/xml/search/course/extreme? key=xxx&viaList=22905:22884&date=20180720&search Type=plain -
2. ఆظ݊Λར༻ͨ͠ӡܭࢉΛ͠Α͏ APIͷ༷ https://api.ekispert.jp/v1/xml/search/course/extreme? key=xxx&viaList=22905:22884&date=20180720&searchType= plain ΫΤϦύϥϝʔλɿ σʔλϑΥʔϚοτɿ 9.-PS+40/͕ࢦఆͰ͖·͢ "1*ͷػೳɿ
ަ௨අਫ਼ࢉΞϓϦͷཪଆͰ Ӻ؆қใ"1* TUBUJPOMJHIU ܦ࿏୳ࡧ"1* TFBSDIDPVSTFFYUSFNF ͳͲ͕ར༻͞Ε͍ͯ·͢ LFZ Ӻ͢ͺ͋ͱ8FCαʔϏεͷΞΫηεΩʔ WJB-JTU ग़ൃɺܦ༝ɺ౸ண EBUF ୳ࡧʢ::::..%%ʣ TFBSDI5ZQF ୳ࡧछผ -
2. ఆظ݊Λར༻ͨ͠ӡܭࢉΛ͠Α͏ APIͷ༷ https://api.ekispert.jp/v1/xml/search/course/extreme? key=xxx&viaList=22905:22884&date=20180720 &searchType=plain ग़ൃɺܦ༝ɺ౸ணΛͦΕͧΕίϩϯʮʯͰ۠Γ·͢ɻ ʮʯീԦࢠӺͷӺίʔυɺʮʯຊڮ ౦ژ ӺͷӺίʔυΛ
ද͍ͯ͠·͢ɻWJB-JTUʹɺӺίʔυҎ֎ʹɺӺͷ໊শɺҢܦɺॅॴͳͲΛ ࢦఆ͢Δ͜ͱ͕Ͱ͖·͢ɻ Ӻ͢ͺ͋ͱ8FCαʔϏεͰɺμΠϠσʔλΛ͏୳ࡧʢμΠϠʹΑΔ୳ࡧʣͱɺ ฏதͷฏۉతͳॴཁ࣌ؒΛར༻ͨ͠୳ࡧʢฏۉͪ࣌ؒʹΑΔ୳ࡧʣͷ ೋͭͷ୳ࡧํ๏͕͋ΓɺͦΕΛ͞ΒʹࡉԽͨ͠ͷ͕୳ࡧछผͱͳΓ·͢ɻ -
2. ఆظ݊Λར༻ͨ͠ӡܭࢉΛ͠Α͏ APIͷ༷ https://api.ekispert.jp/v1/xml/search/course/extreme? key=xxx&viaList=22905:22884&date=20180720 &searchType=plain&assignTeikiSerializeData=VkV4QaECpzzHAQED pgEz7vsEk8EBpVjDwQGlWNXBAaVYjwWSwwEBA6UBNQSlWNXEA QECAQOkbQSlWI8HksUBpVjDAqVY1QMABAAFAMUBpVjVAqVYjw MBBAEFAAgBCgE*— f3a068ec4c8bda86d18d7209feb5f7637dc3bd8b--0--95
BTTJHO5FJLJ4FSJBMJ[F%BUBύϥϝʔλʹ ఆظܦ࿏γϦΞϥΠζσʔλΛࢦఆ͢Ε ఆظ݊Λར༻ͨ͠ӡܭࢉ͕ߦΘΕ·͢ɻ -
2. ఆظ݊Λར༻ͨ͠ӡܭࢉΛ͠Α͏ ఆظܦ࿏γϦΞϥΠζσʔλͷऔಘํ๏ https://api.ekispert.jp/v1/xml/search/course/extreme? key=xxx&viaList=22723:22741:22671&searchType=plain Ӻใ"1* TUBUJPO Ӻ؆қใ"1* TUBUJPOMJHIU Ͱ
Ӻίʔυ͕औಘͰ͖·͢ ఆظܦ࿏γϦΞϥΠζσʔλɺܦ࿏୳ࡧAPIͷϨεϙϯεʹ༩͞ΕΔͷͰ ܦ࿏୳ࡧAPIͰ௨ۈఆظ݊ͷܦ࿏Λݕࡧ͠·͢ ྫ͑ɺԼʔ৽॓ʔߴԁࣉͷ௨ۈఆظ݊Λ͍࣋ͬͯΔͱͨ͠Βɺ ҎԼͷϦΫΤετʹͳΓ·͢ -
2. ఆظ݊Λར༻ͨ͠ӡܭࢉΛ͠Α͏ ఆظܦ࿏γϦΞϥΠζσʔλͷऔಘํ๏ https://api.ekispert.jp/v1/xml/search/course/extreme? key=ajawaANhL9RWERyT&viaList=22723:22741:22671&searchT ype=plain Ӻใ"1* TUBUJPO Ӻ؆қใ"1* TUBUJPOMJHIU
Ͱ Ӻίʔυ͕औಘͰ͖·͢ ఆظܦ࿏γϦΞϥΠζσʔλɺܦ࿏୳ࡧAPIͷϨεϙϯεʹ༩͞ΕΔͷͰ ܦ࿏୳ࡧAPIͰ௨ۈఆظ݊ͷܦ࿏Λݕࡧ͠·͢ ྫ͑ɺԼʔ৽॓ʔߴԁࣉͷ௨ۈఆظ݊Λ͍࣋ͬͯΔͱͨ͠Βɺ ҎԼͷϦΫΤετʹͳΓ·͢ ʮԼখాٸখాݪઢ৽̧̟॓தԝઢշߴԁࣉʯ ͷɺఆظܦ࿏γϦΞϥΠζσʔλΛ ༻ҙ͓͖ͯ͠·ͨ͠ 7L72B&$QG)"2&%QH&[&&L&#Q7K%X2(M8/ 9#"B7:KX84XX&#"6#/24M8/9&"2&$"20LC2 4M8*)LT6#Q7K%"R7:2."#""'".6#Q7K7"R7: KX.##"&'""H#$H& EBBFFDE FFGDDF -
ZIPϑΝΠϧͷߏ IBOETPO ᵓᴷᴷ ᴹᵓᴷᴷFLJTQFSUKT ᴹᵋᴷᴷަ௨අਃΞϓϦ[JQ ᵓᴷᴷ ᴹᵓᴷᴷFLJTQFSUKT ᴹᵋᴷᴷFYQ(VJ$POEJUJPO ᴹᵓᴷᴷFYQ$TT ᴹᴹᵋᴷᴷFYQ(VJ$POEJUJPODTT
ᴹᵓᴷᴷFYQ(VJ$POEJUJPOKT ᴹᵋᴷᴷFYQ*NBHFT ᵋᴷᴷ ᵓᴷᴷFLJTQFSUKT ᵓᴷᴷFLJTQFSU%FUBJMKT ᵋᴷᴷަ௨අਃৄࡉΞϓϦ[JQ ࣍ͷఔͰ ʮFLJTQFSUKTʯͱ ʮFYQ(VJ$POEJUJPOʯσΟϨΫτϦ Λར༻͠·͢ 3. ୳ࡧ݅ઃఆϘλϯΛՃ͠Α͏ -
ิ IBOETPO ᵓᴷᴷ ᴹᵓᴷᴷFLJTQFSUKT ᴹᵋᴷᴷަ௨අਃΞϓϦ[JQ ᵓᴷᴷ ᴹᵓᴷᴷFLJTQFSUKT ᴹᵋᴷᴷFYQ(VJ$POEJUJPO ᴹᵓᴷᴷFYQ$TT ᴹᴹᵋᴷᴷFYQ(VJ$POEJUJPODTT
ᴹᵓᴷᴷFYQ(VJ$POEJUJPOKT ᴹᵋᴷᴷFYQ*NBHFT ᵋᴷᴷ ᵓᴷᴷFLJTQFSUKT ᵓᴷᴷFLJTQFSU%FUBJMKT ᵋᴷᴷަ௨අਃৄࡉΞϓϦ[JQ ͜ͷϑΝΠϧ܈ҰମԿʁ 3. ୳ࡧ݅ઃఆϘλϯΛՃ͠Α͏ -
ZIPϑΝΠϧͷߏ IBOETPO ᵓᴷᴷ ᴹᵓᴷᴷFLJTQFSUKT ᴹᵋᴷᴷަ௨අਃΞϓϦ[JQ ᵓᴷᴷ ᴹᵓᴷᴷFLJTQFSUKT ᴹᵋᴷᴷFYQ(VJ$POEJUJPO ᴹᵓᴷᴷFYQ$TT ᴹᴹᵋᴷᴷFYQ(VJ$POEJUJPODTT
ᴹᵓᴷᴷFYQ(VJ$POEJUJPOKT ᴹᵋᴷᴷFYQ*NBHFT ᵋᴷᴷ ᵓᴷᴷFLJTQFSU%FUBJMKT ᵓᴷᴷFLJTQFSUKT ᵋᴷᴷަ௨අਃৄࡉΞϓϦ[JQ ࣍ͷఔͰ ʮFLJTQFSUKTʯͱ ʮަ௨අਃৄࡉΞϓϦ[JQʯ Λར༻͠·͢ 4. ܦ࿏Λ࠶ݱ͢ΔػೳΛՃ͠Α͏ -
4. ܦ࿏Λ࠶ݱ͢ΔػೳΛՃ͠Α͏ JavaScriptϑΝΠϧͷฤू QBUIUPIBOETPOFLJTQFSUKTϑΝΠϧΛ ΤσΟλͰ։͖·͢ (function($) { "use strict"; //
Ӻ͢ͺ͋ͱWebαʔϏεͷΞΫηεΩʔ var ekispertAccessKey = ‘xxx..’; // ަ௨අਃৄࡉΞϓϦID var detailAppId = ''; ަ௨අਃৄࡉΞϓϦͷ ΞϓϦ*%Λೖྗ͠·͢ ϑΝΠϧΛอଘ -
4. ܦ࿏Λ࠶ݱ͢ΔػೳΛՃ͠Α͏ ิ ܦ࿏Λ࠶ݱͤ͞ΔͨΊʹɺ ܦ࿏୳ࡧ"1* TFBSDIDPVSTFFYUSFNF ͷ Ϩεϙϯεͷ+40/σʔλΛอଘ͢Δඞཁ͕͋Γ·͢ɻ ܦ࿏Λ࠶ݱͰ͖Δʮܦ࿏ͷ࠶ݱʗఆظ݊ɾࢦఆྻंར༻"1* DPVSTFFEJU
ʯͰɺ ͋͘·ͰҰ࣌తͳ࠶ݱΛఆͯ͠࡞ΒΕ͍ͯ·͢ɻ ࠓճͷΑ͏ʹɺঝೝऀ͕ܦ࿏Λ֬ೝ͢ΔΑ͏ͳ໘Ͱ +40/σʔλΛؙʑอଘ͢Δํ๏͕࣮֬ʹܦ࿏Λ࠶ݱ͢Δ͜ͱ͕Ͱ͖·͢ɻ ˞μΠϠใΛอ࣋͢ΔߦҝӺ͢ͺ͋ͱ8FCαʔϏεͷنʹҧ͠·͢ͷͰɺ μΠϠʹΑΔ୳ࡧͰͷܦ࿏୳ࡧ݁Ռอ࣋͢Δ͜ͱͰ͖·ͤΜɻ ͝ҙ͍ͩ͘͞ɻ