-
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…
-
How to automatically remove "unmatched" datamesh results from the Target sheet?
Hi Smartsheet SMEs! In DataMesh, selecting the "Copy and Add Data" option will keep the Source and Target sheet in sync --- automatically creates new lookup values if needed. Have you devised a solution that automatically removes/deletes unmatched data --- rows in the target sheet that no longer reconciles to the Source…
-
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…
-
Webhook callbacks need to trigger immediately
We use smartsheet webhook functionality through API and are heavily dependent on it. From few weeks we are seeing callbacks are not getting triggered immediately from smartsheet when event change occurs and it is taking 60 seconds to trigger the callback. I raised a case to possibility of reverting changes as this was a…
-
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…
-
Create Automation Rules with API
It would be convenient if we were able to actually create automation rules via the api rather than just modify. It would also be nice if the API automation functionality was improved, it's pretty limited.
-
Posting to smartsheet using Postman
I'm trying to use postman to pull in some manpower logs from Procore and post these as a new row to a smartsheet. the results are pulling in correctly from Procore, and i have correct sheet and column IDs etc but nothing is posting onto the sheet - it just adds a blank row…. - the raw response i get is as below {…
-
Looking for a consultant to help build intranet/dashboard & basic CRM.
Hello, I am looking for a Smartsheet expert who can help us build a custom dashboard for internal and external use. We are based in Los Angeles, but most of our team works remotely. So are you / or do you know an English speaking Smartsheet expert, who we can hire for support and who has time the coming month? Thank you,…
