I am attempting to connect SMARTSHEET to my project app with an API. I am very lost and would appreciate any guidance. Is Data Uploader needed?
@Johnathan Vargas Cruz, yes that is correct. The API pulls from my company's application.
Thanks for the information. I will give it a try.
Are you trying to create a service to do batch updates for a smartsheet or are you trying to use some file to update a smartsheet? Both are possible, but they are very different approaches.
Hello @Johnathan Vargas Cruz
Thank you for replying. I utilize an app for project creation and completion at my company. I am trying to connect a SMARTSHEET to it for scheduling purposes. I was given an API to use to pull the project information. I hope I am answering your question.
The API pulls information from your company's application, correct?
If you want to go the Data Uploader route, get the API to produce a file (like a CSV or XLSX), then upload the file through Data Uploader. You'd have to manually update the smartsheet every time you've a change, but it's pretty simple to do.
If you want to go the batch update route, add a service (either in the existing application your company uses or a new one) that makes HTTP requests to smartsheet containing the data from your API. There is plenty of documentation of how the requests should look like available here: https://smartsheet.redoc.ly/
I've been trying to do a simple check of whether or not the entry from the form has a returned value that is either yes or no and it checks 3 cell locations to see if any returned yes. The 3 columns are Dropdown lists for Yes/No and the Status is a Text/Number, is that the issues? If not how do i fix that?
I'm wondering if there is a way to lock rows 1-12 out of the sorting and filtering of a sheet. I might have take out that part of the from otherwise I dont like how the built in dashboard moves when a sort or filter is applied?
Hello, I apologize if this has already been answered, I did search before asking. I recently downloaded a template and it had the google slides displayed in presentation mode. I cannot figure out how to do this as when I embed, it's just the entire google page where you can edit and see the menu bar. How do I embed the…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.