Questions tagged [smartsheet-api-2.0]
131 questions
1
vote
2 answers
How to generate redirect URI for Smartsheet to pass data to Apps Script
Screenshot of smartsheet and google setup screens
When attempting to get data out of Smartsheet, I'm encountering an error that says the redirect URI is missing or invalid when I follow the link that was logged by my apps script project.
I've…
jdavis
- 429
- 6
- 16
1
vote
1 answer
Initializing long[] for DeleteRows() method in Smartsheet API
I'm trying to delete a set of records using the following C# SDK Smartsheet API 2.0 method:
long[] deleteRowIds = existingRowIds.Except(updatedRowIds).ToArray();
smartsheet.SheetResources.RowResources.DeleteRows(sheetId, deleteRowIds, true)
Within…
Channing
- 129
- 2
- 12
1
vote
1 answer
VBA to parse data from web API
Public Sub IMPORTMESTER()
Dim xTOK As String
Dim URL As String
Dim httpREQ As Object
Dim JSON As Object
Dim xLINE As Variant
xTOK = "bdj62bzknriy3dd9g561on2xl2"
URL = "https://api.smartsheet.com/2.0/sheets/7352150637471620"
Set httpREQ =…
Mr K
- 111
- 13
1
vote
1 answer
Created System Column Blank In API Call
I am making REST calls against the Reports API endpoint, and pulling that data into a separate application. I am able to pull all of the report columns with its data, with the exception of the Created (System Column), which always returns…
John R
- 11
- 1
1
vote
1 answer
How do I get the ID of a new folder/sheet that I have created from a copy?
When I make a copy of a folder in smartsheet, is there a way to get the ID of the new folder?
What I have tried so far is this:
inc_list = ['all'] # you can add other parameters here, separated by a comma
response = ss_client.Folders.copy_folder(
…
adamcoolcat
- 105
- 7
1
vote
1 answer
Copy A Sheet in Smartsheet using Python API
I was attempting to copy a sheet with the python API, but every time I do so, it only includes the formatting (column names and number of rows), but I would like it to include the data. Is there any way I can do this? I have tried it with a template…
adamcoolcat
- 105
- 7
1
vote
1 answer
Curl command works but not pycurl command for smartsheet
I am able to successfully update the smartsheet using Curl Commands:
curl https://api.smartsheet.com/2.0/sheets/sheetID/rows \
> -H "Authorization: Bearer token" \
> -H "Content-Type: application/json" \
> -X PUT \
> -d '[{"id": rid, "locked" :…
polyglot
- 57
- 11
0
votes
1 answer
Cell values not copying over to new sheet using Smartsheet API
I am trying to create a new sheet from a template using the SmartSheets API. Here is the code I am using to do so.
response = smart.Home.create_sheet_from_template(
smartsheet.models.Sheet({
'name': 'newsheet',
'from_id': temp_id #…
Colin
- 3
- 2
0
votes
1 answer
Smartsheet API Python update columns 4004 error
I've recently been developing some automation for a client using Python. The client has new events they put on and wants those new events dynamically added to a drop down column in a sheet for tracking events. I've developed a script to do just…
Conor Hanson
- 1
- 3
0
votes
1 answer
Assume-user not working in smartsheet api
Hi I am testing SmartSheet Api for my new application. I was trying to use assume user function. I have a System Admin account say admin@xxxx.com and a non-admin account user@xxxx.com. I am getting errorCode 1030
Note : I currently have the trial…
Aryan Singh
- 3
- 2
0
votes
0 answers
Apps connect to Smartsheet using OAuth 2.0
Node.js
How to use access_token?
I'm making a request:
axios.post('https://api.smartsheet.com/2.0/token')...
response:
{
access_token: 'lkqgob9uf56d3vn0a358g4u199',
token_type: 'bearer',
refresh_token: 'd633gl7mlsw9cc7dnwlgmbwepe',
expires_in:…
0
votes
1 answer
Using Smartsheet API, how do I fetch the metadata such as _OUTLINELEVEL_ or _ROWNUM_?
I am able to get the Row and Column data from the Smartsheet API JSON response but in it there are no metadata such as _OUTLINELEVEL_ or _ROWNUM_.
When requesting the data from Smartsheet API, I also sent additional params such as:
params =…
floss
- 2,603
- 2
- 20
- 37
0
votes
0 answers
Smartsheets API 2.0 1052 Error "Invalid Accept header. Media type not supported."
When it submit a curl request on any of the below i get a 1052 error
Sample 1: Get sheet
curl https://api.smartsheet.com/2.0/sheets/%7BsheetId%7D?level=2&include=objectValue
-H "Authorization: Bearer {token}"
Sample 2: Get sheet as Excel
curl…
A-A-ron
- 15
- 6
0
votes
1 answer
Problem inserting value in cell available from picklist in Smartsheet using API
I have trouble inserting values to a "picklist" column using smartsheet API and python.
The value I am trying to insert is one of the options from the picklist as can be seen in the picture attached. I have no idea how to insert values to cells in…
Frederik Toft
- 11
- 1
0
votes
2 answers
Do I need to be an admin to generate an API access token on free Smartsheet gov?
Do I need to be an admin to generate an API access token on free Smartsheet Gov?
I am currently an editor on smartsheet gov and have sharing permissions, but I cannot generate an access token. Do I need to be made an admin to be able to do this? Or…
dgoose
- 3
- 1