Quickbooks & Smartsheet

2

评论

类别

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

I hope you're well and safe!<\/p>

Yes, that's correct! <\/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","log":{"dateUpdated":"2022-11-14 15:58:18","updateUser":{"userID":153491,"name":"mraskinski_39","url":"https:\/\/community.smartsheet.com\/profile\/mraskinski_39","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-14T15:57:35+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":[{"tagID":265,"urlcode":"Reports","name":"Reports"}]},{"discussionID":97544,"type":"question","name":"How do I automate Smartsheet API \"get_sheet\" function to go through a list of sheets and save data?","excerpt":"Hi, I'm currently creating a catalogue of all sheets in a workspace using the \"get_sheet\" function. The data I'm collecting (crossSheetReferences, cellLinkIn, LinksOut) can only be found within the \"get_sheet\" function. I have a list of sheet ID's (sheet_list) that I use for collecting data. My code (python) looks like…","categoryID":320,"dateInserted":"2022-11-09T14:00:55+00:00","dateUpdated":"2022-11-09T14:03:04+00:00","dateLastComment":"2022-11-09T16:37:29+00:00","insertUserID":153632,"insertUser":{"userID":153632,"name":"J.Greene","url":"https:\/\/community.smartsheet.com\/profile\/J.Greene","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu3_qKeah38cvkR_z_nKFWzkdaHbUfvNXkyD8Vex=s96-c","dateLastActive":"2022-11-10T10:31:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":153632,"lastUserID":153632,"lastUser":{"userID":153632,"name":"J.Greene","url":"https:\/\/community.smartsheet.com\/profile\/J.Greene","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu3_qKeah38cvkR_z_nKFWzkdaHbUfvNXkyD8Vex=s96-c","dateLastActive":"2022-11-10T10:31:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":34,"score":null,"hot":3336015504,"url":"https:\/\/community.smartsheet.com\/discussion\/97544\/how-do-i-automate-smartsheet-api-get-sheet-function-to-go-through-a-list-of-sheets-and-save-data","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/97544\/how-do-i-automate-smartsheet-api-get-sheet-function-to-go-through-a-list-of-sheets-and-save-data","format":"Rich","tagIDs":[227],"lastPost":{"discussionID":97544,"commentID":350542,"name":"Re: How do I automate Smartsheet API \"get_sheet\" function to go through a list of sheets and save data?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/350542#Comment_350542","dateInserted":"2022-11-09T16:37:29+00:00","insertUserID":153632,"insertUser":{"userID":153632,"name":"J.Greene","url":"https:\/\/community.smartsheet.com\/profile\/J.Greene","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu3_qKeah38cvkR_z_nKFWzkdaHbUfvNXkyD8Vex=s96-c","dateLastActive":"2022-11-10T10:31:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"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-10T10:32:07+00:00","dateAnswered":"2022-11-09T14:31:39+00:00","acceptedAnswers":[{"commentID":350498,"body":"

I'm not familiar with Python, but if that's your code I would guess that your saving over the response variable each time you go through your loop. Meaning the last sheet that you get_sheet on, is the only one in the response variable. <\/p>

If that's the case, I think you would need to add the response variable to some kind of a collection\/array after each call.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-10 10:32:07","updateUser":{"userID":153632,"name":"J.Greene","url":"https:\/\/community.smartsheet.com\/profile\/J.Greene","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu3_qKeah38cvkR_z_nKFWzkdaHbUfvNXkyD8Vex=s96-c","dateLastActive":"2022-11-10T10:31:56+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":[{"tagID":227,"urlcode":"API Developers","name":"API and Developers"}]},{"discussionID":97357,"type":"question","name":"In 10,000ft\/ResourceManagement - How can I get full reports in an automated way? (api or otherwise)","excerpt":"Is there a way to get a full report in an automated fashion? By full report, I mean when you go to rm.smartsheet.com\/report, and click \"Run Report\" or \"Request Underlying Data\" and you get back a full csv. (format doesn't matter, csv or json formats are both fine). I would like to download the report automatically on a…","categoryID":320,"dateInserted":"2022-11-03T22:21:30+00:00","dateUpdated":"2022-11-09T19:58:12+00:00","dateLastComment":"2022-11-09T18:22:06+00:00","insertUserID":154548,"insertUser":{"userID":154548,"name":"Steve Chang","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Steve%20Chang","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu0zfEGfu8UQWUd1TwYXu_cVDWZ6cFleT6Jb_7MH=s96-c","dateLastActive":"2022-11-11T18:27:22+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-11-14T16:03:07+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":60,"score":null,"hot":3335534016,"url":"https:\/\/community.smartsheet.com\/discussion\/97357\/in-10-000ft-resourcemanagement-how-can-i-get-full-reports-in-an-automated-way-api-or-otherwise","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/97357\/in-10-000ft-resourcemanagement-how-can-i-get-full-reports-in-an-automated-way-api-or-otherwise","format":"Rich","tagIDs":[227,277,278,468],"lastPost":{"discussionID":97357,"commentID":350582,"name":"Re: In 10,000ft\/ResourceManagement - How can I get full reports in an automated way? (api or otherwise)","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/350582#Comment_350582","dateInserted":"2022-11-09T18:22:06+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-11-14T16:03:07+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/TI6MU0062U61\/screen-shot-2022-11-03-at-3-20-04-pm.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen Shot 2022-11-03 at 3.20.04 PM.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-11-09T18:49:54+00:00","dateAnswered":"2022-11-09T18:22:06+00:00","acceptedAnswers":[{"commentID":350582,"body":"

Hi @Steve Chang<\/a> <\/p>

Thank you for this additional information and the details listed!<\/p>

At the moment, the response the API provides is what we support via the public APIs. At this time I would suggest creating multiple API calls to get additional data, or use the CSV data directly for analysis. <\/p>

Please feel free to let the Product team know about your feature request by creating an Idea Post<\/strong> in the Smartsheet Product Feedback and Ideas topic<\/a> here in the Community. This will allow other users to vote on your enhancement idea! The top-voted posts are reviewed monthly. <\/p>

Cheers,<\/p>

Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-09 18:49:54","updateUser":{"userID":154548,"name":"Steve Chang","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Steve%20Chang","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu0zfEGfu8UQWUd1TwYXu_cVDWZ6cFleT6Jb_7MH=s96-c","dateLastActive":"2022-11-11T18:27:22+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":[{"tagID":227,"urlcode":"API Developers","name":"API and Developers"},{"tagID":277,"urlcode":"Integrations","name":"Integrations"},{"tagID":278,"urlcode":"Importing and Exporting","name":"Importing and Exporting"},{"tagID":468,"urlcode":"resource-management","name":"Resource Management"}]}],"title":"Trending in API & Developers","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">