-
Building A Test Package In SQL Dev That Writes To A Smartsheet
Hello, I am attempting to build a package in SQL Dev that takes data from a table in SQL Server and inserts it into a Smartsheet. For example, I have three lines of data in a table in SQL Server that I need to have added to a Smartsheet table. How do I go about creating a package that does this? I have never built a…
-
How do you access user data once authentication is made in OAuth flow?
context: I integrated a Node.js Smartsheet Oauth flow into my Django app by having the login button in django direct the user to the /auth url on the Node server. Once the flow is done and user logs in through Smartsheet, the redirect URL from the Smartsheet dev tools takes the user back to the Django website. Objective: I…
-
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?
-
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…
-
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…
-
Workspace Branding Appears Small & Blurry
I have more than one workspace in Smartsheet, one that I created and one that I am an admin for but not an owner. The workspace that I am an admin for has a large, clear brand at the top of the sheets and forms, but when I try to change the logo on the second workspace that I own, it comes out small with blurred edges. I…
-
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…
-
Smartsheet data connection in TIBCO Spotfire server
I am able to create an ODBC connection and get smartsheet data in my Spotfire Analyst client. I followed this link - https://smartsheet-platform.github.io/odbc-docs/#tibco-spotfire-desktop. However, I would like to create an information link and publish data in Spotfire library and share the web link with the users. The…
