Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
GASをハンズオンのAPIサーバーに使ってみた
Search
4geru sakisaka
September 28, 2021
1
30
GASをハンズオンのAPIサーバーに使ってみた
LT満員御礼!】サーバーレス LT #r_serverlesslt で発表した資料です
https://rakus.connpass.com/event/221200/
4geru sakisaka
September 28, 2021
Tweet
Share
More Decks by 4geru sakisaka
See All by 4geru sakisaka
横断組織として考える共通DBの課題解決 〜 桃園の誓いアーキテクチャ 〜 / Addressing Shared Database Challenges as Cross-Team: “Peach Garden Oath” Architecture
4geru
2
740
Supabase x Ruby on Rails
4geru
0
240
Supabase Edge Functions で最近追加された AI 機能を使ってみた
4geru
0
320
福山ネーター LINE DC ハッカソン 2023 @福山
4geru
0
120
Google Form とちょっと 仲良くなった話。
4geru
0
52
Flutter x Graph
4geru
0
230
Github Discussions がイケてる
4geru
0
740
Flutter Academy final presentatoin
4geru
0
36
ハッカソン x Gatsby
4geru
0
58
Featured
See All Featured
What's in a price? How to price your products and services
michaelherold
243
12k
Refactoring Trust on Your Teams (GOTO; Chicago 2020)
rmw
31
2.7k
What's new in Ruby 2.0
geeforr
343
31k
Typedesign – Prime Four
hannesfritz
40
2.4k
The Cost Of JavaScript in 2023
addyosmani
45
6.7k
How STYLIGHT went responsive
nonsquared
95
5.2k
Save Time (by Creating Custom Rails Generators)
garrettdimon
PRO
27
830
Fantastic passwords and where to find them - at NoRuKo
philnash
50
2.9k
Design and Strategy: How to Deal with People Who Don’t "Get" Design
morganepeng
126
18k
Designing for Performance
lara
604
68k
Cheating the UX When There Is Nothing More to Optimize - PixelPioneers
stephaniewalter
280
13k
Large-scale JavaScript Application Architecture
addyosmani
510
110k
Transcript
GASΛϋϯζΦϯͷ APIαʔόʔʹͬͯΈͨ 2021/09/29 @4geru
ࣗݾհ !@HFSV !HFSV גࣜձࣾϚωʔϑΥϫʔυ 🤿🖥 🐼🍣🍺 ࣾձਓɺΤϯδχΞ
ɾ৽͍͠GASॻ͖͍͢ ɾϞοΫΞϓϦΛ4Ͱ࡞ͬͨϊϋ ɾdoGetͷΈͰͲ͏͢Δ͔ ͍͑ͨ͜ͱ
2͚ͭͩ ࠂ͍ͤͯͩ͘͞͞
ࠓिͷ༵(10/02 13:30-) LINE CommunityͷΠϕϯτΛ ։࠵͠·͢
དྷिͷਫ༵(10/06 19:00-) LIFFͷϋϯζΦϯΛ͠·͢
LIFFͱ ɾLIne Frontend Framework ͷུͰ͢ ɾϒϥβͰLINEͷػೳ͕͑ΔϑϨʔϜϫʔΫ ɹɾϢʔβʔใ ɹɾOS/ݴޠใ ɹɾBotͱͷ༑ୡใ
ɹɾϝοηʔδૹ৴ʢLINEϒϥβͷΈʣ ɹɾQRεΩϟϯʢLINEϒϥβͷΈʣ
ϋϯζΦϯͰ ΞϯέʔτΞϓϦ Λ࡞Γ·͢
Ξϯέʔτ Ճ બࢶ Ճ ථத ථޙ ༑ୡʹ γΣΞ
APIαʔόʔͲ͏͢Δʁ
ϋϯζΦϯͷಛੑ ɾ͍ΖΜͳਓ͕ࢀՃ͢Δ ɹɾWindows/Mac etc… ɹɾϓϩάϥϛϯά/LINE APIॳ৺ऀɾ্ڃऀ ɾຊ࣭Ͱͳ͍ࣄલ४උΛݮΒ͍ͨ͠ ɹɾAWS/GCP͍ͨ͘ͳ͍ ɾ͍ͨ͠τϐοΫʹूத͍ͨ͠ ɹɾࢀՃ͕ΰʔϧͰͳ͘ɺཱ࣮ࣗͯ͠Ͱ͖ΔΑ͏ʹͳΔ
ʂʂGASͳΒ୭Ͱ৮ΕΔʂʂ
SpreadSheetͷදݱํ๏ ฤू FEJU ςϯϓϨʔτ UFNQMBUFQSFWJFX ίϐʔ DPQZ 1%'$47ग़ྗ FYQPSU GPSNBUDTWPSQEG
)5.-WJFX IUNMWJFX
ٱʑʹGASΛ৮ͬͯΈΔ
GASͷΞοϓσʔτ
2020/12/07 ʹ৽͍͠IDEʹͳ͍ͬͯΔ
Before After IUUQTUFDIBDUJOEJOFU UIͷҧ͍
༧ଌม͕͍͢͝
όοΫΤϯυͷ࣮
GASͷendpoint2͚ͭͩ get → doGet() post → doPost()
ෳendpointΛฦ͍ͨ͠ͱ͖ → parameter ʹ type Λར༻
main.gs Ͱ doGetͰparameter.type͔Β ֤endpointʹৼΓ͚
endpoint͝ͱʹ ϑΝΠϧΛ࡞
ॲཧΛׂͰ͖Δ
ͬͯΈͯ 👍 ΊͪΌͪ͘Όखܰʹ࣮͕Ͱ͖Δ 👍 ༧ଌม͕ࠓ·Ͱͱൺͯ࠷ߴ 👍 ϑΝΠϧׂͯ͠ཧ͕͍͢͠ 👎 get ϦΫΤετʹ্ݶ͕͋Δ
ͥͻὃ͞Εͨͱࢥͬͯ GASͰ༡ΜͰΈ͍ͯͩ͘͞
͋ͱɺLINEͷΠϕϯτ ڵຯ͋ΕɺࢀՃ͍ͯͩ͘͠͞ɻ