-
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…
-
Postgres SQL and updating records in Smartsheet
I am trying to keep an up to date list of different job information in Smartsheet. I would like to use this up to date information to reference data across different sheets but am struggling on how to exactly do this. I have a Postgres SQL API with the information I need, but can't seem to find a way to keep these records…
-
Workspace Shares - API (cURL) Error 1004 - Not Authorized to Perform This Action - 403 Forbidden
Hi all, I'm getting following error when trying to GET a list of workspace shares (GET /workspaces/{workspaceId}/shares) "errorCode": 1004, "message": "You are not authorized to perform this action." The same happens when trying to GET a specific workspace share (GET /workspaces/{workspaceId}/shares/{shareId}) Following…
-
Apostrophe added on mass insert thru CDATA
Hello, We are currently using a third party tool CDATA to upload excel data to a smartsheet. When any numeric data is entered, an apostrophe is always added to the beginning of the string. Upon checking the logs, CDATA is not sending an apostrophe to Smartsheet. The only thing I can think of is Smartsheet is adding the…
