ArcGIS Dashboard

Brittney Burton

Has anyone used the Live Data Connector to connect data from Smart Sheets to ArcGIS Dashboard or to Excel then Dashboard?

Genevieve P.

Hi @Brittney Burton

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

Laurie

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?

Genevieve P.

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

Ward.Hively

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.

Ward.Hively

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

 

SteyJ

https://community.smartsheet.com/discussion/82441/arcgis-dashboard

@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.

https://community.esri.com/t5/arcgis-api-for-python-blog/updating-arcgis-online-hosted-feature-layer-with/ba-p/1113966