Beispiel #1
0
        public void TestAttachmentResources()
        {
            SmartsheetClient smartsheet = new SmartsheetBuilder().SetMaxRetryTimeout(30000).Build();
            long             sheetId    = CreateSheet(smartsheet);

            long discussionId = AttachFileAndUrlToComment(smartsheet, sheetId);

            ListDiscussionAttachments(smartsheet, sheetId, discussionId);

            long rowId = AttachFileAndUrlToRow(smartsheet, sheetId);

            ListRowAttachments(smartsheet, sheetId, rowId);

            long attachmentId = AttachFileAndUrlToSheet(smartsheet, sheetId);

            GetAttachment(smartsheet, sheetId, attachmentId);

            AttachNewVersion(smartsheet, sheetId, attachmentId);

            ListAttachmentVersions(smartsheet, sheetId, attachmentId);

            DeleteAttachment(smartsheet, sheetId, attachmentId);

            smartsheet.SheetResources.DeleteSheet(sheetId);
        }
Beispiel #2
0
        public static Sheet InitializeSheet()
        {
            SmartsheetClient smartsheet = new SmartsheetBuilder()
                                          .SetAccessToken(Secrets.SmartsheetKey)
                                          .Build();

            Sheet sheet = smartsheet.SheetResources.GetSheet(
                Secrets.AssetSheetId,     // sheetId
                null,                     // IEnumerable<SheetLevelInclusion> includes
                null,                     // IEnumerable<SheetLevelExclusion> excludes
                null,                     // IEnumerable<long> rowIds
                null,                     // IEnumerable<int> rowNumbers
                null,                     // IEnumerable<long> columnIds
                null,                     // Nullable<long> pageSize
                null                      // Nullable<long> page
                );

            // Instantiate a new column map every time the Sheet is initialized
            ColumnMap = new Dictionary <string, long>();

            // Build column map for later reference
            foreach (Column column in sheet.Columns)
            {
                ColumnMap.Add(column.Title, (long)column.Id);
            }

            return(sheet);
        }
        private static void UseTokenResources()
        {
            string accessToken = ConfigurationManager.AppSettings["accessToken"];

            SmartsheetClient smartsheet = new SmartsheetBuilder().SetAccessToken(accessToken).Build();

            try
            {
                smartsheet.TokenResources.GetAccessToken();
                Assert.Fail();
            }
            catch
            {
            }
            try
            {
                smartsheet.TokenResources.RefreshAccessToken();
                Assert.Fail();
            }
            catch
            {
            }
            smartsheet.TokenResources.RevokeAccessToken();
            try
            {
                smartsheet.SheetResources.ListSheets(null, null);
                Assert.Fail();
            }
            catch
            {
            }
        }
        public void TestSheetMoveResources()
        {
            SmartsheetClient smartsheet = new SmartsheetBuilder().SetMaxRetryTimeout(30000).Build();
            // Before
            // Sheet
            // Folder

            // After
            //
            // Folder-----SheetCopy
            long folderId = CreateFolderInHome(smartsheet, "Folder1");

            long sheetId = CreateSheet(smartsheet);

            ContainerDestination destination = new ContainerDestination
            {
                DestinationId   = folderId,
                DestinationType = DestinationType.FOLDER,
                //NewName = "hello"
            };
            Sheet newMovedSheet = smartsheet.SheetResources.MoveSheet(sheetId, destination);

            Assert.IsTrue(newMovedSheet.Name == "new sheet");

            long movedSheetId = newMovedSheet.Id.Value;

            Sheet movedSheet = smartsheet.SheetResources.GetSheet(movedSheetId, null, null, null, null, null, null, null);

            Assert.IsTrue(movedSheet.Name == "new sheet");

            //Deleting the folder will also delete the sheet.
            DeleteFolders(smartsheet, folderId);
        }
