-
API to provision (copy template folders) in SharePoint from SmartSheet
Has anyone created an API app to provision a set of template folders in SharePoint. Basically to copy and rename as required? I think I can do this via MS Power Automate, but a moire direct may be better.
-
Automatically Organizing Rows into Hierarchy
Hello SS Developers! I am both a formula and API-deficient SS user. I believe my question should be directed toward the API/Developer community, as I asked the AI formula developer tool to create a formula for this request and it stated, "Smartsheet formulas cannot be used to automatically organize rows into hierarchy". I…
-
Admin - update user email address
It seems that there are only 2 ways to update a user's email address. 1) I have to create a new account, have that user accept the invitation, and then merge those two accounts together 2) Have the user login and update their email address. While it seems simple to have users go in and update their email address, this is…
-
Attach a file to a Row
Hello, I am unsure what this is and how to get it in order to attach a file to a row in Smartsheet. Can someone please help? Examples would be great. Thank you!
-
Long-working API requests now responding with 500 "Unexpected Error (ExtAuthN)"...
API requests like the following (that have been working flawlessly for months)… GET /2.0/sheets/542002634510212?level=2&include=objectValue" are suddenly responding with 500 errors and the message "Unexpected Error (ExtAuthN)". Status page does not show an issue. Can you help debug?
-
Using Copy Sheet API to copy column data and not formulas ?
I am trying to use the Copy Sheet API call to take a snapshot and archive on a weekly basis what has been entered into a source sheet. The source sheet has many formulas but I only want the data copied over. So far the source sheet is getting cloned over with formulas. I cannot have the copied formulas in the target sheet…
-
Using a Cross Reference Sheet to update column using API
I'm looking to update a dropdown list referencing a column on another sheet using API. Reading through API documentation, it looked like I needed to create a cross reference sheet. How do I now use this new Cross Reference Sheet to update the column dropdown in my target sheet? Thank you!
-
Editing/Updating ContactList or Dropdown Items via the API
Hi guys. We are making good headway pushing data from our CRM to SS with the API with VB and C#. One of our sheets needs to have a column with a list of (regularly changing) people for the users to select from in a ContactList or Dropdown control. I believe it is not possible to draw these lists from another source sheet…
-
Run a cell value from an array multiple times for an API GET request call?
Is it possible to process an array containing the cell value (the array would be rows) in an API call in Smartsheet Bridge? I have this scenario: I have a trigger that activates every time a value changes in a Smartsheet column. The way it runs helps to retrieve row by row and take the data I need to make an API call. I…
-
Downloading Row Attachments using Alteryx
Hello, Has anyone been successful with building something in Alteryx that would download the row attachments in a Smartsheet?