smartsheet API

Greetings

Can someone please explain to me how APIs work ?

I am not familiar with many of the technical jargons used on the SMARTSHEET API link.

I need to update data on my Gantt charts automaticallu instead of manually inputting the numbers and dates. Can APIs be of any help to carry them out ?

Can I somehow read and write into my Smartsheet, using APIs ?

Thank you

Find more posts tagged with

Sheets

API and Developers

Healthcare

IT & Operations

Project Management

Comments

Andrée Starå

Hi,

API's can probably do what you need.

https://smartsheet-platform.github.io/api-docs/

What do you want to do? Can you describe it in more detail?

I would recommend starting to look at a third-party tool like Zapier or similar and if it can do what you need.

Would that work?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

C. Srinidhi Ragunathan

Greetings

I am handling a number of projects and making Gantt charts to track their progress.

The data for these charts are stored in MS Excel sheets on my local drive. It becomes cumbersome to manually import the dates and numbers to update the Gantt chart. I want to know, if there is way I can circumvent this problem.

I was thinking if writing a code to read and write from my Excel files to update the Gantt charts would be possible so that, every time a change is made in the excel sheet, the Gantt chart gets updated.

Since Smartsheet is a cloud based platform, I would have to save my Excel sheets in Onedrive or Dropbox write? Or is it possible to link my Excel sheet when it is present in my Local C Drive ?

I am relatively new to coding so I am having difficulties understanding the terms in the link you have attached (atleast the introductory part).

Please let me know if APIs can be used. I was also looking into the new Data Uploader feature. Howver, since its a paid add on, I want to see if APIs can be used.

Thank you

Andrée Starå

Happy to help!

How did it go? Did you find a solution?

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

Using Control Center to Track Folder Updates?
Hello, I am unsure of the feasibility of this goal but am hoping someone could provide some insight. Within my organization we have the following structure Workspace → Workspace → Folder. Within this folder we have additional folders that are added through an API integration we have setup. I am hoping we would be able to…
Will and API token for a report give access to the Sheet the Report generated from?
Hi, I have a large Smartsheet, I want to generate a row report that reduces information displayed down to a specific group. For that Row Report, if I were to generate an API token and share it to a third party, will that third part have access to the information on the original 'Grid' sheet, or will it be reduced to what…
Were there recent changes to the totalPages parameter when querying the /sheets endpoint?
Up until last week, the totalPages and totalCount parameters functioned as expected when performing a simple GET call to /sheets. If there were 150 sheets, then it would show "totalPages": 2, "totalCount": 150. As of Friday of last week, it seems like it is showing "totalPages": 1, "totalCount": 100 any time there are more…