Combine data from smrtsheet EDW and sharepoint

vkelex

vkelex ✭

08/29/24 in API & Developers

I have set of smartsheets with fixed set of columns. I need to combine data from those sheets, EDW and sharepoint. Then create a template out of it. Is it possible to use power automate. Suggest some examples to start with and using connectors.

0 ·

Categories

Trending in API & Developers

Smartsheet API - Is it possible to create a copy of a sheet and maintain the row and column IDs?
Is it possible to use the Smartsheet API to create a new sheet from a copy of an existing sheet, but maintain the row and column IDs? Ideally the output would be 2 sheets with unique IDs, but the row and columns within each would have identical IDs
How can I obtain the URL for a form that is attached to a sheet ?
I need to obtain the FORM URL that is associated with a sheet that is copied via API so that I can populate the URL in a cell. I was reading over the API documentation and cannot seem to find where this is possible. I know this has been asked sporadically and apologies for the duplicate asks, but this seems like such a key…
Order of the Columns
Hi everyone, I didn't find this answered anywhere, but is it possible to change the order of the columns using the API/SDK? I have a large number of sheets that I want/need to keep separated but I would like to standardize them with a defined order of the columns. Is it possible to get an attribute like "column order" and…