-
Any help in understanding record limit in API?
Hi there. Full disclosure - I know almost nothing about API's…despite REALLY wanting to learn. That said… I'm trying to use the Smartsheet API inside of Alteryx to pull data from a Smartsheet report. Someone sent me an Alteryx workflow for that purpose, and it works, but it won't pull in all the records. My Smartsheet has…
-
Cell last update timestamp from api
Hi, Is there a way to get a cell last update datetime from api, that is not using get_cell_history? I'm asking because get_cell_history is an expensive call (takes 10 tokens).
-
Bridge error: Plugin Error: A required parameter is missing from your request: ids.
This discussion was created from comments split from: Bridge: Way to delete all rows in a sheet.
-
API data transfer error. HELP!
I am trying to do a transfer of data from a CSV file to an existing smartsheet. Because I need to import 167K rows, I want to do it programmatically. The script seems to work for a bit, but then I get an error that I can't seem to resolve. Here's the error I am getting: {"response": {"statusCode": 400, "reason": "Bad…
-
Dashboard Widget API
Hi All, Wanted to see if there was a way in the API to update the URL stored in the web content widget. From what I can tell I can modify the name and size/formatting properties of the widget, but am missing if I can write into the URL parameter.…
-
When I Copy Workspace, Everything Copies Fine Except for CellLinking
Hi, Using the API documentation, I'm able to copy entire workspaces which has been great for scalability. I've been noticing that the only thing that doesn't work correctly out of all the sheets, reports, and sights, is the cellLinks in my sheet. In the instructions, you can tell it all the different things to pull in. I'm…
-
Get cell history of all the rows in a column
Hello, This is a very urgent requirement I received from my team. They want the history of all cells in a column. I've spent quite a few hours exploring Smartsheet forums. However, the only solution I found was by adding the ID of each row and column individually via API to get the cell history of that particular cell. I…
-
File attachment using Node SDK
Hello, I am trying to add a new row and then attach a file to it using the smartsheet Node.js SDK. The first part of this is no problem, I can add a row using the SDK without issue. The problem is with uploading files, the post request from the smartsheet client takes a while to resolve and eventually I get the following…
-
Using Zapier to update a Form Sheet
Hi! I would love some insight on if I can use Zapier integration to update a form sheet. I created a form for new job requisitions. I need to be able to receive updates from our legacy system as the status changes for each job req. Data Shuttle is not an option as the enterprise does not plan to support it. Could Zapier…
-
Delete/Remove/Clear Hyperlink using API
While there are a wealth of articles, discussions, and examples of adding and updating hyperlinks in cells using the Smartsheet API, I struggled to find any concrete guidance on how to remove a hyperlink or clear a cell that contains one via the API. I need the equivalent of going into the sheet, hitting "Delete" in the…