ArcGIS Dashboard
Has anyone used the Live Data Connector to connect data from Smart Sheets to ArcGIS Dashboard or to Excel then Dashboard?
Answers
-
I found a similar question to this on the ArcGIS Community, here: Smartsheet link to ArcGIS Online
In this instance, they used the Smartsheet API for the connection. Here's information on the Smartsheet API, and a link to the API Documentation.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Hi @Genevieve P. Can you tell me if this connection can be used with Smartsheet GOV as well, or is this only available through the standard commercial account?
-
Hi @Laurie
I have not personally tried this on a regular account or a Gov account. That said, Gov accounts are able to use the Smartsheet API! Here's more information: https://smartsheet.redoc.ly/#section/Smartsheet-Gov
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
I want to provide an update to this, Make.com does offer this functionality. I am working to solidify a solution I am really still in the discovery phase but will provide a more detailed instruction once we have a success with it. HUGE value here.
CEO | Skyway Consulting Co.
Does your Dashboard need a map that updates from Smartsheet Data?
We pioneered 101+ ways to add a map to a Smartsheet Dashboard.
Smartsheet and GIS Integrations
→ Explore Smartsheet Maps (ArcGIS)
→ LinkedIn
-
Update:
I have discovered the proper way to engage this integration, it is no code and completely native to both Smartsheet and esri.
Schedule a complementary consultation or message me on LinkedIn!
https://calendly.com/take-the-skyway/30min
CEO | Skyway Consulting Co.
Does your Dashboard need a map that updates from Smartsheet Data?
We pioneered 101+ ways to add a map to a Smartsheet Dashboard.
Smartsheet and GIS Integrations
→ Explore Smartsheet Maps (ArcGIS)
→ LinkedIn
-
@Brittney Burton This can be done using python with smartsheet, arcgis imports.
Pull data directly from smartsheet, convert the data to a dataframe using pandas, then export the DF to a temp.csv.
then with the arcgis python import, you can update AGOL hosted feature layer with the csv data.
This can be automated using windows task scheduler, as well.
for more information read this article, which helped me achieve this result.
Sincerely,
Jacob Stey
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 495 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives