Stack Overflow
Stack Overflow

Questions tagged [smartsheet-api-2.0]

131 questions
0
votes
1 answer

How to iterate through the row property of the sheet object and create a comma delimited list of row id's?

I am currently trying to import an excel sheet into Smartsheet, then take the rows of the imported sheet, and move them to the bottom of an existing sheet. To do this I am using the Sheets.move_row function. Below is a snippet of that code. response…
Isaaclele
  • 29
  • 6
0
votes
1 answer

How to gather row id's of sheet that is being imported?

I am currently trying to move rows from a sheet I import, into another existing sheet. As of right now I am using result.data.id to return the sheet id that will be associated with the imported sheet. For further clarification here is the line of…
Isaaclele
  • 29
  • 6
0
votes
1 answer

Is there any easy method to getting the Column Title when using GET Row with the Smartsheet API?

Is there any easy method to getting the Column Title when using GET Row with the API? New to API. I'm utilizing Microsoft Power Automate for these calls to push updates to Teams and such (more custom than what comes natively from Smartsheet). I'm…
brettofthewild
  • 3
  • 1
0
votes
1 answer

Dynamic listing of drop-down list in Smartsheet using python API

I want to populate the drop-down list in a smartsheet from data in a column of another smartsheet. Is it possible? Do I need cross sheet referencing for it ? How do I access the drop-down list?
Felicity2401
  • 1
  • 2
0
votes
0 answers

smartsheet-Accesstoken regeneration for oauth

I have created an app in developer tools and performing step1 to get the authorization code on callback…
Tulasi
  • 1
  • 3
0
votes
1 answer

Smartsheet API: Update formula value in sheet

I'm trying to update a a cell with an existing formula in a Smartsheet sheet. I've read in a similar topic that this is now possible but can't work out how to get that done through my json parse. Currently this following string type is converted to…
TobeT
  • 3
  • 1
0
votes
1 answer

Smartsheet SDK compatible on Amazon AWS Lambda?

Does anyone know if Smartsheet SDK is compatible with Amazon's AWS Lambda? I have a ticket in for Smartsheet but haven't heard from them yet so I thought I would give it a try here. I'm getting a time-out when running this command on AWS "sheet =…
Michael Tuccillo
  • 11
  • 2
0
votes
1 answer

Smartsheet API ---- how to upload an Image to a cell on a sheet, then send it to back-end (to AWS S3, get URL, for MongoDB)

Problem: Smartsheet allows users to add images to a cell, by right-clicking on a cell then selecting 'Upload Image' We are trying to see how that image could then be sent to our back-end, so that the image is stored in AWS S3, where we get the…
Jose Fuentes
  • 3
  • 2
0
votes
1 answer

How to update value of a cell that have a Hyperlink by Smartsheeet API C# SDK?

We have to update value of a smartsheet Cell. This Cell contains Hyperlink to a different sheet. Hyperlink URL is assigned. We want to update this cell value by Smartsheet API C# SDK.
Buddhadev Karmakar
  • 11
  • 1
0
votes
1 answer

Smartsheet avoiding infinite loop in node

Does anyone know how to add a change agent header for node.js to the smartsheet api call? In the api documentation https://smartsheet-platform.github.io/api-docs/?javascript#preventing-infinite-loops there is no implementation, only an example in…
sckewbie
  • 11
  • 1
  • 3
0
votes
1 answer

SmartSheet - I am trying to get access token using Oauth

I am trying to integrate Power Automate (Workflow service) with SmartSheet using OAuth 2.0 I have got the auth code successfully and when I finally try to get the token, it throws the message - 'You are not authorized to perform this action.' with…
CHANDRU D
  • 25
  • 5
0
votes
1 answer

Is there any way to get deleted row data from smartsheet using webhooks

To notify the events on smartsheet, I have created a webhook. Using I am able to get all events performing on sheet. If I delete a record manually, I am getting the deleted event with rowid, but not the total deleted row data. Is there any way to…
Sivakishore Teru
  • 216
  • 1
  • 2
  • 9
0
votes
2 answers

Smartsheet-api, Is there any way to get manually deleted row using smartsheet api or sdk call

I am deleting row from a sheet, On a sheet I have daily job which needs to recognize the deleted records, I need a way to recognize them using smartsheet api or sdk.. Thanks in advance..
Sivakishore Teru
  • 216
  • 1
  • 2
  • 9
0
votes
1 answer

Java Smartheets - Column ID is not created when creating new Sheet

The following code Sheet aSheet = new Sheet(); List columns = new ArrayList<>(); Column claim_number = new Column().setTitle("EMS Claim…
conteh
  • 1,544
  • 1
  • 17
  • 39
0
votes
1 answer

How to get the list of all users including their last login

I have a dashboard to do for my organization about the use of smartsheet licenses by employees. Normally, the request to obtain such information is as follows (according to the…
glitchcl
  • 318
  • 2
  • 9
1 2 3
…
8 9