Stack Overflow
Stack Overflow

Questions tagged [smartsheet-api-2.0]

131 questions
0
votes
1 answer

Do I need to generate new token to see new smart sheet data

I am using smart sheet API to pull data from smart sheet. it is working fine. Recently new smart sheet was added. Access was given to user for this new smart sheet but when I call smart sheet API it returns "not found" response. All other existing…
Anil
  • 1,669
  • 5
  • 19
  • 44
0
votes
1 answer

Unable to access Smartsheet using Python SDK

I'm running the following code to access Smartsheet using Python SDK access_token = 'XXXX' smartsheet_client = smartsheet.Smartsheet(access_token) user_profile = smartsheet_client.Users.get_current_user() print(user_profile) But I'm…
RahulD
  • 1
  • 1
0
votes
1 answer

Is there any way to get smart sheet rows based on column value

I want to use smart sheet api to read sheet data. my sheet has changedtm column. I want to fetch rows which are greater than certain date. is there any way to do this using smart sheet API
Anil
  • 1,669
  • 5
  • 19
  • 44
0
votes
1 answer

Webhooks provided by smart sheet api, is there any oauth auth workflow instead of HMAC Authentication?

Webhooks provided by smart sheet api, is there any oauth auth workflow instead of HMAC Authentication/authorization done
LOKESH RAJU
  • 1
0
votes
1 answer

Smartsheet moving a row to another sheet - Python

I am trying to move a row from one sheet to another sheet, can someone help me with this? please see my code below: from smartsheet import sheets, models source_sheet_id = 123456789 #int destination_sheet_id = 987654321…
Esteban_ga
  • 1
0
votes
1 answer

Node.js Query Parameters for Smartsheet API

I am trying to send include parameters with a get-sheet request smartsheet.sheets.getSheet(options) using the Node.js sdk. The API documentation is vague on how to add the include parameters in the API call. I found a Smartsheet Developers Blog…
Lee Joramo
  • 105
  • 2
0
votes
1 answer

How to include OverrideValidation to add_rows request Smartsheet api

I am just doing a simple add_rows request and need to set the overrideValidation to True so that an insert doesn't fail because of a misspelling on a Picklist column. row.to_top = True row.cells.append({ #date of service …
Brad Cook
  • 3
  • 2
0
votes
1 answer

Smartsheet API - List sheets in a folder not implemented?

I am using the Smartsheet 2.0 API with the C# SDK. I am trying to iterate through all of the sheets in folder. However, I am unable to find the API code to do so. I tried FolderSheetResources interface, but a List() method isn't even implemented…
ionylion
  • 17
  • 6
0
votes
1 answer

How to use Smartsheet- API to export specific data on Excel file

I am trying to find out if it's possible to use Smartsheet API or any other method to export specific columns data from Report Builder results to Excel file rather than the whole column that was generated from it. I am new to Smartheet and if you…
Web1017
  • 19
  • 3
0
votes
1 answer

How to fix: linksOutToCells[] are not allowed for update_rows() operation

I'm using the Smartsheet Python SDK and attempting to update rows in a smartsheet in which many of the cells to be updated have existing links out to other sheets. I want to update the cell values with data from a pandas df, while keeping the links…
David Taylor
  • 3
  • 2
0
votes
2 answers

How do I install Smartsheet Java SDK properly and use it in html?

So I am trying to use SDK java for my web page development. I have html file that show my map. What I would like to do is to get my data from Smartsheet and convert these data to points on the map. I figure maybe java SDK is the file that I would be…
Maggster
  • 51
  • 6
0
votes
1 answer

Is there a way to edit crosssheet references using the api?

Developing a workflow in which everyday a new spreadsheet is uploaded to the workspace. A second tracking sheet uses a cross sheet reference to populate several columns. I am attempting to automate the upload process and if I am able to edit an…
Tom
  • 3
  • 1
0
votes
1 answer

Smartsheet python SDK Add row with cell link

I am trying to add a new row to an existing sheet with date columns. Some of the cells in the new row hyperlink to other sheets, this works fine. But there are other cells that I want to link_in_to from other sheets. I keep getting an "attributes…
lmarchisio
  • 1
  • 1
0
votes
1 answer

Does SmartSheet support any CURL to get the total row count in a sheet?

I am using curl with REST to access Smartshets in my C# running on WIN CE. My application is supposed to dump some data on smartsheet periodically. Before I write to a sheet, I would like to know the total row count in the sheet so that I don't…
Priyanka C.
  • 3
  • 1
0
votes
2 answers

Row # in Smartsheet API with Python

I'm looking for a way to include the row number in a formula when updating multiple cells in using the Smartsheet API (Python). The goal is to create a column then put a formula that dynamically references other columns in each new cell. I have…
lmarchisio
  • 1
  • 1
1 2 3
…
8 9