-
Pull Data from Power Bi to Smartsheet
Hi, I would like to integrate Power bi with Smartsheet and pull the data on the tables on Power bi to Smartsheet. Is there a way to make this connection ? The reason i need to do this is to make my employee see the data through Smartsheet not from Power bi. Thank you.
-
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…
-
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.
-
Cell last update timestamp from api
Hi, Is there a way to get a cell last update datetime from api, that is not using get_cell_history? I'm asking because get_cell_history is an expensive call (takes 10 tokens).
-
PowerAutomate - Insert row
I am using the the Smartsheet Connector in Power Automate. It all works fine, if I am using "insert row" with a fixed sheet name. But if i want to use a dynamic sheet ID, am ask for row Can anybody help me, what values in which format I have to put in this field. I could not find any documentation.
-
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…