public Folder CreateFolderHome() { Folder folder = new Folder.CreateFolderBuilder("CSharp SDK Test").Build(); Folder newFolderHome = smartsheet.HomeResources.FolderResources.CreateFolder(folder); return(newFolderHome); }
public virtual void TestCreateFolder() { server.setResponseBody("../../../TestSDK/resources/createFolder.json"); Folder newFolder = new Folder.CreateFolderBuilder("New folder").Build(); Folder createdFolder = folderResource.CreateFolder(123L, newFolder); Assert.AreEqual(createdFolder.Name, newFolder.Name); }
public virtual void TestCreateFolder() { server.setResponseBody("../../../TestSDK/resources/createFolder.json"); Folder folder = new Folder.CreateFolderBuilder("New folder").Build(); Folder newFolder = workspaceFolderResources.CreateFolder(1234L, folder); Assert.AreEqual(1486948649985924L, (long)newFolder.Id); Assert.AreEqual("New folder", newFolder.Name); }
public virtual void TestCreateFolder() { server.setResponseBody("../../../TestSDK/resources/createFolder.json"); Folder folder = new Folder.CreateFolderBuilder("New folder").Build(); Folder newFolder = homeFolderResources.CreateFolder(folder); Assert.True(1486948649985924L == newFolder.Id); Assert.AreEqual(folder.Name, newFolder.Name); }
public static void SampleCode() { // Set the Access Token Token token = new Token(); token.AccessToken = "YOUR_TOKEN"; // Use the Smartsheet Builder to create a Smartsheet SmartsheetClient smartsheet = new SmartsheetBuilder().SetAccessToken(token.AccessToken).Build(); if (false) { // List all contents (specify 'include' parameter with value of "source"). Home home = smartsheet.HomeResources.GetHome(new HomeInclusion[] { HomeInclusion.SOURCE }); // List folders in "Sheets" folder (specify 'includeAll' parameter with value of "true"). IList <Folder> homeFolders = home.Folders; foreach (Folder tmpFolder in homeFolders) { Console.WriteLine("folder:" + tmpFolder.Name); } // List sheets (omit 'include' parameter and pagination parameters). PaginatedResult <Sheet> homeSheetsResult = smartsheet.SheetResources.ListSheets(null, null); foreach (Sheet tmpSheet in homeSheetsResult.Data) { Console.WriteLine("sheet:" + tmpSheet.Name); } // Create folder in home Folder folder = new Folder.CreateFolderBuilder("New Folder").Build(); folder = smartsheet.HomeResources.FolderResources.CreateFolder(folder); Console.WriteLine("Folder ID:" + folder.Id + ", Folder Name:" + folder.Name); //========================================= } // Setup text Column Object Column textColumn = new Column.CreateSheetColumnBuilder("To Do List", true, ColumnType.TEXT_NUMBER).Build(); // Setup checkbox Column Object Column checkboxColumn = new Column.CreateSheetColumnBuilder("Finished", false, ColumnType.CHECKBOX).Build(); // Add the 2 Columns (flag & text) to a new Sheet Object Sheet sheet = new Sheet.CreateSheetBuilder("New Sheet", new Column[] { textColumn, checkboxColumn }).Build(); // Send the request to create the sheet @ Smartsheet sheet = smartsheet.SheetResources.CreateSheet(sheet); //========================================= // Example: Add two rows Func <string, Row> addRowHelper = primaryColVal => { var cells = new Cell[] { new Cell.AddCellBuilder(sheet.GetColumnByIndex(0).Id, primaryColVal).Build() }; var rows = new Row[] { new Row.AddRowBuilder(true, null, null, null, null).SetCells(cells).Build() }; return(smartsheet.SheetResources.RowResources.AddRows(sheet.Id.Value, rows)[0]); }; var rowA = addRowHelper("a"); var rowB = addRowHelper("b"); // Example: Move rowB above rowA var updateRowRequest = new Row.UpdateRowBuilder(rowB.Id) .SetSiblingId(rowA.Id) .SetAbove(true) .Build(); var updateRowResponse = smartsheet.SheetResources.RowResources.UpdateRows(sheet.Id.Value, new Row[] { updateRowRequest }); //Indent rowA under rowB updateRowRequest = new Row.UpdateRowBuilder(rowA.Id) .SetParentId(rowB.Id) .Build(); updateRowResponse = smartsheet.SheetResources.RowResources.UpdateRows(sheet.Id.Value, new Row[] { updateRowRequest }); //========================================= //// Update two cells on a row //IList<Cell> cells = new Cell.UpdateRowCellsBuilder().AddCell(5111621270955908L, "test11", false). // AddCell(2859821457270660L, "test22").Build(); //smartsheet.Rows().UpdateCells(6497447011739524L, cells); ////========================================= //// Create a row and sheet level discussion with an initial comment //Comment comment = new Comment.AddCommentBuilder().SetText("Hello World").Build(); //Discussion discussion = new Discussion.CreateDiscussionBuilder().SetTitle("New Discussion"). // SetComment(comment).Build(); //smartsheet.Rows().Discussions().CreateDiscussion(6497447011739524L, discussion); //smartsheet.Sheets().Discussions().CreateDiscussion(7370846613333892L, discussion); ////========================================= //// Update a folder name //folder = new Folder.UpdateFolderBuilder().SetName("A Brand New New Folder").SetID(2545279862892420L).Build(); //smartsheet.Folders().UpdateFolder(folder); ////========================================= //// Create 3 users to share a sheet with //IList<User> users = new List<User>(); //User user = new User(); //user.Email = "*****@*****.**"; //users.Add(user); //User user1 = new User(); //user1.Email = "*****@*****.**"; //users.Add(user1); //User user2 = new User(); //user2.Email = "*****@*****.**"; //users.Add(user2); //// Add the message, subject & users to share with //MultiShare multiShare = new MultiShare.ShareToManyBuilder().SetMessage("Here is the sheet I am sharing with you"). // SetAccessLevel(AccessLevel.VIEWER).SetSubject("Sharing a Smartsheet with you").SetUsers(users).Build(); //// Share the specified sheet with the users. //smartsheet.Sheets().Shares().ShareTo(7370846613333892L, multiShare, true); ////========================================= //// Create a single share to a specified email address with the specified access level //Share share = new Share.ShareToOneBuilder().SetEmail("*****@*****.**").SetAccessLevel(AccessLevel.VIEWER) // .Build(); //// Add the share to a specific sheet //smartsheet.Sheets().Shares().ShareTo(7370846613333892L, share); ////========================================= //// Create a share with the specified access level //share = new Share.UpdateShareBuilder().SetAccessLevel(AccessLevel.VIEWER).Build(); //// Update the share permission on the specified sheet for the specified user. //smartsheet.Sheets().Shares().UpdateShare(7370846613333892L, 3433212006426500L, share); ////========================================= //// Create 3 cells //Cell cell = new Cell(); //cell.Value = "Cell1"; //cell.Strict = false; //cell.ColumnId = 5111621270955908L; //Cell cell2 = new Cell(); //cell2.Value = "Cell2"; //cell2.ColumnId = 2859821457270660L; //Cell cell3 = new Cell(); //cell3.Value = "cell3"; //cell3.ColumnId = 7877251644581764L; //// Store the cells in a list //List<Cell> cells1 = new List<Cell>(); //cells1.Add(cell); //cells1.Add(cell2); //cells1.Add(cell3); //// Create a row and add the list of cells to the row //Row row = new Row(); //row.Cells = cells1; //// Add two rows to a list of rows. //List<Row> rows = new List<Row>(); //rows.Add(row); //rows.Add(row); //// Add the rows to the row wrapper and set the location to insert the rows //RowWrapper rowWrapper = new RowWrapper.InsertRowsBuilder().SetRows(rows).SetToBottom(true).Build(); //// Add the rows to the specified sheet //smartsheet.Sheets().Rows().InsertRows(7370846613333892L, rowWrapper); //// Setup a row to be moved to the top of a sheet //RowWrapper rowWrapper1 = new RowWrapper.MoveRowBuilder().SetToTop(true).Build(); //// Move the specified row //smartsheet.Rows().MoveRow(5701744190613380L, rowWrapper1); ////========================================= //// Create a sheet that is a copy of a template //Sheet sheet1 = new Sheet.CreateFromTemplateOrSheetBuilder().SetFromId(7370846613333892L). // SetName("Copy of a Template").Build(); //// Create the new sheet from the template //smartsheet.Sheets().CreateSheetFromExisting(sheet1, new ObjectInclusion[] { ObjectInclusion.DATA, // ObjectInclusion.ATTACHMENTS, ObjectInclusion.DISCUSSIONS }); ////========================================= //// Setup a sheet with a new name //Sheet sheet2 = new Sheet.UpdateSheetBuilder().SetName("TESTING123").SetID(7370846613333892L).Build(); //// Update the sheet with the new name //smartsheet.Sheets().UpdateSheet(sheet2); ////========================================= //// Setup a publishing status to give a rich version of the sheet as read only //SheetPublish publish = new SheetPublish.PublishStatusBuilder().SetReadOnlyFullEnabled(true). // SetReadOnlyLiteEnabled(false).SetIcalEnabled(false).SetReadWriteEnabled(false).Build(); //// Setup the specified sheet with the new publishing status //smartsheet.Sheets().UpdatePublishStatus(7370846613333892L, publish); ////========================================= //// Setup a user with an email address and full permission //User user3 = new User.AddUserBuilder().SetEmail("*****@*****.**").SetAdmin(true). // SetLicensedSheetCreator(true).Build(); //// Create the user account //smartsheet.Users().AddUser(user3); ////========================================= //// Setup a user with new privileges //User user4 = new User.UpdateUserBuilder().SetAdmin(false).SetLicensedSheetCreator(false). // SetID(4187958019417988L).Build(); //// Send the request to update the users account with the new privileges //smartsheet.Users().UpdateUser(user4); ////========================================= //// Create a workspace with a specific name and ID //Workspace workspace = new Workspace.UpdateWorkspaceBuilder().SetName("Workspace Name1"). // SetID(8257948486002564L).Build(); //// Update the workspace with the new name. //smartsheet.Workspaces().UpdateWorkspace(workspace); ////========================================= //smartsheet.Sheets().Attachments().AttachFile(4844590336370564L, // @"../../../TestSDK/resources/getPDF.pdf", "application/pdf"); //Attachment attach = new Attachment(); //attach.Name = "Test"; //attach.Url = "http://google.com"; //attach.AttachmentType = AttachmentType.LINK; //smartsheet.Sheets().Attachments().AttachURL(4844590336370564L, attach); }