Can I populate Smartsheet rows from a SQL Database read?

Senthil Anandarangan
Senthil Anandarangan ✭
inAPI & Developers

I have data on Snowflake data warehouse and also on a SQL server table. Does Smartsheet support connection to Snowflake or SQL database to read data and populate rows on a Smartsheet?

Tags:
· Share on Facebook Share on Twitter

Answers

Categories

Hi @sgolux<\/a> <\/p>

The general length is usually 26 characters, <\/strong>however I would not suggest limiting your solution to expect that count in case it fluctuates in the future. <\/p>

You may want to build your database to allow for some extra characters in there just in case, or have some exception handling that would notify you if a shared secret is ever generated that is longer than what you're expecting.<\/p>

Cheers,<\/p>

Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-01 15:35:09","updateUser":{"userID":148352,"name":"sgolux","url":"https:\/\/community.smartsheet.com\/profile\/sgolux","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-05T23:14:12+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","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":[]},{"discussionID":97976,"type":"question","name":"When a sheet is deleted, are any webhooks associated with that sheet deleted or disabled?","excerpt":"Hello. Imagine you have created a sheet, and used the webhook API to designate a webhook about that sheet, and enabled that webhook. QUESTIONS: If you delete the sheet, are you guaranteed a webhook event for a deleted sheet? And if so, how would you know the event was about the sheet deletion? Is the webhook associated…","categoryID":320,"dateInserted":"2022-11-20T23:52:02+00:00","dateUpdated":null,"dateLastComment":"2022-11-25T11:38:35+00:00","insertUserID":148352,"insertUser":{"userID":148352,"name":"sgolux","url":"https:\/\/community.smartsheet.com\/profile\/sgolux","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-05T23:14:12+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-12-06T11:19:42+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":64,"score":null,"hot":3338366437,"url":"https:\/\/community.smartsheet.com\/discussion\/97976\/when-a-sheet-is-deleted-are-any-webhooks-associated-with-that-sheet-deleted-or-disabled","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/97976\/when-a-sheet-is-deleted-are-any-webhooks-associated-with-that-sheet-deleted-or-disabled","format":"Rich","lastPost":{"discussionID":97976,"commentID":352269,"name":"Re: When a sheet is deleted, are any webhooks associated with that sheet deleted or disabled?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/352269#Comment_352269","dateInserted":"2022-11-25T11:38:35+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-12-06T11:19:42+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-11-24T19:29:58+00:00","dateAnswered":"2022-11-24T11:23:41+00:00","acceptedAnswers":[{"commentID":352209,"body":"

Hi @sgolux<\/a><\/p>

When a sheet is deleted, the webhook will become disabled<\/em> with a status of DISABLED_SCOPE_INACCESSIBLE<\/code><\/strong>. <\/p>

A status change callback will occur to indicate that the webhook status has changed with a scopeObjectId<\/code> containing the ID of the deleted sheet.<\/p>

The webhook is automatically re-enabled if access to the sheet is restored (so yes, if the deleted sheet is restored).<\/p>

You can find this information under Webhook Status<\/strong> in the API Documentation, under the \"Disabled_Scope_Inaccessible\" status, here:  https:\/\/smartsheet.redoc.ly\/tag\/webhooksDescription#section\/Webhook-Status<\/a><\/p>


<\/p>

As a note, I believe that this is the same behaviour if you lose sharing access to the sheet as well, since you will no longer have access to that data.<\/p>

If it is important to know the difference between sheet being deleted and loss of sharing access, I would suggest looking at that via event reporting,<\/strong> if your plan has access to it. <\/strong>Here's more information:<\/p>

\n \n https:\/\/help.smartsheet.com\/articles\/2479296-event-reporting-monitor-how-data-is-used-across-your-organization\n <\/a>\n<\/div>

Cheers,<\/p>

Genevieve<\/p>"},{"commentID":352269,"body":"

Hi @sgolux<\/a> <\/p>

You are correct: if you have the Publish URL active on a sheet, and then delete the sheet, when you recover that deleted sheet the Publish URLs will default to being turned off<\/strong>. You would need to go into that recovered sheet and turn Publishing back on again. <\/p>

Cheers,<\/p>

Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-24 19:29:58","updateUser":{"userID":148352,"name":"sgolux","url":"https:\/\/community.smartsheet.com\/profile\/sgolux","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-05T23:14:12+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","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":[]},{"discussionID":97957,"type":"question","name":"Is there a way to remove a contact from all notifications at one time?","excerpt":"I have several sheets with hundreds of notifications and need to remove one contact from many notifications. Can the contact be removed from all the notifications at once? I have already transferred ownership of the sheets and deleted the contact from the account. How do I remove the contact from the notifications without…","categoryID":320,"dateInserted":"2022-11-18T21:04:38+00:00","dateUpdated":"2022-11-22T13:18:58+00:00","dateLastComment":"2022-11-22T11:14:05+00:00","insertUserID":120666,"insertUser":{"userID":120666,"name":"Erin Burley","url":"https:\/\/community.smartsheet.com\/profile\/Erin%20Burley","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AATXAJyMRdKFJl7jrgie17OXggJokjURliE2Ags8DtYWSQ=s96-c","dateLastActive":"2022-11-22T12:45:01+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-12-06T11:19:42+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":44,"score":null,"hot":3337921723,"url":"https:\/\/community.smartsheet.com\/discussion\/97957\/is-there-a-way-to-remove-a-contact-from-all-notifications-at-one-time","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/97957\/is-there-a-way-to-remove-a-contact-from-all-notifications-at-one-time","format":"Rich","lastPost":{"discussionID":97957,"commentID":351977,"name":"Re: Is there a way to remove a contact from all notifications at one time?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/351977#Comment_351977","dateInserted":"2022-11-22T11:14:05+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-12-06T11:19:42+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-11-22T12:48:03+00:00","dateAnswered":"2022-11-22T11:14:05+00:00","acceptedAnswers":[{"commentID":351977,"body":"

Hi @Erin Burley<\/a> <\/p>

This will depend on how the action block<\/a> is set up:<\/p>