-
New sheet not showing up in API
Hello, folks, I have API creds for our Smartsheet instance. When I do the call to the GET /sheets endpoint the new sheet that was generated by an admin is not appearing in the list of sheets. Also, if you call the GET /sheets/{sheed_id} call for the new sheet I get a 404. The sheet exists and it has been shared out to me.…
-
Having Difficulty with Smartsheet API in Excel
I'm looking for examples of calling the Smartsheet API from Excel. I can't seem to get the syntax right.
-
Microsoft CRM
Hi all, I am looking for a solution to bring in data from Microsoft CRM as our request workflow was set up prior to Smartsheet. When a request is submitted for a product update, it is initiated in Microsoft 365 and then an email is sent to me. Is there a way to create an update to Smartsheet without a connector? Maybe…
-
Populating Multi_contact_List column through Alteryx
I have an Alteryx designer reading in tasks from multiple smartsheet schedules that have a responsibles column with multiple contacts. I want to rewrite those contacts into the one schedule I am writing to, but when the contact is read in, it is converted to TEXT_NUMBER and Alteryx won't let me write to the Multi Contact…
-
Message Error in POWERBI 'https://api.smartsheet.com/2.0/home' (500): Internal Server Error
Hi everyone, I use Smartsheet as database for mis PowerBI reportes. The problem is, when i try load the data with Refresh in PowerBI, appears the following message: 'https://api.smartsheet.com/2.0/home' (500): Internal Server Error I tried with another sources, and works fine, the problem is only with Smartsheet. Any…
-
Are others having sporadic API issues? An unexpected error has occurred
In the past couple of days, we've had API processes that have ran fine for months, start to have issues. The error we seem to be most commonly seeing is error code 4000, "An unexpected error has occurred. Please contact the Support team at https://help.smartsheet.com/contact for assistance." We're starting to sporadically…
-
Adding a row is throwing an Error 1018
Hi All, I'm new to Smartsheet API integration, when trying to invoke this API Getting below error { "refId": "b1abd0ba-49cb-4ea8-9944-", "errorCode": 1018, "message": "The value 'sheet id' was not valid for the parameter type 'long'."} Any guidance would be really helpful. Thanks, Junaid
-
Smartsheet login not working with email and code
Hi, I've observed that the new login feature, which involves receiving an email with a code, is not functioning in the Webview2 runtime (Smartsheet OAuth2) and Microsoft Edge browser. FYI: It works perfectly in Google Chrome. Here are the steps to reproduce the issue: 1. Open the Microsoft Edge browser. 2. Enter the…
-
custom button calling rest api
Hi, I have a smart sheet with ids and status. I want to call a rest api, send the IDs and get the current status of those ids. I have already written code which reads the ids list and gets the status and updates the status. All i need is some way to call this api from the sheet itself. Can i create a custom button, which…
-
ServiceNow SaaS licensing integration with Smartsheet
Hello Community, We have successfully established the connection with ServiceNow. However, when attempting to pull user subscriptions from Smartsheet, we encountered an issue where only some users' subscriptions were retrieved, not all. Subsequently, an error occurred indicating:{"errorCode":1013,"message":"The operation…
