-
Get login activity for external users —equivalent to the User Type Report
What's the appropriate method I can use to return the equivalent to the User Type Report that one downloads in User Management? Basically what I want to retrieve is the following info: Email, Highest permission given on assets, Last activity, and Number of asset views by user. With the List Users method I can return the…
-
Export excel file via API
I want to use the API to export an Excel file. While reviewing the latest documentation, I couldn’t find any reference to this functionality. However, I discovered in historical posts that using the Accept: application/vnd.ms-excel header can achieve this. I tested it with the API, and it worked successfully. Could you…
-
Help with Verification Step of Webhook Creation Using Bridge
I am trying to use the Bridge API Call Utility to create a webhook on a sheet. I then want to use the Bridge Inbound Webhook integration to monitor sheet activity via the webhook and trigger a Bridge Workflow. I am able to create the webhook, but I'm having trouble figuring out how to complete the Verification Process. Can…
-
API to Upload a .csv File from Local Folder to a Smartsheet
Hi Smartsheet friends, I've been trying to work out a solution for the below and wanted to reach out to the Community to see if this has been accomplished before or if this is even possible. I also want to preface that I am new to API's and development as a whole. I have a report that automatically runs daily as a .csv…
-
AI Prompts
Is there a comprehensive list of AI prompts for categorizing and summarizing text? I'm currently assuming that there are limitations to what you can use in your prompts. thanks,
-
How to get permalink for sheet in report through API
I'm using the API to retrieve report data - I was hoping it would include a permalink for the originating sheet itself, as it's appears under the "Sheet Name" in the UI but the value returned for that row is just the Sheet name. I'd rather not have to make a second API call to then retrieve the permalink and wanted to…
-
Bridge API Call Error
I'm trying to use Bridge to access the API and sort my sheet. When I run it in Postman, everything works as expected. However, when I run the command through Bridge, I get an error. Error 1004 "You are not authorized to perform this action." I am using the same token and have everything set up according to this tutorial: I…
-
Copy Sheet w API doesn't copy over "Cope Rows" Automation action
I am using the Smartsheet SDK When I copy a sheet using the API (either by copying a template w/ client.Workspaces.create_sheet_in_workspace_from_template or client.Sheets.copy_sheet) I can use the "include" query parameter to capture conditional formatting, forms, and automations copy over, but a specific COPY ROWS action…
-
Value for updating a checkbox
Hello, I am trying to pass in values via Zapier to update a checkbox type field. I have restricted the column so that it will only accept checkbox values. What value should I pass in to check/uncheck the box? I have tried Yes, No, True, False, and some variations in all caps. Thanks! -Zac
-
ERROR while using Unito to sync to Monday.com account
Our Monday.com account has been synchronized with our Customer's SmartSheet account for 6 months flawlessly using Unito. Yesterday it stopped syncing. I contacted Unito support and they confirmed it is an issue within Smartsheet, citing error "The operation you are attempting to perform is not supported by your plan.\"…