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, pleaseVisit the Current Forums.
Basics of Webhooks from other applications via SurveyGizmo
Hi, I am new to attempting to work with these Webhooks and could use some help.
I use SurveyGizmo as a surveying tool to gather information from a large amount of users. I am trying to build it to where everytime a response is made in SurveyGizmo, it will transmit that data to Smartsheet to store on a sheet.
SurveyGizmo has the ability to create a Webhook (http post) that sends data to a URL. I am able to test and send data to RequestBin. Now, I am trying to figure out how to retrieve the data via Smartsheet and store it.
When reading the API information it seems a lot of it is geared towards using outside applications to modify and alter data and sheets, where I am just trying to retrieve and store data.
If someone might be able to help with the right information that will get me where I want to go, it would be highly appreciated!
Thank you for taking the time to read this.
Comments
-
Brett Evans ✭✭✭✭✭✭
you could set this up with Zapier.
-
Thanks Brett for the suggestion, but I was really hoping to get more on the development side of things. I have HTML, CSS, JS, and minor PHP experience and am wondering what do I need to learn to build an integration between two applications like this. It would be great if someone can put the whole connection overview into layman terms.
Thanks!
-
J. Craig Williams ✭✭✭✭✭✭Jacob,
Start here:
//www.santa-greenland.com/developers
This section of the API doc (for Python, easily changed once you land there)
http://smartsheet-platform.github.io/api-docs/?python#intro-to-webhooks
解释这个概念,但从智慧的角度heet being the webhook.
Check your API doc for SurveyGizmo and there should be / could be something similar.
Depending on how that works, you'll want to check out either Add Row(s) or Update Row(s) in the Smartsheet API doc:
http://smartsheet-platform.github.io/api-docs/?python#update-row(s)
That should get you started.
Craig
-
dAVE Inden EmployeeUsing the Smartsheet API you would need to build your own process to sit in the middle of Smartsheet and SurveyGizmo. It could receive the webhook from SurveyGizmo and use that data to send a request to Smartsheet and create the row in your sheet.
As Brett Evans pointed out above, it looks like this could be accomplished with Zapier. This looks like a simpler approach to building your own process and can create the new rows for you. I would usggest starting there and see if it works for your process.
Categories
Try this and see if it produces the expected result. Please be sure to test one 'In Process' with ZERO 'Untrained'. Was this what you expected?<\/p>
=IF(COUNT(CHILDREN(Proficiency@row)) > 0, IF(COUNT(CHILDREN(Proficiency@row)) = COUNTIFS(CHILDREN(Proficiency@row), \"Untrained\"), \"Untrained\", IF(AND(COUNTIFS(CHILDREN(Proficiency@row), \"Untrained\") >= 1, COUNT(CHILDREN(Proficiency@row)) > COUNTIFS(CHILDREN(Proficiency@row), \"Untrained\")), \"In Progress\", IF(COUNTIFS(CHILDREN(Proficiency@row), \"In Process\") >= 1, \"In Process\", IF(COUNTIFS(CHILDREN(Proficiency@row), \"Trained\") >= 1, \"Trained\", IF(COUNTIFS(CHILDREN(Proficiency@row), \"Proficient\") >= 1, \"Proficient\", IF(COUNTIFS(CHILDREN(Proficiency@row), \"Preceptor\") >= 1, \"Preceptor\")))))))<\/p>
Please let me know what we need to tweak<\/p>
Kelly<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":107653,"type":"question","name":"Sum all children rows under parent","excerpt":"I have my project worksheets organized by year, quarter, month, project, etc. Is there a simple formula to sum all children rows one indent in? For example, all months sum up to the quarters which sum up to the year? I only want them to sum at one indent in from the immediate parent row.","snippet":"I have my project worksheets organized by year, quarter, month, project, etc. Is there a simple formula to sum all children rows one indent in? For example, all months sum up to…","categoryID":322,"dateInserted":"2023-07-16T12:23:14+00:00","dateUpdated":"2023-07-17T08:25:09+00:00","dateLastComment":"2023-07-17T11:10:00+00:00","insertUserID":163321,"insertUser":{"userID":163321,"name":"HH_BE1894","title":"Brand Manager","url":"https:\/\/community.smartsheet.com\/profile\/HH_BE1894","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-17T11:09:16+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":163321,"lastUser":{"userID":163321,"name":"HH_BE1894","title":"Brand Manager","url":"https:\/\/community.smartsheet.com\/profile\/HH_BE1894","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-17T11:09:16+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":27,"score":1,"hot":3379103894,"url":"https:\/\/community.smartsheet.com\/discussion\/107653\/sum-all-children-rows-under-parent","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107653\/sum-all-children-rows-under-parent","format":"Rich","lastPost":{"discussionID":107653,"commentID":385523,"name":"Re: Sum all children rows under parent","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385523#Comment_385523","dateInserted":"2023-07-17T11:10:00+00:00","insertUserID":163321,"insertUser":{"userID":163321,"name":"HH_BE1894","title":"Brand Manager","url":"https:\/\/community.smartsheet.com\/profile\/HH_BE1894","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-17T11:09:16+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-17T11:09:14+00:00","dateAnswered":"2023-07-17T09:37:31+00:00","acceptedAnswers":[{"commentID":385514,"body":"
Hi @HH_BE1894<\/a> <\/p> I hope you're well and safe!<\/p> You can add a so-called helper column that indicates a level and then use that in the calculation.<\/p> Try something like this for the helper column. (change the column names as needed)<\/p> I usually add a so-called helper column called Level with the formula below, and then you can use it to identify parents and use it for conditional formatting and more.<\/p> =IF(COUNT(CHILDREN([Task Name]@row)) > 0, COUNT(ANCESTORS()) + 1)<\/p> Would that work\/help? <\/p> I hope that helps!<\/p> Be safe, and have a fantastic week!<\/p> Best,<\/p> Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p> ✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":1},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":107651,"type":"question","name":"With Control Center, is the Global Update feature also able update automated workflows?","excerpt":"I used automated workflows... a lot. We're looking to purchase Control Center, but it is not clear to me if I will be able to update my automated workflows across multiple sheets in the event I have a common change or update to make.","snippet":"I used automated workflows... a lot. We're looking to purchase Control Center, but it is not clear to me if I will be able to update my automated workflows across multiple sheets…","categoryID":343,"dateInserted":"2023-07-16T00:18:56+00:00","dateUpdated":null,"dateLastComment":"2023-07-16T16:19:53+00:00","insertUserID":162134,"insertUser":{"userID":162134,"name":"CamSME","title":"Process Developer","url":"https:\/\/community.smartsheet.com\/profile\/CamSME","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/77LU8YZ28C58\/nJEEKOCCX2CP5.png","dateLastActive":"2023-07-16T17:07:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":122388,"lastUser":{"userID":122388,"name":"Matt Johnson","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Matt%20Johnson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/ZX2A39HRG0VO\/nLJJDDQXUVD4H.JPG","dateLastActive":"2023-07-16T16:20:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":26,"score":null,"hot":3378992929,"url":"https:\/\/community.smartsheet.com\/discussion\/107651\/with-control-center-is-the-global-update-feature-also-able-update-automated-workflows","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107651\/with-control-center-is-the-global-update-feature-also-able-update-automated-workflows","format":"Rich","tagIDs":[466],"lastPost":{"discussionID":107651,"commentID":385483,"name":"Re: With Control Center, is the Global Update feature also able update automated workflows?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385483#Comment_385483","dateInserted":"2023-07-16T16:19:53+00:00","insertUserID":122388,"insertUser":{"userID":122388,"name":"Matt Johnson","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Matt%20Johnson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/ZX2A39HRG0VO\/nLJJDDQXUVD4H.JPG","dateLastActive":"2023-07-16T16:20:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-16T15:01:29+00:00","dateAnswered":"2023-07-16T14:48:33+00:00","acceptedAnswers":[{"commentID":385480,"body":"
