Questions tagged [smartsheet-api-2.0]
131 questions
0
votes
1 answer
Smartsheet comments are not retrieved C#
I am trying to retrieve data from my smartsheet using SmartsheetClient. But when I try to access comments against a row, the comments are null. Following is my code:
string accessToken = "accesstokenvalue";
long sheetId = 121212221;
SmartsheetClient…
ArslanIqbal
- 569
- 1
- 6
- 19
0
votes
1 answer
Get column description via smartsheet api
In Smartsheet interface you can add a description for each column (then the description is visible via a little popover), is there a way to retrieve it via the API ?
I cant find it in the doc.
Thanks
Valentin Coudert
- 1,759
- 3
- 19
- 44
0
votes
1 answer
Smartsheet C Sharp SDK DLL error in release mode
I have completed my code and i am looking to compile and release the software. I have worked my way through all of the bugs/error messages when i changed from debug to release except for 1 that has got my head hurting!
Looking for some help to…
Andrew Little
- 27
- 1
- 7
0
votes
1 answer
Is there a way to get all sheets inside a folder, including all subfolders? (In Smartsheet)
I have created a script to automatically update all sheets in a folder, but if there are subfolders, I don't know of a way to dynamically access the other sheets inside those subfolders. Does anyone know if this is possible using the smartsheet…
adamcoolcat
- 105
- 7
0
votes
1 answer
Get Children of Parent Row
Is there any way to get all of the children of a parent row? The only method that I see, is to grab all of the rows and look at the parentId's assigned to the children.
(For what it is worth, I am using the javascript api)
Lee Joramo
- 105
- 2
0
votes
1 answer
Comparing two list of rows based on Data in a selected cell using Smartsheet API
I want to compare two list of row data. Right now I want to see if the two list contain the same title in their respective cell values.
What methods with using Smartsheet API C# could I use to sort through the list and compare each select element…
M. Allen
- 3
- 4
0
votes
0 answers
Crystal Reports Smartsheet not displaying fields
I am using SmartSheet and linking the tables to Crystal Reports in VS2015. When I do this I can see the fields in a Sheet to drag and drop onto the report but they do not show up in the list to link the report together.
How can this be so?
Andrew Little
- 27
- 1
- 7
0
votes
1 answer
Loop through sheets and append columns
I have over 100 sheets in a smartsheet workspace. I'd like to use the python api to loop through each sheet and append the row id, sheet id, and the primary column into an array or pandas data frame.
import requests
import pandas as pd
import…
AME
- 5,234
- 23
- 71
- 81
0
votes
1 answer
How to get the particular row by column in smartsheet api
I am using smartsheet as a database and I want to query the smartsheet by column name equals value like in sql db for example: To get the particular row of Employee sheet where salary equal to 10000. But documentation describes only how to get list…
Anas Ahamed
- 186
- 10
0
votes
1 answer
Smart sheet API - replace sheet?
I am using the Smart Sheet Python API.
How can I update data completely using the same sheet ID?
My approach was to loop through the columns and delete them (or delete the rowIDs) to clear out the existing sheet. How can I now load new data to the…
trench
- 5,075
- 12
- 50
- 80
0
votes
1 answer
Is it possible to list all Items (for simplicity, just sheets) in a folder and collect the ids in an array?
Is it possible to collect all the sheet ids of sheets stored in a folder? I am trying to make a program that is able to update the names of sheets based off of a word in a sheet cell, I have the code already made for that here:
#this section gets…
adamcoolcat
- 105
- 7
0
votes
1 answer
Is it possible to use Get Sheet and filter by only created date?
I currently am using the get sheet method and then parsing through the sheet to get the rows created on today's date. Is it possible to filter to only get the rows using the filter parameter?
If there is a curl (postman) example you can point to…
0
votes
1 answer
how can i get all the rows id's in sheet or report including all pages?
report = ss.Reports.get_report(report_id,page_size=5000,)
row_dict={}
count = 0
for row in report.rows:
row_dict[count] = (row.sheet_id, row.id)
count +=1
i have 2 pages in one report but I am getting only pages 1 details, how can i get…
0
votes
2 answers
Need a C# WebApi example of a Smartsheet callback controller method
I am working on a prototype for using Smartsheets webhooks to notify an ASP.Net/WebApi endpoint when changes occur. While I understand the concepts, I have not been able to find a specific example of the structure that Smartsheets will be passing to…
HiTechRedNeck
- 59
- 5
0
votes
0 answers
smartsheet odbc driver Cyrillic symbols
I'm trying to use the ability to access Smartsheet data via the ODBC driver. http://smartsheet-platform.github.io/odbc-docs/ in php.
All is well, only the symbols on the Cyrillic are displayed by the question marks (????)
$conn =…
