API and Developers

Hi, Need help on how to extract the activity log history of one user in a sheet using the API? is this still possible? Can you write me a short python code to start with?

Hi, I am trying to create a webhook via payload with the request body like the one below, which is an example from the API document, it failed and returned a HTTP status code 400. { "callbackUrl": "https://www.myApp.com/webhooks", "enabled": true, "events": [ "*.*" ], "name": "Webhook for Sheet Creation", "version": 1,…

I am hitting the users endpoint(https://api.smartsheet.com/2.0/users) to get all of our user information. I am trying to find out inactive users based on last login date. The API call doesn't return me the last login information for any user. I can see this information when I export the csv of the users from the admin…

Dear all, I hope this message finds you well. Although I don't have any coding experience, I have been using AppSheet for some time now. Recently, I have been working on integrating Smartsheet into our project management processes, specifically for tracking our projects as a building company. One of our requirements is to…

Hello I have a script that pulls names and emails from a report and updates the dropdowns for a contact list column. I have 4 of these columns on the sheet all with the same conditional formatting. For some reason when I run the script it works fine on 3 of the columns but the last one "WorkOwner" I get a bad request…

Hello All, I am able to get the Row and Column from the smartsheet JSON response but in it there are no metadata. I used things like: params = {'include': 'objectValue,objectProperties,format,formula,columnType,options'} and passed it with the request. But I still do not get any metadata. Specifically, I am trying to get…

This discussion has been merged.

Customers would like to use RM for time and expense tracking. A lot of times, customers are required to submit invoices/receipts to support their expense submission requests. However, within RM their is no ability to do this. My idea is there should be a button within "Add Expenses" that allows for supporting document…

Hi, I'm getting this error message when attempting to create a link from a cell in another sheet (through creating a cell, a row, and then update_rows method). Has anyone seen this error? I'm reading a discussion on another thread that this error is related to some issue with profile data (?), but I can create this link…

Hi, I have a sheet with a million instances of "Used in Formula on <unknown sheet>". Is it possible to delete the "unknown sheet" references using the API and Python code?