GASをハンズオンのAPIサーバーに使ってみた

LT満員御礼！】サーバーレス LT #r_serverlesslt で発表した資料です
https://rakus.connpass.com/event/221200/

Transcript

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

   View Slide

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

   View Slide

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

   View Slide

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

   View Slide

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

   View Slide

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

   View Slide

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

   View Slide

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

   View Slide

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

   View Slide

10. APIαʔόʔͲ͏͢Δʁ
    

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

14. ٱʑʹGASΛ৮ͬͯΈΔ
    

    View Slide

15. GASͷΞοϓσʔτ
    

    View Slide

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

    View Slide

17. Before After
    IUUQTUFDIBDUJOEJOFU
    UIͷҧ͍
    

    View Slide

18. ༧ଌม׵͕͍͢͝
    

    View Slide

19. όοΫΤϯυͷ࣮૷
    

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

23. endpoint͝ͱʹ
    
    
    ϑΝΠϧΛ࡞੒
    

    View Slide

24. ॲཧΛ෼ׂͰ͖Δ
    

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide