-
Add Rows API - Not showing any data
I have a sheet where i have 2 columns. I have Customer and Item. In Customer Column I have a list of customers already * Customer * * ITEM * row 1 Office row 2 Shop row 3 Logistics row 4 Constructions row 5 Mapping row 6 Cartoon row 7 Office 2 row 8 Shop row 9 Logistics row 10 Constructions row 11 Mapping row 12 Cartoon…
-
Expose Dashboard Widget APIs
It would be valuable to be able to create and modify dashboard widgets via the API. Currently the only way to bulk update content is via control center, and that still creates copies of the dashboard from the template set. With API access users could point to specific formatting options, as well as leverage information…
-
c# ProxyHttpClient example no longer working
Hi All, I am having an issue with setting the Proxy, it seems RestClient has changed how you set the proxy and this.httpClient.Proxy = proxy; as suggested in the SDK is no longer valid. Is there an updated way to set the WebProxy? I have confirmed via CURL that my token is good and the endpoint is reachable once the proxy…
-
Adding a row via API using cURL adds blank row
Hi all: I'm attempting to add a child row to a sheet using the API and cURL. It took some time but finally, taking information from chatgpt and other sources, I was able to get a row added as a child in the proper place. However, the row is blank and not taking the values I am setting. curl -X POST…
-
Posting to smartsheet using Postman
I'm trying to use postman to pull in some manpower logs from Procore and post these as a new row to a smartsheet. the results are pulling in correctly from Procore, and i have correct sheet and column IDs etc but nothing is posting onto the sheet - it just adds a blank row…. - the raw response i get is as below {…
-
Automation Help: Regarding Proofs
I want to record a date, when certain people approve a proof. When I set up a proof I am inviting several people, however, I need to record a date when a specific person (technically it could be 1 of 3 people) actually approves the proof. I have the {Proof Approved By} column (and as everyone approves their names appear in…
-
How to Quickly Count Applications in Use on Smartsheet?
Hello! Could someone help me with a question? Does anyone know how I can quickly get a count of the number of applications in use on Smartsheet? Or do I need to access each sheet one by one and check the logs?
-
Using get_sheet using report_id vs sheet_id?
Hello! I am running into issues using report_ids when calling the get_sheet api function. Is there a different call I should be using here? Is there a different api command for reports vs standard sheets? It is running into typical 1006 error.
-
Issue: Smartsheet API Not Returning Data for Formula Columns in Sheets
I am experiencing an issue with the Smartsheet API where data from columns containing formulas are not being returned when querying a sheet. However, the same data is correctly displayed in the UI and can be accessed through reports via THE API. So I can access sheet data for formula columns via a report that points to…
-
API/Python SSL errors
Hello, my department has many python scripts that use the smartsheet API to download/upload from the site all of my smartsheet python (which was working perfectly before today) started giving the following errorurllib3.exceptions.MaxRetryError: HTTPSConnectionPool(host='api.smartsheet.com', port=443): Max retries exceeded…
