Smartsheet API C# Filtering Rows by data in a column
up vote
0
down vote
favorite
I am new to API's and Smartsheet. I am looking to filter a specific set of records to display in a datagrid. I have got the connection and data coming in, but i only want to display records for that specific column selection.
ie: Column A = 200
I also need to know how to filter two columns in the same sheet. ie: column A = 200, Column C = "Fred"
I think i need to use the IEnumerable includes function but i can't find any examaples of doing this.
Any help would be appreciated.
c# api smartsheet-api
asked Nov 21 at 1:38
Andrew Little
64
add a comment |
up vote
0
down vote
favorite
I am new to API's and Smartsheet. I am looking to filter a specific set of records to display in a datagrid. I have got the connection and data coming in, but i only want to display records for that specific column selection.
ie: Column A = 200
I also need to know how to filter two columns in the same sheet. ie: column A = 200, Column C = "Fred"
I think i need to use the IEnumerable includes function but i can't find any examaples of doing this.
Any help would be appreciated.
c# api smartsheet-api
asked Nov 21 at 1:38
Andrew Little
64
possible duplicate: stackoverflow.com/questions/36988057/…
– JohnB
Nov 21 at 2:19
Yes its the same question but Smartsheet's help text is useless other than saying the below smartsheet-platform.github.io/api-docs/#row-include-flags Row Include Flags Include Flag Description columnType Includes columnType attribute in the row's cells indicating the type of the column the cell resides in. filters Includes filteredOut attribute indicating if the row should be displayed or hidden according to the sheet's filters. objectValue Includes objectValue attribute on cells containing values. For more information see Cell Reference.
– Andrew Little
Nov 21 at 4:06
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I am new to API's and Smartsheet. I am looking to filter a specific set of records to display in a datagrid. I have got the connection and data coming in, but i only want to display records for that specific column selection.
ie: Column A = 200
I also need to know how to filter two columns in the same sheet. ie: column A = 200, Column C = "Fred"
I think i need to use the IEnumerable includes function but i can't find any examaples of doing this.
Any help would be appreciated.
c# api smartsheet-api
asked Nov 21 at 1:38
Andrew Little
64
I am new to API's and Smartsheet. I am looking to filter a specific set of records to display in a datagrid. I have got the connection and data coming in, but i only want to display records for that specific column selection.
ie: Column A = 200
I also need to know how to filter two columns in the same sheet. ie: column A = 200, Column C = "Fred"
I think i need to use the IEnumerable includes function but i can't find any examaples of doing this.
Any help would be appreciated.
c# api smartsheet-api
c# api smartsheet-api
asked Nov 21 at 1:38
Andrew Little
64
asked Nov 21 at 1:38
Andrew Little
64
asked Nov 21 at 1:38
Andrew Little
64
asked Nov 21 at 1:38
Andrew Little
64
asked Nov 21 at 1:38
Andrew Little
64
64
possible duplicate: stackoverflow.com/questions/36988057/…
– JohnB
Nov 21 at 2:19
Yes its the same question but Smartsheet's help text is useless other than saying the below smartsheet-platform.github.io/api-docs/#row-include-flags Row Include Flags Include Flag Description columnType Includes columnType attribute in the row's cells indicating the type of the column the cell resides in. filters Includes filteredOut attribute indicating if the row should be displayed or hidden according to the sheet's filters. objectValue Includes objectValue attribute on cells containing values. For more information see Cell Reference.
– Andrew Little
Nov 21 at 4:06
add a comment |
possible duplicate: stackoverflow.com/questions/36988057/…
– JohnB
Nov 21 at 2:19
Yes its the same question but Smartsheet's help text is useless other than saying the below smartsheet-platform.github.io/api-docs/#row-include-flags Row Include Flags Include Flag Description columnType Includes columnType attribute in the row's cells indicating the type of the column the cell resides in. filters Includes filteredOut attribute indicating if the row should be displayed or hidden according to the sheet's filters. objectValue Includes objectValue attribute on cells containing values. For more information see Cell Reference.
– Andrew Little
Nov 21 at 4:06
possible duplicate: stackoverflow.com/questions/36988057/…
– JohnB
Nov 21 at 2:19
possible duplicate: stackoverflow.com/questions/36988057/…
– JohnB
Nov 21 at 2:19
Yes its the same question but Smartsheet's help text is useless other than saying the below smartsheet-platform.github.io/api-docs/#row-include-flags Row Include Flags Include Flag Description columnType Includes columnType attribute in the row's cells indicating the type of the column the cell resides in. filters Includes filteredOut attribute indicating if the row should be displayed or hidden according to the sheet's filters. objectValue Includes objectValue attribute on cells containing values. For more information see Cell Reference.
– Andrew Little
Nov 21 at 4:06
Yes its the same question but Smartsheet's help text is useless other than saying the below smartsheet-platform.github.io/api-docs/#row-include-flags Row Include Flags Include Flag Description columnType Includes columnType attribute in the row's cells indicating the type of the column the cell resides in. filters Includes filteredOut attribute indicating if the row should be displayed or hidden according to the sheet's filters. objectValue Includes objectValue attribute on cells containing values. For more information see Cell Reference.
– Andrew Little
Nov 21 at 4:06
add a comment |
1 Answer
1
active
oldest
votes
up vote
1
down vote
The include=filters query string parameter reveals the filteredOut field on the row object. This field is a boolean value based on the filters that are applied in the Smartsheet UI.
For instance, if you create a filter in the Smartsheet UI on Column A to only show values equal to 200, your sheet would reflect that filter in the UI. Then, when you get that sheet through the API with include=filters set in your query string, the rows that have Column A = 200 (and are visible in the UI) will have the value "filteredOut": false in the API response.
The parameter doesn't actually filter the rows out of the API response. You'll have to have logic in your code that does the filtering.
answered Nov 21 at 19:34
stmcallister
1,3281815
I am not looking to do that as it defeats the purpose. I am looking to runtime filter records by passing variables in the C# application/Smartsheet API My question is examples of how this is done as Smartsheets help is very light on
– Andrew Little
Nov 21 at 20:04
Andrew, that functionality is not documented because what you're trying to do is not possible with the Smartsheet API. Applying a filter to your data can only be done through the Smartsheet UI. By passing the query parameter that Scott mentioned, the Smartsheet API will return another property on each row that indicates whether a specific row has been filtered out. In order to parse the response and grab the data that you care about, you will always need to write your own custom logic. Using the query parameter just makes it easier to distinguish between which rows you want.
– Taylor Krusen
Nov 21 at 21:42
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
1
down vote
The include=filters query string parameter reveals the filteredOut field on the row object. This field is a boolean value based on the filters that are applied in the Smartsheet UI.
For instance, if you create a filter in the Smartsheet UI on Column A to only show values equal to 200, your sheet would reflect that filter in the UI. Then, when you get that sheet through the API with include=filters set in your query string, the rows that have Column A = 200 (and are visible in the UI) will have the value "filteredOut": false in the API response.
The parameter doesn't actually filter the rows out of the API response. You'll have to have logic in your code that does the filtering.
answered Nov 21 at 19:34
stmcallister
1,3281815
I am not looking to do that as it defeats the purpose. I am looking to runtime filter records by passing variables in the C# application/Smartsheet API My question is examples of how this is done as Smartsheets help is very light on
– Andrew Little
Nov 21 at 20:04
Andrew, that functionality is not documented because what you're trying to do is not possible with the Smartsheet API. Applying a filter to your data can only be done through the Smartsheet UI. By passing the query parameter that Scott mentioned, the Smartsheet API will return another property on each row that indicates whether a specific row has been filtered out. In order to parse the response and grab the data that you care about, you will always need to write your own custom logic. Using the query parameter just makes it easier to distinguish between which rows you want.
– Taylor Krusen
Nov 21 at 21:42
add a comment |
up vote
1
down vote
The include=filters query string parameter reveals the filteredOut field on the row object. This field is a boolean value based on the filters that are applied in the Smartsheet UI.
For instance, if you create a filter in the Smartsheet UI on Column A to only show values equal to 200, your sheet would reflect that filter in the UI. Then, when you get that sheet through the API with include=filters set in your query string, the rows that have Column A = 200 (and are visible in the UI) will have the value "filteredOut": false in the API response.
The parameter doesn't actually filter the rows out of the API response. You'll have to have logic in your code that does the filtering.
answered Nov 21 at 19:34
stmcallister
1,3281815
I am not looking to do that as it defeats the purpose. I am looking to runtime filter records by passing variables in the C# application/Smartsheet API My question is examples of how this is done as Smartsheets help is very light on
– Andrew Little
Nov 21 at 20:04
Andrew, that functionality is not documented because what you're trying to do is not possible with the Smartsheet API. Applying a filter to your data can only be done through the Smartsheet UI. By passing the query parameter that Scott mentioned, the Smartsheet API will return another property on each row that indicates whether a specific row has been filtered out. In order to parse the response and grab the data that you care about, you will always need to write your own custom logic. Using the query parameter just makes it easier to distinguish between which rows you want.
– Taylor Krusen
Nov 21 at 21:42
add a comment |
up vote
1
down vote
up vote
1
down vote
The include=filters query string parameter reveals the filteredOut field on the row object. This field is a boolean value based on the filters that are applied in the Smartsheet UI.
For instance, if you create a filter in the Smartsheet UI on Column A to only show values equal to 200, your sheet would reflect that filter in the UI. Then, when you get that sheet through the API with include=filters set in your query string, the rows that have Column A = 200 (and are visible in the UI) will have the value "filteredOut": false in the API response.
The parameter doesn't actually filter the rows out of the API response. You'll have to have logic in your code that does the filtering.
answered Nov 21 at 19:34
stmcallister
1,3281815
The include=filters query string parameter reveals the filteredOut field on the row object. This field is a boolean value based on the filters that are applied in the Smartsheet UI.
For instance, if you create a filter in the Smartsheet UI on Column A to only show values equal to 200, your sheet would reflect that filter in the UI. Then, when you get that sheet through the API with include=filters set in your query string, the rows that have Column A = 200 (and are visible in the UI) will have the value "filteredOut": false in the API response.
The parameter doesn't actually filter the rows out of the API response. You'll have to have logic in your code that does the filtering.
answered Nov 21 at 19:34
stmcallister
1,3281815
answered Nov 21 at 19:34
stmcallister
1,3281815
answered Nov 21 at 19:34
stmcallister
1,3281815
answered Nov 21 at 19:34
stmcallister
1,3281815
1,3281815
I am not looking to do that as it defeats the purpose. I am looking to runtime filter records by passing variables in the C# application/Smartsheet API My question is examples of how this is done as Smartsheets help is very light on
– Andrew Little
Nov 21 at 20:04
Andrew, that functionality is not documented because what you're trying to do is not possible with the Smartsheet API. Applying a filter to your data can only be done through the Smartsheet UI. By passing the query parameter that Scott mentioned, the Smartsheet API will return another property on each row that indicates whether a specific row has been filtered out. In order to parse the response and grab the data that you care about, you will always need to write your own custom logic. Using the query parameter just makes it easier to distinguish between which rows you want.
– Taylor Krusen
Nov 21 at 21:42
add a comment |
I am not looking to do that as it defeats the purpose. I am looking to runtime filter records by passing variables in the C# application/Smartsheet API My question is examples of how this is done as Smartsheets help is very light on
– Andrew Little
Nov 21 at 20:04
Andrew, that functionality is not documented because what you're trying to do is not possible with the Smartsheet API. Applying a filter to your data can only be done through the Smartsheet UI. By passing the query parameter that Scott mentioned, the Smartsheet API will return another property on each row that indicates whether a specific row has been filtered out. In order to parse the response and grab the data that you care about, you will always need to write your own custom logic. Using the query parameter just makes it easier to distinguish between which rows you want.
– Taylor Krusen
Nov 21 at 21:42
I am not looking to do that as it defeats the purpose. I am looking to runtime filter records by passing variables in the C# application/Smartsheet API My question is examples of how this is done as Smartsheets help is very light on
– Andrew Little
Nov 21 at 20:04
I am not looking to do that as it defeats the purpose. I am looking to runtime filter records by passing variables in the C# application/Smartsheet API My question is examples of how this is done as Smartsheets help is very light on
– Andrew Little
Nov 21 at 20:04
Andrew, that functionality is not documented because what you're trying to do is not possible with the Smartsheet API. Applying a filter to your data can only be done through the Smartsheet UI. By passing the query parameter that Scott mentioned, the Smartsheet API will return another property on each row that indicates whether a specific row has been filtered out. In order to parse the response and grab the data that you care about, you will always need to write your own custom logic. Using the query parameter just makes it easier to distinguish between which rows you want.
– Taylor Krusen
Nov 21 at 21:42
Andrew, that functionality is not documented because what you're trying to do is not possible with the Smartsheet API. Applying a filter to your data can only be done through the Smartsheet UI. By passing the query parameter that Scott mentioned, the Smartsheet API will return another property on each row that indicates whether a specific row has been filtered out. In order to parse the response and grab the data that you care about, you will always need to write your own custom logic. Using the query parameter just makes it easier to distinguish between which rows you want.
– Taylor Krusen
Nov 21 at 21:42
add a comment |
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53404137%2fsmartsheet-api-c-sharp-filtering-rows-by-data-in-a-column%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
possible duplicate: stackoverflow.com/questions/36988057/…
– JohnB
Nov 21 at 2:19
Yes its the same question but Smartsheet's help text is useless other than saying the below smartsheet-platform.github.io/api-docs/#row-include-flags Row Include Flags Include Flag Description columnType Includes columnType attribute in the row's cells indicating the type of the column the cell resides in. filters Includes filteredOut attribute indicating if the row should be displayed or hidden according to the sheet's filters. objectValue Includes objectValue attribute on cells containing values. For more information see Cell Reference.
– Andrew Little
Nov 21 at 4:06