API connection from Smartsheets to R
Hi, I am attempting to connect Smartsheets to R. I have tried to use the SMARTSHEETR package but having issues with the code and loading a sheet. Has anyone has success with this and could share their code? Thank you
Answers
-
Hi @DLove
If none of our other members have connected to R using the API, you may want to try posting in the Stack Overflow developer Community to see if someone there has tried this before.
Cheers,
GenevieveNeed more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Hi @DLove
I recently had success with the smartsheetr package in R when also trying to research this topic. I am only needing to pull (or get) data from various sheets, but it has worked for me. You will need to get a Smartsheet API Token in order for the package to work. Cole Johanson (the smartsheetr developer) also has documentation on github how to use the token. However, I would recommend saving the token to your .Renviron file so you don't have to save your token key with any scripts you run.
You can get to your .Renviron file with
file.edit("~/.Renviron")
and save your token within the file as
SMARTSHEET_API_TOKEN='<your key here>'
Then it should be just a matter of running which ever
smartsheetr
function you need, such assmartsheetr::ss_list_sheets()
Best of luck
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives