ListColumns() public method

Gets a list of all Columns belonging to the Sheet specified in the URL.

It mirrors To the following Smartsheet REST API method: GET /sheets/{sheetId}/columns

This operation supports pagination of results. For more information, see Paging.
if any argument is null or empty string if there is any problem with the REST API request if there is any problem with the REST API authorization (access token) if the resource cannot be found if the REST API service is not available (possibly due To rate limiting) if there is any other error during the operation
public ListColumns ( long sheetId, IEnumerable include, PaginationParameters paging ) : PaginatedResult
sheetId long the sheet Id
include IEnumerable elements to include in response
paging Smartsheet.Api.Models.PaginationParameters the paging
return PaginatedResult
SheetColumnResourcesImpl Class Documentation
Example #1
0
        public virtual void TestListColumns()
        {
            server.setResponseBody("../../../TestSDK/resources/listColumns.json");

            IList <Column> columns = sheetColumnResourcesImpl.ListColumns(1234L);

            Assert.True(columns.Count == 1);
            Assert.AreEqual(columns[0].Title, "something new");
        }
Example #2
0
        public virtual void TestListColumns()
        {
            server.setResponseBody("../../../TestSDK/resources/listColumns.json");

            PaginatedResult <Column> result = sheetColumnResourcesImpl.ListColumns(1234L, new List <ColumnInclusion> {
                ColumnInclusion.FILTERS
            }, null);

            Assert.True(result.TotalCount == 9);
            Assert.AreEqual(result.Data[2].Title, "Start");
            Assert.IsTrue(result.Data[3].Filter != null);
            Assert.AreEqual(result.Data[3].Filter.Criteria[0].Operator, CriteriaOperator.GREATER_THAN);
            Assert.AreEqual(result.Data[3].Filter.Criteria[0].Value1, "2015-07-14");
            Assert.IsTrue(result.Data[7].Filter == null);
            Assert.AreEqual(result.Data[7].Options.Count, 5);
            Assert.AreEqual(result.Data[7].Options[3], "At Risk");
        }