-
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…
-
API times out
We had a recent problem where a sheet that we update using the API is timing out. While the rows and columns have not increased significantly, we are seeing this issue regularly. Is there a means to fix this? Has Smartsheet recently changed that interval? Thank you.
-
Bridge API?
I have a curious question. I saw in the Bridge Admin settings you can generate an API Key. It seems that bridge has an API that could be interacted with. Is there documentation for that anywhere? Could we use the "Bridge API" to do additional back end functions like changing a workspace name or workflow name?