-
How to "GET" from an xml file?
My company is using a helpdesk/support ticket/eForm program to receive requests, and then manually entering those tasks into smartsheet. The program will allow me to POST the data via XML at the same time as form submission. I am trying to figure out how to automate this so that the data will then automatically be passed…
-
Delete and Lock row
Dear All I would like to know. Is it possible, if I want my team can edit the row but they can't delete it?
-
Azure Functions App
I'm having issues deploying a python script to Azure Function App. I've developed it to handle some simple repetitive tasks using the API but am running into issues. I have a ticket in to support but was wondering if anyone else had experience using an HTTP triggered by Smartsheet webhook deployed to Azure.
-
Making OAuth work with NodeJS
Hi all, I am looking for some support on making OAuth work for the web application I am developing. I am trying to use node JS, and I am loving all the documentation and support available for Smartsheet API stuff online. That being said, it seems to all be depreciated!! CRUX: Most support is from 2018, and when I try to…
-
Trying to delete a large number of rows trough API
Hi I am using the Node JS SDK to delete the content from a sheet. It works fine but for a lot of rows it fails (I have tested with a minimun of 1000). I get an error that says that the request is to large for the server. I understand whats happening, but I was wondering if there is another way to clear a sheet using the…
-
Facility Bookings
Hi all. We manage many government/public venues and facilities (sports arena, stadium, parks etc) for which we facilitate bookings. At present, bookings are logged using outlook only viewed by one person. We'd like to begin using smartsheets for bookings so clients (the public) can view available (or unavailable) dates,…
-
Automation - 'change a cell' not operating until I close & reopen the grid.
I am using a series of automation workflows to change the contents of a cell based on the contents of another. Whilst trialling these workflows, I have to save, close and reopen the sheet for the intended cell to actually update. I would prefer this to be instantaneous. Is there a known solution to this? Thank you.
-
Event Reporting 403
Hello everyone, Hope you are well. I am trying to access Event Reporting through a API call following the respective documentation https://smartsheet-platform.github.io/api-docs/#get-events. My account belong to an Enterprise plan and I am System Admin. Also I generate the API access token multiple times but I am still…
-
Smartsheet API Assistance Required
I am looking for assistance to provide a url to find the correct row of a given sheet per the provided identifier (country code; e.g. US, GB, AL, etc) and return all the values of the row. I'll need the correct smartsheet api url of our smartsheet account (please don’t refer me to the smartsheet api docs), no application…
-
Querying API for 10000ft Time Entries
Hi, I am wondering if it is possible to query the 10,000ft API to retrieve time entries using parameters to limit the results to only include approved time entries after a certain date. To this point I have not had success passing in parameters for the status of the approval or the approved_at timestamp. I have reviewed…