-
Issue with API Call to Update Rows in Smartsheet Using Custom Integration Tool
Hello Smartsheet Community, I am encountering a persistent issue when attempting to update rows using a custom integration tool that interacts with the Smartsheet API. Despite several attempts and adjustments, the API calls are not being processed successfully, and I'm consistently receiving parsing errors. Details of the…
-
How do I share a folder which is located under the Sheets folder?
Although other people are able to see and access the folder, "DigitEYES", located under the Sheets folder. I am unable to give access to it to a new user. I can't find a share function anywhere.
-
3rd Party Connector: "Your Access Token has expired."
Our company uses a few 3rd party connectors to push updates from Smartsheets to other systems. Periodically, all our connections will go into meltdown (we will end up using 40,000+ connection steps in less than 2 hours - normally about 10,000 per month) because Smartsheets is responding with "Your Access Token has…
-
Loading data from excel into Smartsheet API to an existing sheet
I have data in Excel which I have loaded and cleaned in Python and I want to load the same into Smartsheet through API. This data goes into the existing sheet in Smartsheet, which is typically adding new data into the sheet. I have gone through few articles about "Add Rows" but it doesn't explain about loading data with…
-
Apart from Data Shuttle Is there any other method to upload data from Excel to Smartsheet
Hi Team, I need to upload the data from Excel to Smartsheet, already my Smartsheet is having more than 1000 rows, daily I'm getting Excel report from my team once in a day. So while moving data from excel to Smartsheet, it has to check already that data is present or not. If we present need to update the details of that…
-
How to Programatically Collapse All Through Smartsheet API
Hi, I have an automation that builds a smartsheet nightly but every time it does, it leaves everything expanded. I know how to collapse all in the UI. I want to do this step with automation so when the user hits the sheet, it's collapsed after a run. Reading the API documentation, I see you can do this on a per row basis.…
-
Bridge Javascript/Call API & Control Center
Hello all, I have had some success with using the Smartsheet API using the PythonSDK. I am currently using Control Center to create some projects, but they get created in a workspace instead of a folder within a workspace. I have had some success with using the Smartsheet API using the PythonSDK to do something similar, so…
-
C# API access to row attachments
Greetings, I have been able to use the Smartsheet C# API to access sheet and cell data without issues. I added an attachment to a row and attempted to get information about it via the API: // Load the entire sheet Sheet sheet = smartsheet.SheetResources.GetSheet(selectedSheetID, null, null, null, null, null, null, null);…
-
Errorcode: 1008, message: Unable to parse request.
Objective: Adding a row on smartsheet from ERP NetSuite (Uses javascript). The payload generated by NetSuite works perfectly via postman ! URL: https://api.smartsheet.com/2.0/sheets/xxxxxxxxxxxxxxxx/rows?accessApiLevel=0&allowPartialSuccess=false&overrideValidation=false Header:…
-
Get Sheet (ID) by Name using Smartsheet API
I was wondering if there is a way to get the sheet Id of a specific sheet using the name of the sheet. Get sheet accepts the sheet id to get the sheet info, but I would like to get the sheet using the name. In Bridge, you have the option to get sheet by id or name, so I was wondering if there is a way to get it apart from…