Slide 1

Slide 1 text

GASΛϋϯζΦϯͷ APIαʔόʔʹ࢖ͬͯΈͨ 2021/09/29 @4geru

Slide 2

Slide 2 text

ࣗݾ঺հ !@HFSV !HFSV גࣜձࣾϚωʔϑΥϫʔυ 🤿🖥 🐼🍣🍺 ࣾձਓ೥໨ɺΤϯδχΞ

Slide 3

Slide 3 text

ɾ৽͍͠GASॻ͖΍͍͢ ɾϞοΫΞϓϦΛ4೔Ͱ࡞ͬͨϊ΢ϋ΢ ɾdoGetͷΈͰͲ͏͢Δ͔ ఻͍͑ͨ͜ͱ

Slide 4

Slide 4 text

2͚ͭͩ ࠂ஌͍ͤͯͩ͘͞͞

Slide 5

Slide 5 text

ࠓिͷ౔༵೔(10/02 13:30-) LINE CommunityͷΠϕϯτΛ ։࠵͠·͢

Slide 6

Slide 6 text

དྷिͷਫ༵೔(10/06 19:00-) LIFFͷϋϯζΦϯΛ͠·͢

Slide 7

Slide 7 text

LIFFͱ͸ ɾLIne Frontend Framework ͷུͰ͢ ɾϒϥ΢βͰLINEͷػೳ͕࢖͑ΔϑϨʔϜϫʔΫ ɹɾϢʔβʔ৘ใ ɹɾOS/ݴޠ৘ใ ౳ ɹɾBotͱͷ༑ୡ৘ใ ɹɾϝοηʔδૹ৴ʢLINE಺ϒϥ΢βͷΈʣ ɹɾQRεΩϟϯʢLINE಺ϒϥ΢βͷΈʣ

Slide 8

Slide 8 text

ϋϯζΦϯͰ͸ ΞϯέʔτΞϓϦ Λ࡞Γ·͢

Slide 9

Slide 9 text

Ξϯέʔτ ௥Ճ બ୒ࢶ ௥Ճ ౤ථத ౤ථޙ ༑ୡʹ γΣΞ

Slide 10

Slide 10 text

APIαʔόʔͲ͏͢Δʁ

Slide 11

Slide 11 text

ϋϯζΦϯͷಛੑ ɾ͍ΖΜͳਓ͕ࢀՃ͢Δ ɹɾWindows/Mac etc… ɹɾϓϩάϥϛϯά/LINE APIॳ৺ऀɾ্ڃऀ ɾຊ࣭Ͱ͸ͳ͍ࣄલ४උΛݮΒ͍ͨ͠ ɹɾAWS/GCP࢖͍ͨ͘ͳ͍ ɾ࿩͍ͨ͠τϐοΫʹूத͍ͨ͠ ɹɾࢀՃ͕ΰʔϧͰ͸ͳ͘ɺཱ࣮ࣗͯ͠૷Ͱ͖ΔΑ͏ʹͳΔ

Slide 12

Slide 12 text

ʂʂGASͳΒ୭Ͱ΋৮ΕΔʂʂ

Slide 13

Slide 13 text

SpreadSheetͷදݱํ๏ ฤू FEJU ςϯϓϨʔτ UFNQMBUFQSFWJFX ίϐʔ DPQZ 1%'$47ग़ྗ FYQPSU GPSNBUDTWPSQEG )5.-WJFX IUNMWJFX

Slide 14

Slide 14 text

ٱʑʹGASΛ৮ͬͯΈΔ

Slide 15

Slide 15 text

GASͷΞοϓσʔτ

Slide 16

Slide 16 text

2020/12/07 ʹ৽͍͠IDEʹͳ͍ͬͯΔ

Slide 17

Slide 17 text

Before After IUUQTUFDIBDUJOEJOFU UIͷҧ͍

Slide 18

Slide 18 text

༧ଌม׵͕͍͢͝

Slide 19

Slide 19 text

όοΫΤϯυͷ࣮૷

Slide 20

Slide 20 text

GASͷendpoint͸2͚ͭͩ get → doGet() post → doPost()

Slide 21

Slide 21 text

ෳ਺endpointΛฦ͍ͨ͠ͱ͖ → parameter ʹ type Λར༻

Slide 22

Slide 22 text

main.gs Ͱ doGetͰparameter.type͔Β ֤endpointʹৼΓ෼͚

Slide 23

Slide 23 text

endpoint͝ͱʹ ϑΝΠϧΛ࡞੒

Slide 24

Slide 24 text

ॲཧΛ෼ׂͰ͖Δ

Slide 25

Slide 25 text

࢖ͬͯΈͯ 👍 ΊͪΌͪ͘Όखܰʹ࣮૷͕Ͱ͖Δ 👍 ༧ଌม׵͕ࠓ·Ͱͱൺ΂ͯ࠷ߴ 👍 ϑΝΠϧ෼ׂͯ͠؅ཧ͕͠΍͍͢ 👎 get ϦΫΤετʹ্ݶ͕͋Δ

Slide 26

Slide 26 text

ͥͻὃ͞Εͨͱࢥͬͯ GASͰ༡ΜͰΈ͍ͯͩ͘͞

Slide 27

Slide 27 text

͋ͱɺLINEͷΠϕϯτ ڵຯ͋Ε͹ɺࢀՃ͍ͯͩ͘͠͞ɻ