API & Developers

Archives for July 2018

Multiple selection on a drop down list
Hi, I read in another tread that the ability to select multiple items in a dropdown list was in development. Does anyone know if that is available now?
API Bug: GetSheets returns rows with null SheetId
I'm running into an issue where SheetResources.GetSheet and SheetResources.UpdateRows are returning rows with a null value for their SheetId. Has anyone else run into this issue? I'm not passing in any parameters other than the target SheetId. I'd like to determine if I have a configuration issue or if this is a bug in the…
Smartsheet to Outlook Tasks
In my Smartsheet projects, in addition to the usual statuses of "complete", "in progress", etc. I have a status called "Action Item" where I designate items that I personally need to take care of. Is there a way to make these items appear as "tasks" in my Outlook? (reason: I prefer to block off times for my tasks in my…
API Error Messages are (truncated)
This must be a simple setting somewhere, but my searches have not found one. Messages such as: Uncaught Exception: Client error: `PUT https://api.smartsheet.com/2.0/sheets/8176365615769476/rows` resulted in a `400 Bad Request` response: { "errorCode" : 1008, "message" : "Unable to parse request. The following error…
Smartsheet to SharePoint
Can Smartsheet integrate with Microsoft Flow and be triggered by a Smartsheet row update vs a sheet update. I want to flow updates from my Smartsheet by row/item to a SharePoint list by item.
Smartsheet for Outlook only works on default email account.
I installed the Smartsheet for Outlook App and it works fine *BUT* it only shows up on my default email. I am running Outlook 2016 on Windows 10 and I am using Outlook to access 7 emails accounts, both business and personal (a mix of MS Exchange, Pop, IMAP) . I have installed "Smartsheet for Outlook" and it works fine on…
Populate a Sheet from SQL server query (C#)
Hi Everyone, I need some help with a fairly simple task we are trying to accomplish -but i am having some hard time getting it to work - We are reading from a SQL server and some of the result needs to be populated into Smartsheet. As i am using Dataset - and trying to update each value on the variable "ProjectName" into a…
Embedding Smartsheet Calendar to SharePoint Calendar
Hello, I am trying to get a calendar on Smartsheet to sync with a SharePoint calendar. I have realized that there needs to be a flow involved to connect the two. When I try to set up a flow on SharePoint it does not connect on Smartsheet. Thank you!
Smartsheet Dashboards vs Live Data Connector Integrations
Hi everyone, Has anyone used the live data connector to integrate with another platform such as Qlik or any other? I know that SM now has the dashboard view, but I do not think it is as powerful as other BI platforms. From what I see, the SM dashboard is a very high level overview and does not give the level of detail that…
Integrating User Profile into Dashboard
Hi, I want to see my project team on the Dashboard (with the profile picture and designation). Can we add Smartsheet users dynamically to the dashboard? thanks

Trending in API & Developers

Smartsheet API Call
Hello Team, Please let me know the best way to make an API call from Smartsheet to request data from another tool and how to handle the response. I know I need to use a GET request to make the API, call but I am not sure how to handle the response in Smartsheet. Many Thanks,
Do you know if you can add a custom code in values (pink rectangle) - Bridge Workflow?
Do you know if you can add a custom code in values (pink rectangle) in this Bridge workflow that is updating a SharePoint list any time changes are being made in the relevant Smartsheet Table? Basically this workflow is working as expected with one issue: for every empty cell, the workflow will update SharePoint with the…
Number values containing 'Apostrophe after being imported from Excel
Greetings All ! looking for some assistance regarding an integration issue I've picked up when importing data from Excel to Smartsheet's using MS FLow , i.e. Excel->MS Flow-> Smartsheet I am inserting an integer but the value on Smartsheet contains an apostrophe before the number which is not ideal as i am using these…

API & Developers

Discussion List