-
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…
-
API issue to add columns to a sheet
This discussion was created from comments split from: Add_Row Data Format.
-
Automatically creating new columns when import data from API
When using API to fetch data from other platforms and import into SmartSheet, how to automatically create new columns, if there are more columns in the data than the target sheet on SmartSheet (right now, importing data from API to SmartSheet need to specify column ID, but when we have a dataset with many columns, this…
-
Shared mailbox does not receive notifications from requests submitted via smartsheet request form
Hi Team, Hope you are doing good. We have built a request form in smartsheet for stakeholders to submit requests to us. When testing, we noticed that when the request is submitted from a shared mailbox (within the company), the mailbox does not receive notifications about request changes/comments added to the request. Many…
-
How to create permanent API key after authenticate by OAuth2
From GUI smartsheet, I can generate an API key for Rest API. But I need to build an application that authenticate user by OAuth2, then can generate a permanent API key. In my context, there is an external application call the smartsheet API with the api key that is generated at time user authenticate via OAuth2.
