-
Improved integration with SQL
Hi! I have some grumpy developers with a HUGE ask, likely impossible, but at the very least difficult. If it is easy then roll it out! Have better cel controls where only Text is allowed, or only a real Number, or only an Advanced Number. These are things that MS-Excel cannot do, and if Smartsheet can do there would be…
-
Why HttpClientException is thrown from time to time while using Proxy?
Hi, When I'm using a proxy, I experience a bug that is not always reproducible: HttpClientException is thrown while calling ObtainNewToken from OAuthFlow. AutherizationResult parameter that is sent is always the same. Exception is thrown with message: "There was an issue connecting." Please help in finding a solution.…
-
How to implement SCIM APIs?
Hi, I have a Smartsheet Enterprise account with System Administrator permissions. I'm trying to develop an SDK that will fetch the Users, Groups, and Roles/Membership related information from the Smarsheet SCIM APIs. I've got the SCIM base URL(https://scim.smartsheet.com/v2 ) from the…
-
How to access SCIM APIs?
I'm trying to access the API(https://scim.smartsheet.com/v2/users) by using the Token generated from an Enterprise account with system admin privileges. But, I'm getting an error response as shown below: { "schemas": [ "urn:ietf:params:scim:api:messages:2.0:Error" ], "detail": "This feature is not enabled for your…
-
Is there any Custom Development Feature available like in SharePoint??
We want to have our custom webpage for the Smartsheet functionality. Where we can add or create in any custom webpage in smartsheet like sharepoint? If not is there any workaround for this functionality. Any help would be appreciated.
-
What permission should a user have to add members to a group using API?
Hello, I try to add a user to a group using API. I do it under account with Group Admin role. But unfortunately I get 403 Forbidden response with json { "errorCode": 1004, "message": "You are not authorized to perform this action." } What permissions are enough to perform such operation? Thanks, Michael
-
Internal ERP - Connect to Bridge or Smartsheet API?
I’m struggling to understand the value of Bridge vs Smartsheet API when I need to connect to an internal ERP system. We are looking to display a list of sales orders (from ERP) per each project (in SS). We have thousands of sales orders that are updated constantly and we’d like to see that data near real time Would this be…
-
Is there a way to attach an URL to a proof?
Hello, I am able to create a proof with a link instead of file from UI. But I cannot see such functionality in API. I tried to do a POST request to /sheets/{sheetId}/proofs/{proofId}/attachments with the same JSON body like for adding URL to a row but with no luck - "errorCode" : 1011, "message" : "A required header was…
-
Commenter access level in API
Hello, I have shared a sheet with a user using Commenter access level. But when I request for shares with API I get VIEWER access level in response. How can I get a real value for Commenter access level? Also is it possible to set Commenter access level with API? Thanks, Michael
-
Smart Sheet API GET Rows not wokring
Hi all, I am using the smart sheet api to read and update a rows values. I am performing this task using a python script and then requests library. My current code setup looks something like this ------------------------------------ import requests Test = "_________________________________________" url =…