Send Update Request via API to Contact List User

Tim Meeks

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

dAVE Inden

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.