-
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…
-
"Make owner" using API
Hi, everyone. I want to change ownership of 100+ sheets that I own using the Smartsheet API. I have been looking through the documentation and could not find how to do it. According to this post on stackoverflow it is not possible. Performing this actions within Smartsheet interface is really tedious because you need to go…
-
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…
-
Add new_row including values for a multi-select dropdown via Python SDK
I've tried different thing but I still get the same error. When I try the following code: multival = smart.models.MultiPicklistObjectValue() multival.values = value new_cell.strict = True new_cell.object_value = multival new_row.cells.append(new_cell) The column submission looks like: "{"columnId": 7199257397618564,…
-
Help! Webhook Creation Error
Hello! I'm able to use my api key to retrieve my sheet, and then the /webhook GET request successfully responds with an empty set, but I'm unable to add the hook for some reason. Any help would be appreciated! I've tried adding the non-required fields shown in the docs (createdAt, modifiedAt, subscope) and I've tried…
-
Automate io & Deleting Data from Smartsheet
I just recently started using automate io and just recently ran into some major issues. Automate io allows you to create a bot with the trigger of 'New Row' so anytime a new row is created on a sheet, it will trigger the bot. Soon after setting it up, my bot stopped triggering, every time I created a new row (using a…