Beispiel #5
0
        static void Main(string[] args)
        {
            // Initialize client
            SmartsheetClient ss = new SmartsheetBuilder()
                                  // .SetAccessToken("feo3t736fc2lpansdevs4a1as")       // TODO: Set your API access in environment variable SMARTSHEET_ACCESS_TOKEN or else here
                                  .Build();


            // List all sheets
            PaginatedResult <Sheet> sheets = ss.SheetResources.ListSheets(null, null, null);

            Console.WriteLine("Found " + sheets.TotalCount + " sheets");

            if (sheets.TotalCount > 0)
            {
                long sheetId = (long)sheets.Data[0].Id;                 // Default first sheet

                // sheetId = 5670346721388420L;                         // TODO: Uncomment if you wish to read a specific sheet

                Console.WriteLine("Loading sheet id: " + sheetId);

                // Load the entire sheet
                var sheet = ss.SheetResources.GetSheet(sheetId, null, null, null, null, null, null, null);
                Console.WriteLine("Loaded " + sheet.Rows.Count + " rows from sheet: " + sheet.Name);

                // Display the first 5 rows
                foreach (Row row in sheet.Rows.Take(5))
                {
                    dumpRow(row, sheet.Columns);
                }
            }

            Console.WriteLine("Done (Hit enter)");                      // Keep console window open
            Console.ReadLine();
        }
