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
700
Supabase x Ruby on Rails
4geru
0
230
Supabase Edge Functions で最近追加された AI 機能を使ってみた
4geru
0
320
福山ネーター LINE DC ハッカソン 2023 @福山
4geru
0
120
Google Form とちょっと 仲良くなった話。
4geru
0
51
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
Designing on Purpose - Digital PM Summit 2013
jponch
115
6.9k
What's in a price? How to price your products and services
michaelherold
243
12k
Building a Scalable Design System with Sketch
lauravandoore
459
33k
Into the Great Unknown - MozCon
thekraken
32
1.5k
RailsConf & Balkan Ruby 2019: The Past, Present, and Future of Rails at GitHub
eileencodes
131
33k
Scaling GitHub
holman
458
140k
Fight the Zombie Pattern Library - RWD Summit 2016
marcelosomers
231
17k
Principles of Awesome APIs and How to Build Them.
keavy
126
17k
It's Worth the Effort
3n
183
27k
個人開発の失敗を避けるイケてる考え方 / tips for indie hackers
panda_program
92
16k
Reflections from 52 weeks, 52 projects
jeffersonlam
346
20k
Creating an realtime collaboration tool: Agile Flush - .NET Oxford
marcduiker
25
1.8k
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ͷΠϕϯτ ڵຯ͋ΕɺࢀՃ͍ͯͩ͘͠͞ɻ