Product questions?
Ask it here! The community's got your back.

API & Developers

Connect with other developers from around the world and collaborate on ideas using the Smartsheet API.

R package for Smartsheet
HI, Does anyone know of an R package for interacting with Smartsheet? Are there folks using R with Smartsheet? I am considering a project using R and I might start building out a package. Thanks Craig info@ngsanalytics.com www.ngsanalytics.com
Has anyone used Power Automate or another tool to insert and update records FROM Excel to Smartsheet
We have a file of data in Excel with Macros to another system with confidential data. We want to send rows and update rows to a Sheet in Smartsheet. Has anyone used Power Automate or another tool to do this?
I need to populate and accumulate data from smartsheets into a data ware house.
It seems like the history log would be the best place to pull this information, but I am not seeing a way to pull the history log via API. Pulling the info cell by cell seems cumbersome. Can someone point me in the right direction?
API export to excel to include the rowpermalink
trying to include the rowpermalink in my sheet export according to the API doc the ?include=rowpermalink in the URL should do it however it does not show in the row with all the other data from the sheet. any help would be greatly apprecitated. $URL =…
update request for row (js node)
HI! I use: smartsheet.sheets.getSentUpdateRequest(options) to get a list of all UpdateRequests and their IDs To find out in which row this UpdateRequest I use: smartsheet.sheets.getSentUpdateRequest(options). But there is a problem. I know idRow, how do I remove all UpdateRequest from this row? Or how to easily and quickly…
Is it possible to update a shared with sheet, by the shared with user via the APIs?
I'm updating sheets via the API, I have a sheet that was shared with me, where I have admin level access. Doing a SheetResources.UpdateSheet(sheetObject) returns an unauthorized error on the shared with sheet. Only the sheets that I own seem to be updatable via the API, any sheets that were shared with me, I am not…
Bridge: How do I dynamically pass RowID or Object to child workflow?
Hello, Does anyone know how to use Bridge to dynamically collect the RowID from a parent workflow to use in a child workflow? What I'm attempting to do is have a workflow run daily to look at a sheet and collect any rows with a checkmark for "due today". Then I want the workflow to only take specific data and build a JSON…
Smartsheet API - Is it possible to copy a folder and in the process save calculations as static?
I am new to Smartsheet API and have successfully used the Postman App to copy and save a folder from one location to another, maintaining: data cellLinks attachments discussions filters forms rules My sheets have cross sheet references and calculations. Ideally, I would like to enhance my API process by essentially copying…
How to use access_token? (api.smartsheet.com/2.0/token)
Node.js How to use access_token? I'm making a request: axios.post('https://api.smartsheet.com/2.0/token')... response: { access_token: 'xxx', token_type: 'bearer', refresh_token: 'xxx', expires_in: 604799 } var smartsheet = client.createClient({ accessToken: 'xxx', logLevel: 'info', }); But the result is always the same:…
Smartsheet - Microsoft Dynamics Connector - Where do I find the Workflow ID?
Hello dear members, I am running into some troubles with my Smartsheet - Dynamics Connector, getting about 300 error messages per day for whatever reason. The Smartsheet support team is asking me for a Workflow ID of the broken Workflows. Simple question: Where do I find the Workflow ID ? I am not an admin, though cant…

Popular Tags

Trending in API & Developers

How to obtain sheet "created by" in Bridge for a child workflow
How can I use Bridge API Call OR Get Sheet OR another element to obtain the "Created By" metadata for use in a workflow? I see createdBy in the sheets summary in the SDK: sheetSummary - fields But I don't see it in the output of past runs of either the API Call or the Get Sheet element in Bridge. I see createdDate but not…
How and/or when does a CellLink Object 'status' get updated to 'BROKEN'?
Across our project portfolio, each project has a main project sheet. This sheet has rows added & deleted as tasks are added or canceled from a project. Individual departments have department specific tracking sheets which mirrors the task list in the in main project sheet and certain key values are linked to the main…
URL String - Any common thread between Sheet and Form?
Hi there, I came across a circumstance where someone had a link to the form but forgot where the sheet lives. Is there anything within the URL of the form that can bring you to just the sheet? I tried cutting out the 'form' from the URL, but unsuccessful. TYIA!

API & Developers

Discussion List

Categories

Popular Tags