Beispiel #6
0
        private async void btnSubmitToken_Click(object sender, EventArgs e)
        {
            Token = txtAccessToken.Text;
            // Build the client
            SmartsheetClient client = null;

            try
            {
                // Build the client in a thread to avoid UI Lock
                await Task.Factory.StartNew(() => client = new SmartsheetBuilder().SetAccessToken(Token).Build());
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

            // If the client has been successfully created
            if (client != null)
            {
                // Create a client form and show it
                ClientForm clientForm = new ClientForm(client, this);
                clientForm.Show();

                // Hide the login form
                this.Visible = false;
            }
        }
Beispiel #7
0
        public void TestSheetCopyResources()
        {
            string accessToken = ConfigurationManager.AppSettings["accessToken"];

            SmartsheetClient smartsheet = new SmartsheetBuilder().SetAccessToken(accessToken).Build();
            // Before
            // Sheet
            // Folder

            // After
            // Sheet
            // Folder-----SheetCopy
            long folderId = CreateFolderInHome(smartsheet, "Folder1");

            long sheetId = CreateSheet(smartsheet);

            ContainerDestination destination = new ContainerDestination
            {
                DestinationId   = folderId,
                DestinationType = DestinationType.FOLDER,
                NewName         = "SheetCopy"
            };
            Sheet newCopiedSheet = smartsheet.SheetResources.CopySheet(sheetId, destination, new SheetCopyInclusion[] { SheetCopyInclusion.ALL });

            Assert.IsTrue(newCopiedSheet.Name == "SheetCopy");

            long copiedSheetId = newCopiedSheet.Id.Value;

            Sheet copiedSheet = smartsheet.SheetResources.GetSheet(copiedSheetId, null, null, null, null, null, null, null);

            Assert.IsTrue(copiedSheet.Name == "SheetCopy");

            DeleteFolders(smartsheet, folderId);
            smartsheet.SheetResources.DeleteSheet(sheetId);
        }
        public void TestAttachmentResources()
        {
            string accessToken = ConfigurationManager.AppSettings["accessToken"];

            SmartsheetClient smartsheet = new SmartsheetBuilder().SetAccessToken(accessToken).Build();
            long             sheetId    = CreateSheet(smartsheet);

            long discussionId = AttachFileAndUrlToComment(smartsheet, sheetId);

            ListDiscussionAttachments(smartsheet, sheetId, discussionId);

            long rowId = AttachFileAndUrlToRow(smartsheet, sheetId);

            ListRowAttachments(smartsheet, sheetId, rowId);

            long attachmentId = AttachFileAndUrlToSheet(smartsheet, sheetId);

            GetAttachment(smartsheet, sheetId, attachmentId);

            AttachNewVersion(smartsheet, sheetId, attachmentId);

            ListAttachmentVersions(smartsheet, sheetId, attachmentId);


            DeleteAttachment(smartsheet, sheetId, attachmentId);

            smartsheet.SheetResources.DeleteSheet(sheetId);
        }
Beispiel #9
0
        private static void UseTokenResources()
        {
            SmartsheetClient smartsheet = new SmartsheetBuilder().SetMaxRetryTimeout(30000).Build();

            try
            {
                smartsheet.TokenResources.GetAccessToken();
                Assert.Fail();
            }
            catch
            {
            }
            try
            {
                smartsheet.TokenResources.RefreshAccessToken();
                Assert.Fail();
            }
            catch
            {
            }
            smartsheet.TokenResources.RevokeAccessToken();
            try
            {
                smartsheet.SheetResources.ListSheets(null, null);
                Assert.Fail();
            }
            catch
            {
            }
        }
Beispiel #10
0
        public void TestWorkspaceCopyResources()
        {
            SmartsheetClient smartsheet = new SmartsheetBuilder().SetMaxRetryTimeout(30000).Build();
            // Before
            // Workspace1
            // Folder2

            // After
            // Workspace1
            // Folder2-----Workspace1Copy

            Workspace workspace   = smartsheet.WorkspaceResources.CreateWorkspace(new Workspace.CreateWorkspaceBuilder("Workspace1").Build());
            long      workspaceId = workspace.Id.Value;

            ContainerDestination destination = new ContainerDestination
            {
                NewName = "Workspace1Copy"
            };
            Workspace newCopiedWorkspace = smartsheet.WorkspaceResources.CopyWorkspace(workspaceId, destination, new WorkspaceCopyInclusion[] { WorkspaceCopyInclusion.ALL }, new WorkspaceRemapExclusion[] { WorkspaceRemapExclusion.CELL_LINKS });

            Assert.IsTrue(newCopiedWorkspace.Name == "Workspace1Copy");

            long copiedWorkspaceId = newCopiedWorkspace.Id.Value;

            Workspace copiedWorkspace = smartsheet.WorkspaceResources.GetWorkspace(copiedWorkspaceId, null, null);

            Assert.IsTrue(copiedWorkspace.Name == "Workspace1Copy");

            smartsheet.WorkspaceResources.DeleteWorkspace(workspaceId);
            smartsheet.WorkspaceResources.DeleteWorkspace(copiedWorkspaceId);
        }
        public void TestFolderCopyResources()
        {
            string accessToken = ConfigurationManager.AppSettings["accessToken"];

            SmartsheetClient smartsheet = new SmartsheetBuilder().SetAccessToken(accessToken).Build();
            // Before
            // Folder1-----SubFolder1
            // Folder2

            // After
            // Folder1-----SubFolder1
            // Folder2-----SubFolder1Copy
            long createdFolderInHomeId1 = CreateFolderInHome(smartsheet, "Folder1");
            long createdFolderInHomeId2 = CreateFolderInHome(smartsheet, "Folder2");

            long createdFolderInFolderId = CreateFolderInFolder(smartsheet, createdFolderInHomeId1, "SubFolder1");

            ContainerDestination destination = new ContainerDestination
            {
                DestinationId   = createdFolderInHomeId2,
                DestinationType = DestinationType.FOLDER,
                NewName         = "SubFolder1Copy"
            };
            Folder newCopiedFolder = smartsheet.FolderResources.CopyFolder(createdFolderInFolderId, destination, new FolderCopyInclusion[] { FolderCopyInclusion.ALL }, new FolderRemapExclusion[] { FolderRemapExclusion.CELL_LINKS });

            Assert.IsTrue(newCopiedFolder.Name == "SubFolder1Copy");

            long copiedFolderId = newCopiedFolder.Id.Value;

            Folder copiedFolder = smartsheet.FolderResources.GetFolder(copiedFolderId, null);

            Assert.IsTrue(copiedFolder.Name == "SubFolder1Copy");

            DeleteFolders(smartsheet, createdFolderInHomeId1, createdFolderInHomeId2);
        }
        public void TestContactResources()
        {
            SmartsheetClient smartsheet = new SmartsheetBuilder().SetMaxRetryTimeout(30000).Build();

            PaginatedResult <Contact> contactResults = smartsheet.ContactResources.ListContacts(null);

            Assert.IsTrue(contactResults.TotalCount >= 0);
        }
        public void TestHomeResources()
        {
            SmartsheetClient smartsheet = new SmartsheetBuilder().SetMaxRetryTimeout(30000).Build();

            Home home = smartsheet.HomeResources.GetHome(new HomeInclusion[] { HomeInclusion.SOURCE });

            Assert.IsTrue(home != null);
        }
Beispiel #14
0
        public ActionResult Index()
        {
            List <ErrorReport>       model       = new List <ErrorReport>();
            SmartsheetClient         sheetclient = new SmartsheetBuilder().SetAccessToken(token).Build();
            PaginatedResult <Column> cols        = sheetclient.SheetResources.ColumnResources.ListColumns(sheetid, null, null);
            Sheet sheet = sheetclient.SheetResources.GetSheet(sheetid, null, null, null, null, null, null, null); //Gets the sheet id

            foreach (Row r in sheet.Rows)
            {
                ErrorReport newreport = new ErrorReport();
                try
                {
                    newreport.ID = int.Parse(r.Cells[0].Value.ToString());
                }
                catch
                {
                    newreport.ID = 0;
                }
                newreport.Date     = DateTime.Parse(r.Cells[1].Value.ToString());
                newreport.UserName = r.Cells[2].Value.ToString();
                try
                {
                    newreport.ErrorMessage = r.Cells[3].Value.ToString();
                }
                catch
                {
                    newreport.ErrorMessage = "";
                }
                try
                {
                    newreport.Enhancement = r.Cells[4].Value.ToString();
                }
                catch
                {
                    newreport.Enhancement = "";
                }
                try
                {
                    newreport.Description = r.Cells[5].Value.ToString();
                }
                catch
                {
                    newreport.Description = "";
                }
                newreport.Category = r.Cells[6].Value.ToString();
                try
                {
                    newreport.Status = r.Cells[7].Value.ToString();
                }
                catch
                {
                    newreport.Status = "";
                }
                newreport.Modified = DateTime.Parse(r.Cells[8].Value.ToString());
                model.Add(newreport);
            }
            return(View(model));
        }
        private static void UseOAuthFlow()
        {
            OAuthFlow oauth = new OAuthFlowBuilder()
                              .SetClientId("1tziajulcsbqsswgy37")
                              .SetClientSecret("sxouqll7zluvzmact3")
                              .SetRedirectURL("https://www.google.com")
                              .Build();

            string url = oauth.NewAuthorizationURL
                         (
                new Smartsheet.Api.OAuth.AccessScope[]
            {
                Smartsheet.Api.OAuth.AccessScope.READ_SHEETS,
                Smartsheet.Api.OAuth.AccessScope.WRITE_SHEETS,
                Smartsheet.Api.OAuth.AccessScope.SHARE_SHEETS,
                Smartsheet.Api.OAuth.AccessScope.DELETE_SHEETS,
                Smartsheet.Api.OAuth.AccessScope.CREATE_SHEETS,
                Smartsheet.Api.OAuth.AccessScope.READ_USERS,
                Smartsheet.Api.OAuth.AccessScope.ADMIN_USERS,
                Smartsheet.Api.OAuth.AccessScope.ADMIN_SHEETS,
                Smartsheet.Api.OAuth.AccessScope.ADMIN_WORKSPACES,
            },
                "key=Test"
                         );


            // Take the user to the following URL
            Debug.WriteLine(url);

            // After the user accepts or declines the authorization they are taken to the redirect URL. The URL of the page
            // the user is taken to can be used to generate an authorization RequestResult object.
            string authorizationResponseURL = "https://www.google.com/?code=yn8kl1kvruh31uj&expires_in=599957&state=key%3DTest";

            // On this page pass in the full URL of the page to create an authorizationResult object
            AuthorizationResult authResult = oauth.ExtractAuthorizationResult(authorizationResponseURL);

            // Get the token from the authorization result
            Token token = oauth.ObtainNewToken(authResult);

            Assert.IsTrue(token.AccessToken == "ACCESS_TOKEN");

            Token tokenRefreshed = oauth.RefreshToken(token);

            Assert.IsTrue(token.AccessToken != "ACCESS_TOKEN");

            oauth.RevokeToken(token);
            SmartsheetClient smartsheet = new SmartsheetBuilder().SetAccessToken(token.AccessToken).Build();

            try
            {
                smartsheet.SheetResources.ListSheets(null, null);
                Assert.Fail();
            }
            catch
            {
            }
        }
Beispiel #16
0
        public void TestContactResources()
        {
            string accessToken = ConfigurationManager.AppSettings["accessToken"];

            SmartsheetClient smartsheet = new SmartsheetBuilder().SetAccessToken(accessToken).Build();

            PaginatedResult <Contact> contactResults = smartsheet.ContactResources.ListContacts(null);

            Assert.IsTrue(contactResults.TotalCount >= 0);
        }
Beispiel #17
0
        private static SmartsheetClient GetClient()
        {
            // Initialize client
            SmartsheetClient client = new SmartsheetBuilder()
                                      // TODO: Set your API access in environment variable SMARTSHEET_ACCESS_TOKEN or else here
                                      .SetAccessToken(ConfigurationManager.AppSettings["SmartsheetApiKey"])
                                      .Build();

            return(client);
        }
        public static SmartsheetClient SetupClient(string apiScenario)
        {
            SmartsheetClient ss = new SmartsheetBuilder()
                                  .SetBaseURI("http://localhost:8082/")
                                  .SetAccessToken("aaaaaaaaaaaaaaaaaaaaaaaaaa")
                                  .SetSDKAPITestScenario(apiScenario)
                                  .Build();

            return(ss);
        }
Beispiel #19
0
        public void TestHomeResources()
        {
            string accessToken = ConfigurationManager.AppSettings["accessToken"];

            SmartsheetClient smartsheet = new SmartsheetBuilder().SetAccessToken(accessToken).Build();

            Home home = smartsheet.HomeResources.GetHome(new HomeInclusion[] { HomeInclusion.SOURCE });

            Assert.IsTrue(home != null);
        }
        public void TestServerInfoResources()
        {
            SmartsheetClient smartsheet = new SmartsheetBuilder().SetMaxRetryTimeout(30000).Build();

            ServerInfo info = smartsheet.ServerInfoResources.GetServerInfo();

            Assert.IsTrue(info.FeatureInfo != null);
            Assert.IsTrue(info.Formats != null);
            Assert.IsTrue(info.SupportedLocales != null);
        }
Beispiel #21
0
        public static SmartsheetClient SetupClient(string apiScenario)
        {
            TestHttpClient   testHttpClient = new TestHttpClient(apiScenario);
            SmartsheetClient ss             = new SmartsheetBuilder()
                                              .SetBaseURI("http://localhost:8082/")
                                              .SetAccessToken("aaaaaaaaaaaaaaaaaaaaaaaaaa")
                                              .SetHttpClient(testHttpClient)
                                              .Build();

            return(ss);
        }
Beispiel #22
0
        public void TestServerInfoResources()
        {
            string accessToken = ConfigurationManager.AppSettings["accessToken"];

            SmartsheetClient smartsheet = new SmartsheetBuilder().SetAccessToken(accessToken).Build();

            ServerInfo info = smartsheet.ServerInfoResources.GetServerInfo();

            Assert.IsTrue(info.FeatureInfo != null);
            Assert.IsTrue(info.Formats != null);
            Assert.IsTrue(info.SupportedLocales != null);
        }
		public void TestColumnResources()
		{
			string accessToken = ConfigurationManager.AppSettings["accessToken"];

			SmartsheetClient smartsheet = new SmartsheetBuilder().SetAccessToken(accessToken).Build();
			long sheetId = CreateSheet(smartsheet);
			AddColumns(smartsheet, sheetId);

			long columnId = ListColumns(smartsheet, sheetId);
			UpdateColumn(smartsheet, sheetId, columnId);
			DeleteAndGetColumn(smartsheet, sheetId, columnId);
		}
        public void TestSheetResources()
        {
            SmartsheetClient smartsheet = new SmartsheetBuilder().SetMaxRetryTimeout(30000).Build();
            long             sheetId    = CreateSheet(smartsheet);

            SendSheet(smartsheet, sheetId);
            UpdateSheet(smartsheet, sheetId);
            UpdatePublishSheetStatus(smartsheet, sheetId);
            GetSheetAsPDF(smartsheet, sheetId);
            SortSheet(smartsheet, sheetId);
            DeleteSheet(smartsheet, sheetId);
        }
        public void TestFolderResources()
        {
            SmartsheetClient smartsheet = new SmartsheetBuilder().SetMaxRetryTimeout(30000).Build();

            long createdFolderInHomeId   = CreateFolderInHome(smartsheet);
            long createdFolderInFolderId = CreateFolderInFolder(smartsheet, createdFolderInHomeId);

            ListFoldersInFolder(smartsheet, createdFolderInHomeId, createdFolderInFolderId);
            UpdateFolderInFolder(smartsheet, createdFolderInFolderId);
            GetFolderInHome(smartsheet, createdFolderInHomeId, createdFolderInFolderId);
            DeleteFolders(smartsheet, createdFolderInHomeId, createdFolderInFolderId);
        }
Beispiel #26
0
        public void TestSheetResources()
        {
            string accessToken = ConfigurationManager.AppSettings["accessToken"];

            SmartsheetClient smartsheet = new SmartsheetBuilder().SetAccessToken(accessToken).Build();
            long             sheetId    = CreateSheet(smartsheet);

            SendSheet(smartsheet, sheetId);
            UpdateSheet(smartsheet, sheetId);
            UpdatePublishSheetStatus(smartsheet, sheetId);
            GetSheetAsPDF(smartsheet, sheetId);
            DeleteSheet(smartsheet, sheetId);
        }
Beispiel #27
0
        public void TestWorkspaceResources()
        {
            SmartsheetClient smartsheet = new SmartsheetBuilder().SetMaxRetryTimeout(30000).Build();

            long workspaceId = CreateWorkspace(smartsheet);

            UpdateWorkspace(smartsheet, workspaceId);

            GetWorkspace(smartsheet, workspaceId);

            ListWorkspaces(smartsheet, workspaceId);

            DeleteWorkspace(smartsheet, workspaceId);
        }
        public void TestColumnResources()
        {
            SmartsheetClient smartsheet = new SmartsheetBuilder().SetMaxRetryTimeout(30000).Build();
            long             sheetId    = CreateSheet(smartsheet);

            AddColumns(smartsheet, sheetId);

            long columnId = ListColumns(smartsheet, sheetId);

            UpdateColumn(smartsheet, sheetId, columnId);
            DeleteAndGetColumn(smartsheet, sheetId, columnId);

            smartsheet.SheetResources.DeleteSheet(sheetId);
        }
Beispiel #29
0
        static Dictionary <string, long> columnMap = new Dictionary <string, long>(); // Map from friendly column name to column Id

        static void Main(string[] args)
        {
            // Get API access token from App.config file or environment
            string accessToken = ConfigurationManager.AppSettings["AccessToken"];

            if (string.IsNullOrEmpty(accessToken))
            {
                accessToken = Environment.GetEnvironmentVariable("SMARTSHEET_ACCESS_TOKEN");
            }
            if (string.IsNullOrEmpty(accessToken))
            {
                throw new Exception("Must set API access token in App.conf file");
            }

            // Get sheet Id from App.config file
            string sheetIdString = ConfigurationManager.AppSettings["SheetId"];
            long   sheetId       = long.Parse(sheetIdString);

            // Initialize client
            SmartsheetClient ss = new SmartsheetBuilder().SetAccessToken(accessToken).Build();

            // Load the entire sheet
            Sheet sheet = ss.SheetResources.GetSheet(sheetId, null, null, null, null, null, null, null);

            Console.WriteLine("Loaded " + sheet.Rows.Count + " rows from sheet: " + sheet.Name);

            // Build column map for later reference
            foreach (Column column in sheet.Columns)
            {
                columnMap.Add(column.Title, (long)column.Id);
            }

            // Accumulate rows needing update here
            List <Row> rowsToUpdate = new List <Row>();

            foreach (Row row in sheet.Rows)
            {
                Row rowToUpdate = evaluateRowAndBuildUpdates(row);
                if (rowToUpdate != null)
                {
                    rowsToUpdate.Add(rowToUpdate);
                }
            }

            // Finally, write all updated cells back to Smartsheet
            Console.WriteLine("Writing " + rowsToUpdate.Count + " rows back to sheet id " + sheet.Id);
            ss.SheetResources.RowResources.UpdateRows(sheetId, rowsToUpdate);
            Console.WriteLine("Done (Hit enter)");
            Console.ReadLine();
        }
        public void TestFolderResources()
        {
            string accessToken = ConfigurationManager.AppSettings["accessToken"];

            SmartsheetClient smartsheet = new SmartsheetBuilder().SetAccessToken(accessToken).Build();

            long createdFolderInHomeId   = CreateFolderInHome(smartsheet);
            long createdFolderInFolderId = CreateFolderInFolder(smartsheet, createdFolderInHomeId);

            ListFoldersInFolder(smartsheet, createdFolderInHomeId, createdFolderInFolderId);
            UpdateFolderInFolder(smartsheet, createdFolderInFolderId);
            GetFolderInHome(smartsheet, createdFolderInHomeId, createdFolderInFolderId);
            DeleteFolders(smartsheet, createdFolderInHomeId, createdFolderInFolderId);
        }