-
Keeping the API token secure on a shared hosting website. Using PHP
I have a website on shared hosting. I know that I should keep api tokens out of public_html folders on said website. I would like to use a <domain>/config/config.php file to hold those api tokens for Smartsheets. This approach is working for another application that I integrate with from this website. However, when I put…
-
Update Columns API Possible Bug - unable to clear all options in a MULTI_PICKLIST column
NOTE: I tried to file this several times a support ticket, but the AI BOT was unable to create a ticket and the OG Support Portal no longer allows the direct creation of tickets. Grrrrrr. ISSUE: It appears that the Update Column API PUT https://api.smartsheet.com/2.0/sheets/{sheetId}/columns/{columnId} fails to work as…
-
Power Automate EU connection
Hi, We just recently moved to the EU domain and I can't find a way to login within the microsoft connectors to update the flows I was suing on the US. Is there currently a solution? Thanks
-
Will and API token for a report give access to the Sheet the Report generated from?
Hi, I have a large Smartsheet, I want to generate a row report that reduces information displayed down to a specific group. For that Row Report, if I were to generate an API token and share it to a third party, will that third part have access to the information on the original 'Grid' sheet, or will it be reduced to what…
-
Smartsheet API Deprecations risk?
Without being an administrator (or even in the IT dept), how do I know if my organization is at risk for the Smartsheet API Deprecations events?
-
How do you get APIs to pull from ALM into a sheet with existing columns and automations?
I'm trying to get APIs to connect some of our project management documentation with our existing customer-facing documentation housed in Application Lifecycle Management. We have been able to get the calls working and pulling the desired data into Smartsheet, but as soon as we add additional columns (contacts, text and…
-
Delete all available time entries in Resource management
Hi Team , I'm looking for a way where I can fetch and delete all available time entries from Resource Management preferable programmatically using python. If not I'd like to know more if there an option to do that in a different way which can help delete all time entries in one simple way.
-
API Integration with Epicor P21
We are currently implementing Epicor P21 as our new ERP system and are considering setting up the API integration with Smartsheet. Is anyone else utilizing the API Integration with Epicor P21? How is it working for you? What has it been most helpful for? Thanks!
-
How do I programmatically update Start Date, End Date, Duration and Allocation %?
Hello everyone, I am working with the python smartsheet SDK, and I am experimenting with a smartsheet connected to Resource Management, which comes with a number of default columns - few of them are Start Date, End Date, Duration and Allocation %. I see in the Python API documentation that these 4 columns are not allowed…
-
(500) Internal Server Error - Power BI
Hi All, I use Smartsheet as a data source often in Power BI. For the last two years I have never had an issue with Smartsheet's API, but today I have been getting a "Web.Contents failed to get contents from <insert smartsheet URL here> (500): Internal Service Error. Is this happening to anyone else? Or is this just a me…
-
API / Integrations between Smartsheet and Maconomy
Has anyone connected Maconomy with Smartsheet to bring information from Maconomy to Smartsheet
-
Are Automations the BEST WAY to clear a sheet before a Bridge Workflow is run?
I've seen various ideas on how to clear a sheet using bridge before beginning a workflow. However, could it be as simple as this?: Add a checkbox column such as "Delete Row" Use Bridge to change all rows to be removed using an "update sheet" in Bridge. Use automation to move rows out when the row is checked instead of a…
-
API calls succeed but data requires manual File > Save to persist
API returns HTTP 200 SUCCESS Activity log shows "Rows Inserted" No data appears in sheet until manual File > Save. Data can be manually added (by a human) to the same sheet, but the data is not persistent until after File > Save. Browser correctly warns that leaving the page will lose the data. Activity log does not show…
-
Bridge: "Required object attribute(s) are missing from your request: row.id." (JSON Formatting)
I'm not kidding when I say I've spent 8+ hours on this. I'm no programmer so ChatGPT has been pretending to fix it for me, unsuccessfully. I have the problem narrowed down to the JSON output. ChatGPT keeps asking me to update my code and the HTTP Request body in various ways without much change. You'd think this would be…
-
Bridge: Variables Passing Through to Child as Text, Not a Value. "{{variable}}" instead of 123124932
WORKFLOW PURPOSE: first it gathers and populates our entire users list to a sheet. This child workflow is supposed to use /users/{{userId}} to populate the DETAILS of each user onto the matching row that was just populated. But… I can't get Smartsheet Bridge to pass-through the variables I've set to the Child Workflow.…
-
Bridge: Stuck! GET /users/{{inputs.userId}} Child Flow not running
I can't get my child CHILD WORKFLOW B (See Below) workflow to run. I've been on ChatGPT all day and it keeps making me run in circles. It works GREAT up until Child workflow B. there is nothing in the run log showing why :( WHAT I'M TRYING TO ACCOMPLISH: Should be fairly simple, right? Not for me. :) This Parent workflow…
-
Confused about API and access levels
Hello, I am trying to perform a workflow where I: Make a request to list all sheets For this step, I am using this endpoint: `https://api.smartsheet.com/2.0/sheets?includeAll=true` Choose a sheet Make a second request to get more information about that sheet using the sheet id from the first step For this step, I am using…
-
Automate Sending Welcome Email to New Smartsheet Users in our Company?
Does anyone know of a way to automate sending a welcome email to new Smartsheet users in our company. Our company has access to the app but their account isn't "created" until they login the first time (Okta/Active DIrectory Authentication) My idea would be to use the Bridge to: Make API call using GET /users Add Row to…
-
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…
-
Syntax: Add Row via API for Multi Select Contact Column, MULTI_CONTACT
Dropping this here in the hopes Google picks it up for future developers. At times when you cannot use the SDKs for adding rows via the API with multi-select contact columns (i.e. Bridge), the following body payload syntax is correct for posting new rows to a sheet. [ { "cells": [ { "columnId": 4532552246972292, "value":…