Questions tagged [smartsheet-api-2.0]
131 questions
0
votes
0 answers
Python 3.6.4 script works in debug mode but returns error when run on terminal
I am using python 3.6 with Visual Studio Code on window 10.
I was working on extracting data from SmartSheet using API.
Here is my code.
import smartsheet
import importlib
import supporting_tools as spt
Token = 'api_token'
sheet_id_2nd =…
Jay Hoon Choi
- 31
- 6
0
votes
1 answer
How to extract an element of the array (Share object)
I'm trying to print just 1 element of the response (see below) when performing say a List Workspace Shares - eg. I would like to print just the email.
I have tried response.data[email], response.email to no avail.
Can anyone point me in the right…
Sean Williams
- 11
- 1
0
votes
2 answers
smartsheet API Update PICKLIST column error
I am getting an error using the Smartsheet API to update a row in a smartsheet document. Previously this has been working, so I think something may have changed recently in the smartsheet api that is causing this error, but I couldn't find any…
J.Cushing
- 1
- 2
0
votes
1 answer
Wordpress Connect to SmartSheet via REST/JSON/Auth
I am trying to make a WordPress site that will use data from SmartSheet. I need to Authenticate(Authorization) to get into SmartSheet. SS uses an API Access token to get access. All of this works fine in postman. My question is: Are there plugins…
Kyle Hand
- 11
- 4
0
votes
1 answer
Is there a way to find / update a row based on column values instead of the Row ID?
I have a C# app that sends data to Smartsheet. At the moment, it's just inserting rows, based on the following:
Row rowA = new Row.AddRowBuilder(null, true, null, null,…
pmfith
- 831
- 6
- 24
0
votes
1 answer
Smartsheet rows isnt updating
import smartsheet import pandas as pd
smartsheet_client = smartsheet.Smartsheet(token)
response = smartsheet_client.Sheets.list_sheets(include_all=True)
sheet1 = response.data
sheet =…
Beshara N. Oweis
- 1
- 1
0
votes
1 answer
Smartsheet API - copy and paste rows within the same sheet
Is it possible to copy and paste rows within in a single sheet with smartsheet api?
I am using python.
When I try the following (using the same sheet id)
response = smartsheet_client.Sheets.copy_rows(
,
…
Swag_B
- 1
- 1
0
votes
0 answers
Update all rows with dependency defined (Duration and Predecessors)
In Smartsheets I have these columns Duration, Predecessors, Start and End Date, When I change my base Start date all my rows for EndDate and StartDate are then populated. I am trying to achieve the same functionality by api but when I update that…
joyBlanks
- 6,419
- 1
- 22
- 47
0
votes
1 answer
How to get the number of entires in SmartSheet using JAVA
I'm working with smartsheet and the problem I'm facing that I want to know whether it's crossed the maximum limit, i.e, 5000 or not before getting 400 BAD request so I can change the sheet.
can any one help me out with this thanks in advance.…
0
votes
1 answer
Search method in Smartsheet API 2.0 C Sharp
Within the API for smartsheet I use the search everything method.
Already solved in cUrl (check Special characters in Smartsheet API (2.0) - search), but within C-sharp how can I solve this:
When trying to search for 'A01 PXXX' it returns me also…
Maaik
- 13
- 4
0
votes
1 answer
Verify Smartsheet Webhook API
I'm trying to verify Smartsheet's Webhook API whenever smartsheet makes a POST request to my callback URL. Has anyone worked with this before?
I need to verify the POST request is coming from Smartsheet, whenever a call is made to my Callback…
samceena
- 266
- 3
- 15
0
votes
2 answers
Smartsheet - How to attach a file to a row using Smartsheet API and PHP curl
The smartsheet api docs provide this documentation to attach a file to a row.
curl https://api.smartsheet.com/2.0/sheets/{sheetId}/rows/{rowId}/attachments
\
-H "Authorization: Bearer ll352u9jujauoqz4gstvsae05" \
-H "Content-Type:…
Roger_Jarrett
- 31
- 3
0
votes
3 answers
Filter options in smartsheet API or SDK
I am currently exploring the smartsheet API 2.0. I want to filter based on Modified and Created date but I am unable to find any such option in the documentation.
Is there a way out to filter the smartsheet using any custom filter as we have in…
Ishan
- 4,008
- 32
- 90
- 153
0
votes
1 answer
How can I detect "Sheet - Create" using Smartsheet API
Background
We will be creating / managing projects in Smartsheet
Each new project is a new sheet, based on a template
I am designing integration to other systems that need to be notified
whenever a new project or task within a project is created.
I…
Mike-o
- 1
0
votes
1 answer
How to use smartsheet API to get cell history in a report
I am trying to connect to the smartsheet api using C#, Visual Studio 2017. I am trying to get the history of a cell in a report so I can graph the changes of the percentage value that is in the cell over time.
I am using
Gillan
- 149
- 1
- 4
- 11