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.
Smartsheet API report creation
Hi,
We have a lot of reports, they have only small differences.
Normally it is just a filter e.g. name of "assigned to".
If we have to slightly change these reports, we have to change all the reports by hand.
Is it possible to create/change reports with the API?
I tried to do it but i did not found it in the API (Smartsheet Java SDK).
To create folders it is possible to make something like that:
Folder folder = new Folder.CreateFolderBuilder().setName("New Folder").build();
folder = smartsheet.homeResources().folderResources().createFolder(folder);
but the report ressources has no creation method
report = smartsheet.reportResources().createReport(report);
If this feature not exists, this is my feature request :-)
Thanks a lot.
Comments
-
Shaine Greenwood Employee
Hello Isidor,
There currently isn't a way to create reports, or change the Report Builder criteria from the API. I've got your vote down for this on our enhancement request list for further review by our Development team.
-
J. Craig Williams ✭✭✭✭✭✭
Please add my vote for this too.
Craig
-
J. Craig Williams ✭✭✭✭✭✭
Also Isidor,
In some cases, the new (as of this writing) feature of using "Current User" as the criteria may solve some of this problem.
Craig
-
Steve Weil Employee
We understand that API support for modifying reports would be very useful. It's on our backlog, but it's a complex feature and I can't commit to any date.
Steve
-
寻找ward to this inclusion in the API.
-
Please add my vote for this too.
Paul
Categories
I hope you're well and safe!<\/p>
There's a known issue at the moment.<\/p>
I'll get back to the post if I can find the thread.<\/p>
I hope that helps!<\/p>
Be safe, and have a fantastic weekend!<\/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":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":108880,"type":"question","name":"Recover a Row that was accidentally moved then deleted","excerpt":"I was attempting to copy a row from sheet 1 to sheet 2, but I accidentally moved the row then deleted it, but then realized belatedly that the original (now deleted) data in sheet 1 had been moved. Apparently one can not simply use the \"undo action\" arrow after moving something--the option is grayed out as in not…","snippet":"I was attempting to copy a row from sheet 1 to sheet 2, but I accidentally moved the row then deleted it, but then realized belatedly that the original (now deleted) data in sheet…","categoryID":321,"dateInserted":"2023-08-11T22:27:56+00:00","dateUpdated":null,"dateLastComment":"2023-08-12T05:12:42+00:00","insertUserID":165013,"insertUser":{"userID":165013,"name":"GlennJo","title":"Riparian Stewardship Program Manager","url":"https:\/\/community.smartsheet.com\/profile\/GlennJo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-12T03:46:04+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":165013,"lastUser":{"userID":165013,"name":"GlennJo","title":"Riparian Stewardship Program Manager","url":"https:\/\/community.smartsheet.com\/profile\/GlennJo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-12T03:46:04+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":28,"score":null,"hot":3383611238,"url":"https:\/\/community.smartsheet.com\/discussion\/108880\/recover-a-row-that-was-accidentally-moved-then-deleted","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108880\/recover-a-row-that-was-accidentally-moved-then-deleted","format":"Rich","lastPost":{"discussionID":108880,"commentID":390348,"name":"Re: Recover a Row that was accidentally moved then deleted","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/390348#Comment_390348","dateInserted":"2023-08-12T05:12:42+00:00","insertUserID":165013,"insertUser":{"userID":165013,"name":"GlennJo","title":"Riparian Stewardship Program Manager","url":"https:\/\/community.smartsheet.com\/profile\/GlennJo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-12T03:46:04+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":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-12T03:46:02+00:00","dateAnswered":"2023-08-11T23:45:38+00:00","acceptedAnswers":[{"commentID":390342,"body":"