API & Developers

Connect with other developers using the Smartsheet API.

Discussion List

  • How do I pull data using Reports API from 10000ft into Power BI
    In API & Developers
    Hi, I am trying to import data from the 10000ft reports using the following API link, but I get the message 'Not Found'. https://api.10000ft.com/api/v1/reports/rows?view=time_fees_hours&time_frame=this_week&auth=<URL-ENCODED-T…
    Answered - Pending Review
    252 5
    Answered - Pending Review 252 views 5 comments Most recent by Genevieve P.
  • How to insert a value for Contact List Column from c# using api
    In API & Developers
    Hi all, I need to insert a value for a column, whose type is column list, from c# using api. I have even tried by defining the value and display value for this column from c#, but it does'nt get reflected on sheet. Thanks! Shoaib
    Answered - Pending Review
    71 3
    Answered - Pending Review 71 views 3 comments Most recent by Genevieve P.
  • How to set the value via Python APIs for simple CONTACT_LIST column ?
    In API & Developers
    Hi, i have the column where the type is CONTACT_LIST (single value only, not multiple values) ... here is the code snippet: case_owner_email = "[email protected]" new_row.cells.append({ 'column_id': project_metadata_column_m…
    Answered - Pending Review
    15 2
    Answered - Pending Review 15 views 2 comments Most recent by Parker Oxford
  • How to set the value via Python APIs for simple CONTACT_LIST column ?
    In API & Developers
    Hi, i have the column where the type is CONTACT_LIST (single value only, not multiple values) ... here is the code snippet: case_owner_email = "[email protected]" new_row.cells.append({ 'column_id': project_metadata_column_m…
    Answered - Pending Review
    24 2
    Answered - Pending Review 24 views 2 comments Most recent by lkrobot
  • copy_folder doesn't copy automation rules via rest api
    In API & Developers
    currently I run a copy_folder by API then found that the automation rules of the sheet under the folder is not copied. I tried to create that automation rule by rest api, after copying the folder, but found that create_automation_rule is n…
    Answered - Pending Review
    47 3
    Answered - Pending Review 47 views 3 comments Most recent by lkrobot
  • How to make BULK request for: "create_cross_sheet_reference"
    In API & Developers
    Hi, i need to create multiple cross sheet reference on the same sheet, and at the moment i'm doing one api call for each single reference ... is there a way to do this in a bulk request: only one api call for multiple references on the sam…
    Accepted
    23 1
    Accepted Answer 23 views 1 comment Most recent by Krissia B
  • smartsheet reference manager - Status "Processing"
    In API & Developers
    Good Afternoon, all of my references are still in a status of processing, and I set these up on Friday 10.29.21. Do we have a way to get these going? Every time I do these, they take forever
    Answered - Pending Review
    25 7
    Answered - Pending Review 25 views 7 comments Most recent by Genevieve P.
  • Is there any API to get the sheets with the exact name and location?
    In API & Developers
    I wanted to get the list of the sheets with the exact name I provide , also from the exact location either from workspace, folder or home. By exact name I mean returned sheets name should match complete string with given name and not just…
    Answered - Pending Review
    55 7
    Answered - Pending Review 55 views 7 comments Most recent by Genevieve P.
  • Percentage formatting with API
    In API & Developers
    Hello, I'm trying to automate the modification of multiple spreadsheets with the API, and I'm bringing a detailed formula to my columns. The displayed value is a percentage so I'm bringing a value between 0 and 1, but I would like to dire…
    Accepted
    13 2
    Accepted Answer 13 views 2 comments Most recent by Jeremy RENAUDIN
  • Using Smartsheet as a datasource in Sql Server Report Builder
    In API & Developers
    Hi there. To keep it simple, I'm looking to use Smartsheet as a datasource to build an SSRS report. Has anyone done this successfully? If so, are there any special needs such as a driver to pull it off? Any knowledge on this is appreciat…
    Answered - Pending Review
    42 3
    Answered - Pending Review 42 views 3 comments Most recent by Mark Verret