Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Send Update Request via API to Contact List User
Has anybody deveoped a solution using the API's to send Update Request from a sheet?
Meeting with my developer to see if we can send an update request when the PAYMENT field changes to PAID status and the DATE PAYMENT RECEIVED is blank. Then send an Update Request to the User in the Agency Contact field which will be setup as a Contact List.
Another idea would be to get the email from a separate table that has the associated email address.
Anybody have any lessons learned from similar solutions?
thanks,
Tim
Comments
-
Hi Tim,
This sounds like it could be accomplished via the Smartsheet API. You could montior a sheet for changes and after finding the value you are looking for in the sheet send the Update Request to the appropriate email.
To monitor the sheet for data changes the best practice would be to implement one of our Webhooks. Once alerted of a change you could run a GET Sheet request. Looking through the response you could find the value you are looking for and the email address to send them along to a request to send an Update Request.
If you have questions while building this process feel free to reach out to us at api@smartsheet.com.
