Stack Overflow
Stack Overflow

Questions tagged [smartsheet-api-2.0]

131 questions
26
votes
4 answers

convert Linux date to yyyy-MM-dd'T'HH:mm:ss'Z' format

I need to parameter-ize a datetime value with an objective of passing to a constructed URI to make a Smartsheet API call to get data (i.e. sheets) changed in last 24 hours. I want to use Linux date command as I can do something like date -d '1 day…
Vlad
  • 267
  • 1
  • 3
  • 3
4
votes
2 answers

How to get the array of sheet ids in a folder with python

When I try to get the id array from the get.folder() call (by using folder = folder.sheets.id), I get the answer: "AttributeError: 'TypedList' object has no attribute 'id'" I'm not sure what function to call in python to get the array of sheet ids…
adamcoolcat
  • 105
  • 7
3
votes
2 answers

How can I run a python script without using a python editor that includes the smartsheet sdk

One solution I have been trying to convert python scripts into .exe files using things like py2exe and cx_Freeze, but I keep getting errors after running the cmd. Is there any other solutions you guys can think of, or should I just keep trying what…
adamcoolcat
  • 105
  • 7
2
votes
4 answers

Python - How to create a pandas Dataframe directly from Smartsheets?

I don't understand how to import a Smartsheet and convert it to a pandas dataframe. I want to manipulate the data from smartsheets, currently I go to smartsheets export to csv and import csv in python but want to eliminate this step so that it can…
Nottingham_Python
  • 21
  • 1
  • 3
2
votes
1 answer

What would be a logical way to put this Smartsheet data in a DataFrame?

My goal is to use the Smartsheet API to take data that is structured just like the data shown below and place it in a pandas.DataFrame object. The issue is that the data has several layers, creating an inconsistent hierarchy. Task …
benfwalla
  • 23
  • 4
2
votes
1 answer

Python for Smartsheet - Getting _ipython_canary_method_should_not_exist_

All - I am getting this error when loading the Smartsheet Client I loaded all dependencies as per requirements. What should I fix? ImportError! Could not load api or model class _ipython_canary_method_should_not_exist_ ImportError! Could not load…
Leo S.
  • 33
  • 1
  • 6
2
votes
1 answer

Issue finding "Column IDs" inside report

I want to be able to send a row, from a report, via email with only specific columns via the API. The API docs clearly show you how to send a row via email however, I'm unable to get the column ids inside the report in order to send those specific…
William.Avery
  • 60
  • 1
  • 7
2
votes
2 answers

How to update Predecessor or PredecessorList Object in Smartsheet Python SDK

I have a loop that creates a parent row and a variable number of child rows. I would like to update the Predecessor field of the child row with the prior child row number (when more than one child row is added). I am having difficulty adding the 2…
Michael Williams
  • 177
  • 1
  • 6
1
vote
1 answer

Use Smartsheet API to create an image/screenshot of a Smartsheet dashboard

My team manages the digital signage program for my company. This consists of large flatscreen displays in building lobbies/offices for news and other info. I'm able to retrieve a basic Smartsheet doc using the API. I can use the signage software to…
mindmischief
  • 271
  • 1
  • 12
1
vote
1 answer

How to use Alteryx SQL Editor statement into Smartsheet API call?

Currently, I am using Alteryx Designer to connect with Smartsheet API and on Alteryx there is the "Choose Table or Specify Query" box which has "SQL Editor" where we have the following code: SELECT * FROM "Proj PAGE 1__1234567891234567s_" as AM…
floss
  • 2,603
  • 2
  • 20
  • 37
1
vote
1 answer

how to use os.listdir() in smartsheet?

I would like to get all the folder that are in a specific folder in smartsheet I wanted to use os.listdir but I am not sure on how to use it on smartsheet any idea ? any idea on how to implement that without os.listdir ?
Ben2pop
  • 746
  • 1
  • 10
  • 26
1
vote
0 answers

'Method not found: 'Void RestSharp.RestClient.set_FollowRedirects(Boolean)'

Using Smartsheet-csharp sdk , It was working fine with RestSharp 106.15.0. When updated RestSharp to latest version 108.01 its giving error on following line of code SmartsheetClient smartsheet = new…
Ayesha Arooj
  • 11
  • 1
1
vote
1 answer

Why can import smartsheet not be resolved?

I have installed the smartsheet python sdk with pip3 install smartsheet-python-sdk (using Python 3.10.5). I believe it was successful because if I do it again, or even try to upgrade, I see "Requirement already satisfied" for all the requirements.…
clickityclackity
  • 11
  • 2
1
vote
1 answer

Remove formula from column with python

I am trying to remove the formula from a column in a existing sheet with python. I tryed to set my formula to None using the column object (column.formula = None) It does not work and my column object remains unchanged. Anyone have inputs to solve…
JayP
  • 13
  • 2
1
vote
1 answer

How to code Python without using Smartsheet python SDK

Using Smartsheet Python SDK, I'm running the following code to access Smartsheet to: Get customer list from "Customer name" column Update Picklist of "Customer name" column with the customer list get from 1. import smartsheet # Initialize…
Thinh Huynh
  • 11
  • 1
1
2 3
…
8 9