-
Enable Premium Apps on user accounts via API
Enabling Premium Applications on user accounts via API is currently not available. The "admin" api that runs the admin web page does have this capability, but the public API does not.
-
Uploading Attachments within RM Time & Expenses Tab
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…
-
Error 5262: "Unable to create the requested cell link(s). The source data is no longer accessible."
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…
-
Inbound Links
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?
-
What is the maximum limit of batch size to insert, update, or delete the rows?
Hi, For https://smartsheet.redoc.ly/tag/rows API for "Add Rows", "Update Rows" and "Delete Rows", how many records can we insert, update and delete per call request? Is there any limitation in the number of rows or batch size? If so, what's the limit and what kind of error would we receive beyond the limit? I did not…
-
Trying to connect Acumatica to Smartsheets
I keep getting an error and cannot find any explaination anywhere. There error says Unable to parse request. The following error occurred: Field "value" was not parsable. value must be a primitive type at [Source: java.io.PushbackInputStream@318c0afb; line: 1, column: 1012]. Could someone explain what I am doing wrong
-
Remove licenses from users using SmartSheet API
Hello all. I have a list of users who I want to transition to free collaborators. I want to do this using the API. I first tried using the deactivate method but it doesn't reclaim the license. It just blocks access to Smartsheet. I also tried using the update user method. The user sees that they are unlicensed. However, in…
-
Is it possible to create bulk/multiple sheets using Create Sheet API in a single call?
Is it possible to create bulk/multiple sheets using Create Sheet API in a single call? FYI: I am aware of looping the request to create multiple sheets, but how can I perform bulk creation within a single call? Please help me with knowing how to achieve this. The response schema in the API documentation allows me to think…
-
Automation trigger question
I'll try to describe the issue as best I can: I have a notification automation that is triggered by a row change (an attachment is added). The automation must also meet two conditions, both of which are checkboxes that must be checked to satisfy the two conditions. The first of these checkboxes triggers an earlier…
-
When Power Automate inserts data in Smartsheet, how to work correctly with formatted columns?
I have a Microsoft Form that my sales team fills out when they win an order. I have created a Power Automate flow to create a new line in Smartsheet and insert this data. I am using MS Forms + Power Automate and not Smartsheet's form because it also performs other actions outside Smartsheet. However, on the columns that…
