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);
}
