Smartsheet API C# Filtering Rows by data in a column
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 '18 at 1:38
Andrew LittleAndrew Little
95
add a comment |
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 '18 at 1:38
Andrew LittleAndrew Little
95
possible duplicate: stackoverflow.com/questions/36988057/…
– JohnB
Nov 21 '18 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 '18 at 4:06
add a comment |
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 '18 at 1:38
Andrew LittleAndrew Little
95
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 '18 at 1:38
Andrew LittleAndrew Little
95
asked Nov 21 '18 at 1:38
Andrew LittleAndrew Little
95
asked Nov 21 '18 at 1:38
Andrew LittleAndrew Little
95
asked Nov 21 '18 at 1:38
Andrew LittleAndrew Little
95
asked Nov 21 '18 at 1:38
Andrew LittleAndrew Little
95
95
possible duplicate: stackoverflow.com/questions/36988057/…
– JohnB
Nov 21 '18 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 '18 at 4:06
add a comment |
possible duplicate: stackoverflow.com/questions/36988057/…
– JohnB
Nov 21 '18 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 '18 at 4:06
possible duplicate: stackoverflow.com/questions/36988057/…
– JohnB
Nov 21 '18 at 2:19
possible duplicate: stackoverflow.com/questions/36988057/…
– JohnB
Nov 21 '18 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 '18 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 '18 at 4:06
add a comment |
1 Answer
1
active
oldest
votes
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 '18 at 19:34
stmcallisterstmcallister
1,3871815
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 '18 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 '18 at 21:42
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
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
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
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 '18 at 19:34
stmcallisterstmcallister
1,3871815
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 '18 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 '18 at 21:42
add a comment |
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 '18 at 19:34
stmcallisterstmcallister
1,3871815
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 '18 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 '18 at 21:42
add a comment |
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 '18 at 19:34
stmcallisterstmcallister
1,3871815
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 '18 at 19:34
stmcallisterstmcallister
1,3871815
answered Nov 21 '18 at 19:34
stmcallisterstmcallister
1,3871815
answered Nov 21 '18 at 19:34
stmcallisterstmcallister
1,3871815
answered Nov 21 '18 at 19:34
stmcallisterstmcallister
1,3871815
1,3871815
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 '18 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 '18 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 '18 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 '18 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 '18 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 '18 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 '18 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 '18 at 21:42
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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 '18 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 '18 at 4:06