-
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.…
-
Smartsheet Bridge: New Junction
Hi, I am exploring the "New Junction" in Bridge. When I add a value in Context using the dropdown, e.g. sys-animals, Bridge complains of unsupported module. Can someone please shed some insight into how the Context and Values To Check For can be used? Regards, AK
-
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…