-
Parsing Multi Picklist through API
Hi everyone, I just started working with the SmartSheet API. So far, everything has been straightforward, except one thing; I am trying to submit new rows to a sheet but can't seem to get the value of the Multi Picklist right. If submitted as a string in various formats, the value only displays as one long tag including…
-
Error using Invoke Web Service
URL: https://api.smartsheet.com/2.0/workspaces Method: POST Accept: Application/json Custom Headers: Authorization: Bearer %my API Code% Conent-Type: application/json Content Type: Application/json Request body: %RequestBody% Save response: Get text into variable (for web pages) Variables produced WebServiceREsponseHeaders…
-
BRIDGE/API: Add Users to Group from Sheet?
Hey Y'all! I'M STUCK on the next step for my Bridge solution. I'm simply trying to add members to a group named "GroupTest" if the [Approval Status] in this sheet (image below) gets marked as "Approved", but only if it's not already in the group. Eventually, I also need to have the status of "REJECT" remove them from the…
-
Update Smartsheet table with data from SQL DB
HI there. I'm not very familiar with SMartsheet yet, but i'm gradually getting the hang of it. I succeed to connect a sheet in PowerBI with the integrated connector, and now I need a step forward: I have some data in SQL tables and i'd like to take those data from SQL BS server and upload a table in Smartsheet. I was…
-
Update sheet via API with bridge
Hi everyone, I had an objective to update a sheet with information coming from a 3rd party website. I've managed to make a first workflow with Bridge that works: I'm calling the API, receiving an array of data, then I have a child workflow to add a row for each line from the array. It works. But I have 6000 lines to come…
-
Have you seen a change in the time taken to trigger a WebHook?
I use WebHook in a number of places in our Smartsheet system. In the past after a sheet was saved, WebHooks would fire and be received within a few seconds by my servers. Now I am seeing a consistent 60 second delay after save for WebHooks to contact my servers. I think this change has happened in the last 6 months. For…
-
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…
-
Monday.com integration with smartsheet
It would be nice if someone could guide me on how Monday.com can be integrated with a smart sheet, as we manually enter data in both platforms.
-
Bridge Get Row Id not showing.
Good Afternoon I am new to Bridge and trying to create my first simple workflow to move rows but, I am having an issue with getting the row id. I have tried following the steps in other threads I found with no luck there is something I must be missing. I have a sheet where form entries are submitted. I setup the Smartsheet…
-
Can I get help in understanding the SmartSheet refresh token lifecycle ?
Can I get help in understanding the SmartSheet refresh token lifecycle ? I recently created a new managed Oauth App and noted down its clientId and secret. Using these 2, I generated an auth code and then generated access token and refresh token. From other forum post, got to know that refresh token doesn't have expiry.…