Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Sign up for free
Menu
Search
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Pricing
Search
Sign in
Sign up for free
start-salesforce-with-r
Search
bk
September 19, 2020
Programming
940
0
Share
Embed
Copy iframe code
Copy JS code
Copy link
Start on current slide
start-salesforce-with-r
https://watagusa.hatenablog.com/entry/2021/01/09/184155
bk
September 19, 2020
Transcript
45 slides
RͰ࢝ΊΔSalesForce ʙsalesforcerʹΑΔSalesForceσʔλૢ࡞ʙ
࣍ ఆࢹௌऀͱత……………………………………………………Q ࠓ͞ͳ͍͜ͱ……………………………………………………Q SalesForceͱ………………………………………………………Qd salesforcerͱ………………………………………………………Qd ΦϒδΣΫτͱ……………………………………………………Qd SOQLͱ………………………………………………………………Qd Ϩϙʔτͱ……………………………………………………………Qd ࢀߟจݙ……………………………………………………………………Q salesforce
ఆࢹௌऀͱత త ఆࢹௌऀ جຊ༻ޠʢΦϒδΣΫτɺSOQLʣ ΛRΛ௨ͯ͠ཧղ͢Δɻ • SalesForceΛ໊લ͔͠Βͳ͍ • R༻͍ͯ͠Δ •
ϚʔέςΟϯάͱؔΘΓ͕͋Δ • GUIʹ৮Γͨ͘ͳ͍
ߴͳ͜ͱ → ೖฤͳͷͰ ։ൃͷ͜ͱ → ҰൠϢʔβʔΛఆʢDeveloper Consoleͪΐͬͱ͏ʣ Ϩϙʔτܥ → ௐࠪෆͷͨΊʢεϥΠυ͋Δ͚Ͳؒҧ͍͋Δ͔ʣ
ࠓ͞ͳ͍͜ͱ
SalesForceͱ salesforce
SalesForceͱ Salesforceɺاۀͱސ٬Λͭͳ͙ސ٬ཧιϦϡʔγϣϯɻϚʔέςΟϯάɺӦ ۀɺίϚʔεɺαʔϏεͳͲͯ͢ͷ෦ॺͰɺސ٬ҰਓͻͱΓͷใΛҰݩతʹڞ ༗Ͱ͖Δ౷߹CRMϓϥοτϑΥʔϜͰ͢ɻ https://www.salesforce.com/jp/products/what-is-salesforce/ https://www.salesforce.com/campaign/worlds-number-one-CRM/
https://www.salesforce.com/jp/hub/crm/what-is-crm/ SalesForceͱ CRMͱʮCustomer Relationship ManagementʯͷུͰɺຊޠͰʮސ ٬ؔཧʯͱݺΕ·͢ɻސ٬ͱͷؔੑɺίϛϡχέʔγϣϯΛཧ ͠ɺࣗࣾͷैۀһͱސ٬ͱͷؔΛҰݩతʹѲͰ͖ΔΑ͏ʹ͠·͢ɻ
SalesForceͱ ຊແྉͰ৮ΕΔσϞΞΧϯτͰਐΊΔɻ https://developer.salesforce.com/signup
SalesForceͱ σϞΞΧϯτొྃޙͷτοϓϖʔδɻ
ͰͬͯΈΑ͏
salesforcerͱ
https://stevenmmortimer.github.io/salesforcer/index.html salesforcerͱ ϦϦʔεɿ ࠷৽Ξοϓσʔτɿ ։ൃऀ໊ɿSteven M. Mortimer ʢݱࡏʣ RͰSalesForceΛૢ࡞Ͱ͖Δlibraryɻ
salesforcerͱ or OAuth libraryΛΠϯετʔϧޙɺೝূใΛઃఆͯ͠ଓɻ Ϣʔβʔ໊ɺύεϫʔυɺηΩϡϦςΟτʔΫϯ͕ඞཁɻ ʢIP੍ݶֻ͕͔͍ͬͯΔͱηΩϡϦςΟτʔΫϯ͕औಘͰ͖ͳ͍ʣ
sf_user_infoͰଓใͷ֬ೝɻlistܗࣜͰฦ͞ΕΔɻ salesforcerͱ
ΦϒδΣΫτͱ
ΦϒδΣΫτͱ ΦϒδΣΫτ ≒ ςʔϒϧ
ΦϒδΣΫτͱ SalesForceͷ্෦ʹλϒঢ়ʹ͋Δɺͻͱͭͻͱ͕ͭΦϒδΣΫτɻ
https://trailhead.salesforce.com/ja/content/learn/modules/lex_salesforce_basics/lex_salesforce_basics_welcome ΦϒδΣΫτͱ ΦϒδΣΫτʹॳΊ͔Β༻ҙ͞Ε͍ͯΔʮඪ४ΦϒδΣΫτʯͱɺϢʔ βʔ͕࡞͢ΔʮΧελϜΦϒδΣΫτʯ͕͋ΔɻԼͷਤඪ४ΦϒδΣΫ τͷҰ෦ɻ
ͰΦϒδΣΫτҰཡΛऔಘ͢Δ
ΦϒδΣΫτͱ sf_list_objectsͰऔಘɻlistܗࣜͰฦ͞ΕΔɻ
ͰΔͱʁ salesforce
ΦϒδΣΫτͱ ઃఆ͔ΒDeveloper ConsoleΛ։͘ɻ
ΦϒδΣΫτͱ File͔ΒOpen ResourceΛ։͘ɻ
ΦϒδΣΫτͱ ݕࡧ૭Ͱʮ.objʯͰऴΘΔͷΛݕࡧɻ
SOQLͱ
SOQLͱ SOQLʢSalesforce Object Query Languageʣ ≒ SQLʢ*Structured Query Languageʣ *ANSIن֨ͷSQLͱ͍͏໊শެࣜʹԿͷུͰͳ͍ͱ͞ΕΔɻ
http://e-words.jp/w/SQL.html
ͰΦϒδΣΫτͷதΛऔಘ͢Δ
SOQLͱ sf_queryʹจࣈྻΛ͢ɻFROMʹΦϒδΣΫτΛࢦఆɻ
ͰΔͱʁ salesforce
ઃఆ͔ΒDeveloper ConsoleΛ։͘ɻ SOQLͱ
SOQLͱ Query EditorΛબ͠ɺΫΤϦΛهड़ɺExecuteΛԡ͢ɻ
SOQLͱ தԝͷը໘ʹ݁Ռ͕දࣔ͞ΕΔɻ
Ϩϙʔτͱ
Ϩϙʔτͱ Ϩϙʔτ ≒ ΦϒδΣΫτΛूܭͨ͠ͷ
Ϩϙʔτͱ τοϓϖʔδͷλϒʹଘࡏ͢Δɻ
ͰϨϙʔτΛ࡞͢Δ
Ϩϙʔτͱ sf_create_reportͰϕʔεͷϨϙʔτΛ࡞͔ͯ͠ΒɺϑΟϧλΛઃఆͯ͠ sf_run_reportͰ࠶࡞͢Δɻ
ͰΔͱʁ salesforce
Ϩϙʔτͱ Ϩϙʔτը໘ͷNew Reportʢ৽نϨϙʔτʣΛ࣮ߦɻ
Ϩϙʔτͱ ूܭରͱͳΔΦϒδΣΫτΛબɻ
Ϩϙʔτͱ FilterͰ݅Λઃఆɻ
Ϩϙʔτͱ ूܭ݁Ռ͕ը໘தԝʹදࣔ͞ΕΔɻ
·ͱΊ SalesForceͱ salesforcerͱ ΦϒδΣΫτͱ SOQLͱ Ϩϙʔτͱ CRMϓϥοτϑΥʔϜ RͰSalesForceΛૢ࡞͢Δlibrary SalesForceͷςʔϒϧ SalesForceͷSQL
ΦϒδΣΫτΛूܭͨ͠ͷ
ɾTRAILHEAD https://trailhead.salesforce.com/ja/home ɾGitHub, ʮAn Implementation of Salesforce APIs Using Tidy
Principles • salesforcerʯ https://stevenmmortimer.github.io/salesforcer/index.html ɾCRAN, ʮPackage salesforcerʯ https://cloud.r-project.org/web/packages/salesforcer/index.html ɾQiita, ʮΤϯδχΞͷͨΊͷsalesforceೖʯ https://qiita.com/tarokamikaze/items/0bc2988534f63d4b65c5 ࢀߟจݙ
ENJOY!
More Decks by bk
See All by bk
Befriending Kurtosis with R
bk_18
1
1k
tidy_rpart
bk_18
1
1.8k
dotdotdot_in_predict_function
bk_18
1
1.2k
Introduction_of_GoogleAnalytics_with_R
bk_18
2
1k
web scraping with polite package
bk_18
2
860
Missspell Detection
bk_18
1
180
About Missing Values
bk_18
1
430
Other Decks in Programming
See All in Programming
クラウドエージェントは、 何がそんなに便利なのか / what makes cloud agents so useful
rkaga
5
890
止まらない比較を止める — 余帰納法で無限ストリームを比べる
tarao
0
180
作れるエンジニアから、価値を届けるエンジニアへ
ryunakayama
1
290
TS 7.0 で baseUrl が使えなくなった今、パスエイリアスをどうするか
bicstone
2
670
GraphQL の onError と Nullability のこれから
quramy
0
220
Будущее локальных LLM – Алексей Голобурдин, PythoNN
sobolevn
0
120
なぜ私たちは「現時点では」KMPの導入を見送ったのか
chigichan24
1
270
AIで開発が速くなった先で、開発チームは何を目指すか
shihochan
1
2.1k
Augmenting AI with the Power of Jakarta EE
ivargrimstad
0
330
社内AIエージェント「Askワンバン」における コストチューニングの取り組み
t0yohei
0
170
React Native에 현대적인 빌드 도구 더하기: Rollipop 구현기
leegeunhyeok
0
180
学びを記事・スライド・Xへ高速展開する― AI-assisted Learning Loopで回すコンテンツ生成術
ochtum
0
210
Featured
See All Featured
Abbi's Birthday
coloredviolet
5
11k
GitHub's CSS Performance
jonrohan
1033
470k
Primal Persuasion: How to Engage the Brain for Learning That Lasts
tmiket
0
520
職位にかかわらず全員がリーダーシップを発揮するチーム作り / Building a team where everyone can demonstrate leadership regardless of position
madoxten
70
69k
実際に使うSQLの書き方 徹底解説 / pgcon21j-tutorial
soudai
PRO
203
77k
Paper Plane (Part 1)
katiecoart
PRO
3
12k
How to Grow Your eCommerce with AI & Automation
katarinadahlin
PRO
2
350
SEOcharity - Dark patterns in SEO and UX: How to avoid them and build a more ethical web
sarafernandez
0
330
Building Flexible Design Systems
yeseniaperezcruz
330
41k
svc-hook: hooking system calls on ARM64 by binary rewriting
retrage
2
680
Why Mistakes Are the Best Teachers: Turning Failure into a Pathway for Growth
auna
0
350
Leveraging LLMs for student feedback in introductory data science courses - posit::conf(2025)
minecr
1
480