How do you get APIs to pull from ALM into a sheet with existing columns and automations?

Ann.Cracovaner

I'm trying to get APIs to connect some of our project management documentation with our existing customer-facing documentation housed in Application Lifecycle Management. We have been able to get the calls working and pulling the desired data into Smartsheet, but as soon as we add additional columns (contacts, text and number) or automations to the sheet, the APIs no longer update the data.

Is there a way to adjust this so that we can have other data living in the sheet? Or is there a way to duplicate the data in an existing sheet that will automatically update? We need to have something up and running to get the data out of that sheet and into other documents in a way that will automatically sync updates.

Georgie

Hi @Ann.Cracovaner,

You should be able to build an application to perform the following steps:

1. Use the third-party program's API (if available) to retrieve the data.
2. Process the data within your application.
3. Use the Smartsheet API to add the processed data to an existing sheet.

As you’ve stated that you’ve been able to pull the data into the sheet, but the API no longer updates the sheet after columns or automations are added, I’d recommend reaching out to our Support team to have them investigate why this is happening.

Alternatively, you could use Data Shuttle to import data from other programs into Smartsheet, and/or you could either Create column links between sheets or use DataMesh to map data between sheets. 

Hope that helps!

Georgie