-
Ability to use public facing ID in the permalink to access objects through the API
Smartsheet Objects (Sheet, Report, etc) consist of two identifiers, the object's ID and the public facing string found in the permalink (PUBLIC_ID). Example of a Permalink: https://app.smartsheet.com/sheets/{PUBLIC_ID}?view=grid Navigating to File, Properties a user can find the ID and the share url which contains a…
-
Aderant integrations
Has anyone used Aderant API or data to sync with Smartsheet financial data? I'm curious on the connectors available or if only a token is required.
-
Smartsheet Automations and API/Webhook Calls
Hi there, We have a sheet then when an item in the sheet is marked as complete it is moved to an Archive sheet using Automation. The problem is there is so much data in a short period of time that we hit the sheet cell limit and have to export the data out into a CSV. I am wondering if there is a way using automation to…
-
Issue in using Smartsheet CSharp SDK in SSIS Package
Hi, I am using Smartsheet CSharp SDK in SSIS Script Task. I added it by nuget package, but getting error as below : Error CS0246 The type or namespace name 'Smartsheet' could not be found (are you missing a using directive or an assembly reference?) Then, I downloaded Smartsheet CSharp SDK and added reference to the dll…
-
API "Search" Endpoint: Offline?
Is the "search" API endpoint nonfunctional at present? All other endpoints seem to be functional on my end (sheets, folders, etc.). This has been tested with both the requests library in Python and in Power Query web requests in Power BI. PQ web requests returns a 500 internal server error. The Python web request returns…
-
Automate sheet creation
Can I use automation to trigger the creation of a new sheet? Here's the situation. I have a form that adds a new row to a sheet. I would like to evaluate the primary key's value against what already exists in sheet and do one of two things: if the value already exists add the row to the existing sheet for that primary…
-
emergency - recent systemic failure of prior working API calls to create sheets from templates
Hello - sometime in the last 24 hours, there has been a change in behavior of the REST API w.r.t. creating sheets from templates in workspaces. Previously working API calls are now failing with a 404/1006 not found error, which seems spurious. The same token/user is able to create sheets by copying other sheets, is able to…
-
is it correct passing time frame as an object to resource management reports API?
Hello, When connecting to the report rows endpoint, I am receiving an error when using the timeframe as shown in the API documentation. "time_frame":{ "from": "2022-01-01", "to":"2022-12-31"} Error message received: {'message': 'to is not a valid time_frame'} I also tried to pass the 'from' and 'to' as a separate parameter…
-
Dynamic View won't let us choose a drop down item in the details panel
I have a dropdown list of a few statuses that I added to our details panel. It worked yesterday but now isn't. An error populated once that says 'you have invalid changes. Please review and try again' but now that doesn't populate- it just won't save.
