APPSHEET API WEBHOOK
Dear all,
I hope this message finds you well. Although I don't have any coding experience, I have been using AppSheet for some time now. Recently, I have been working on integrating Smartsheet into our project management processes, specifically for tracking our projects as a building company.
One of our requirements is to update the start date of dependent tasks when marking them as "started" in Smartsheet. This involves removing the predecessor task and changing the start date to the current day. Initially, I managed to achieve this using automation in AppSheet. However, there was a significant synchronization delay of 35 seconds for each row, which was not ideal.
In an attempt to find a better solution, I explored creating a webhook with the AppSheet API using the following HTTP request. However, despite the request being completed, I noticed that nothing changed in the Smartsheet sheet.
{
"Action": "edit",
"Properties": {
"Locale": "pt-BR",
},
"Rows": [
{
"UniqueID":"<<UniqueID>>",
"Antecessores":"",
"Data de Início":"<<Today()>>",
"Row ID":"<<[_THISROW].[Row ID]>>"
}
]
}
During my search for alternative solutions, I came across a helpful video on YouTube that suggested there might be an issue with identifying the Row ID. Unfortunately, I haven't been able to find a way to obtain the Row ID.
I kindly request your assistance in finding a solution to this problem.
Answers
-
@CASTRO I wonder if the video was mine? haha. Appsheet stores the row ID as a column, and it looks like you are accessing it?
Darren Mullen, smartsheetguru.com
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
-
@Darren Mullen, you are absolutely right. I came across your YouTube video and it sparked an idea about updating the rows using the AppSheet API. Unfortunately, I encountered some difficulties and couldn't make any changes. I considered creating an automation using Smartsheet's tools, but I faced challenges. It appears that the start date is not editable when the dependency sheet is enabled.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 301 Events
- 33 Webinars
- 7.3K Forum Archives