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.

Data Shuttle Data Mesh Schedule Run Times
I have issues with my automated systems failing due to timing both with Data Mesh and Data Shuttle. It is necessary that six Data Shuttle workflows run the same time otherwise they occasionally fail due to them fighting over the same certificate when obtaining information from my cloud account. This causes a catastrophic…
Is it possible to update data in a Smartsheet report directly using Python?
Is it possible to update data in a Smartsheet report directly using Python, or is it necessary to modify the data in the source sheet to reflect changes in the report.
How can I find the row ID of next open row in VBA?
I have VBA code that loops through rows and can give me the row number and row ID of populated rows. It doesn't help me get the next available ID so I can do a put request and add data to an empty row. Currently the VBA just pulls the last populated ID and overwrites it each time. Is there a way to get this??
Alteryx to Smartsheet
Is anyone currently dumping data from alteryx into smartsheets? I would really like to be able to do it. Currently I am outputing to G.S. and then pulling the data into smartsheets via Data Shuttle. It works, but I'd love to cut out the middle man.
API Documentation location
Is there anywhere to access Smartsheet API Documentation that is not on a Libyan domain or github? I am unable to access either of these sites due to security concerns.
Issue: Access token - email based TOTP login
Hi, It seams that we are the first identifing this issue. Already oppened a case at Smartsheet, is in discussion, for now I don't think they've understood the problem. OAuth flow is broken with the new emai based TOTP login (TOTP is One Time Passcode, used to login without a password: ). When I'm using this login method,…
New sheet not showing up in API
Hello, folks, I have API creds for our Smartsheet instance. When I do the call to the GET /sheets endpoint the new sheet that was generated by an admin is not appearing in the list of sheets. Also, if you call the GET /sheets/{sheed_id} call for the new sheet I get a 404. The sheet exists and it has been shared out to me.…
Having Difficulty with Smartsheet API in Excel
I'm looking for examples of calling the Smartsheet API from Excel. I can't seem to get the syntax right.
Microsoft CRM
Hi all, I am looking for a solution to bring in data from Microsoft CRM as our request workflow was set up prior to Smartsheet. When a request is submitted for a product update, it is initiated in Microsoft 365 and then an email is sent to me. Is there a way to create an update to Smartsheet without a connector? Maybe…
Populating Multi_contact_List column through Alteryx
I have an Alteryx designer reading in tasks from multiple smartsheet schedules that have a responsibles column with multiple contacts. I want to rewrite those contacts into the one schedule I am writing to, but when the contact is read in, it is converted to TEXT_NUMBER and Alteryx won't let me write to the Multi Contact…

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