-
startingNumber ignored?
I appear to be having the same issue as described in this post from 2021. PUT { "type": "TEXT_NUMBER", "systemColumnType": "AUTO_NUMBER", "index": 1, "title": "Auto", "autoNumberFormat": { "prefix": "10", "fill": "000", "startingNumber": 1, "suffix": "" } } is returning { "message": "SUCCESS", "resultCode": 0, "version":…
-
Smartsheet API - Add sheets to existing sheets.
Hello, Is there a way via the API to be able to add existing sheets to another sheet under a different folder. We are currently doing this manually.
-
Snowflake Data into Smartsheet?
Hey everyone, Do you know if there is a way to connect Snowflake data into Smartsheet using the API? I have found many resources on getting Smartsheet data into Snowflake but nothing on the other way around. We are trying to either do something native within Smartsheet or use an open-source software such as Airbyte.
-
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…
-
Webhook delay with attachments (1-2hours!)
Hello! I'm using webhooks to notify me when a file is attached either to a sheet or a row. Sometimes I get a notification after the usual delay of ~1 minute, however I regularly see cases where there is a delay of around 1-2 hours. I don't see this delay when making row/cell changes to the sheet. I always get the webhook…
-
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…