REST API Results list examples

Examples of the parameters for the results_list REST API

Question type	Operator	Examples
Pick one or other (only pick one part)	IN	Get responses where for question Q1 answers A1 or A2 selected: { "items":[ { "operator":"IN", "sourceItemKey":"Q8376240", "operand":{ "selected":[ "Q8376240.A36449728", "Q8376240.A36449729" ] } } ] }
Pick one or other (only pick one part)	NOT_IN	Get responses where for question Q1 answers A1 or A2 not selected: { "items":[ { "operator":"NOT_IN", "sourceItemKey":"Q8376240", "operand":{ "selected":[ "Q8376240.A36449728", "Q8376240.A36449729" ] } } ] }
Pick one with comment (only pick one part)	IN	Get responses where for question Q1 answers A1 or A2 selected: { "items":[ { "operator":"IN", "sourceItemKey":"Q8376240", "operand":{ "selected":[ "Q8376240.A36449728", "Q8376240.A36449729" ] } } ] }
Pick one with comment (only pick one part)	NOT_IN	Get responses where for question Q1 answers A1 or A2 not selected: { "items":[ { "operator":"NOT_IN", "sourceItemKey":"Q8376240", "operand":{ "selected":[ "Q8376240.A36449728", "Q8376240.A36449729" ] } } ] }
Check all that apply (only check all part)	IN	Get responses where for question Q1 answers A1 or A2 selected: { "items":[ { "operator":"IN", "sourceItemKey":"Q8376240", "operand":{ "selected":[ "Q8376240.A36449728", "Q8376240.A36449729" ] } } ] }
Check all that apply (only check all part)	NOT_IN	Get responses where for question Q1 answers A1 or A2 not selected: { "items":[ { "operator":"NOT_IN", "sourceItemKey":"Q8376240", "operand":{ "selected":[ "Q8376240.A36449728", "Q8376240.A36449729" ] } } ] }
Dropdown box	IN	Get responses where for question Q1 answers A1 or A2 selected: { "items":[ { "operator":"IN", "sourceItemKey":"Q8376240", "operand":{ "selected":[ "Q8376240.A36449728", "Q8376240.A36449729" ] } } ] }
Dropdown box	NOT_IN	Get responses where for question Q1 answers A1 or A2 not selected: { "items":[ { "operator":"NOT_IN", "sourceItemKey":"Q8376240", "operand":{ "selected":[ "Q8376240.A36449728", "Q8376240.A36449729" ] } } ] }
List box	IN	Get responses where for question Q1 answers A1 or A2 selected: { "items":[ { "operator":"IN", "sourceItemKey":"Q8376240", "operand":{ "selected":[ "Q8376240.A36449728", "Q8376240.A36449729" ] } } ] }
List box	NOT_IN	Get responses where for question Q1 answers A1 or A2 not selected: { "items":[ { "operator":"NOT_IN", "sourceItemKey":"Q8376240", "operand":{ "selected":[ "Q8376240.A36449728", "Q8376240.A36449729" ] } } ] }
Single Line	EQUAL	Get responses where Q1.A1 (general format) has value "qwe" { "items": [ { "sourceItemKey": "Q8370850.A36431975", "operator":"EQUAL", "operand":{ "value":"qwe" } } ] }
Single Line	EQUAL	Get responses where Q1.A1 (numeric format) has value "5" { "items": [ { "sourceItemKey": "Q8370850.A36431975", "operator":"EQUAL", "operand":{ "value":"5" } } ] }
Single Line	EQUAL	Get responses where Q1.A1 (date format)has value "01/02/2022" { "items": [ { "sourceItemKey": "Q8370850.A36431975", "operator":"EQUAL", "operand":{ "value":"01/02/2022" } } ] }
Single Line	NOT_EQUAL	Get responses where Q8370850.A36431975 (general format) does not have value "qwe" { "items": [ { "sourceItemKey": "Q8370850.A36431975", "operator":"NOT_EQUAL", "operand":{ "value":"qwe" } } ] }
Single Line	NOT_EQUAL	Get responses where Q1.A1 (numeric format) does not have value "5" { "items": [ { "sourceItemKey": "Q8370850.A36431975", "operator":"NOT_EQUAL", "operand":{ "value":"5" } } ] }
Single Line	NOT_EQUAL	Get responses where Q1.A1 (date format) does not have value "01/02/2022" { "items": [ { "sourceItemKey": "Q8370850.A36431975", "operator":"NOT_EQUAL", "operand":{ "value":"01/02/2022" } } ] }
Single Line	CONTAINS	Get responses where Q1.A1 (general format) contains value "qwe" { "items": [ { "sourceItemKey": "Q8370850.A36431975", "operator":"CONTAINS", "operand":{ "value":"qwe" } } ] }
Single Line	DOES_NOT_CONTAIN	Get responses where Q1.A1 (general format) does not contain value "qwe" { "items": [ { "sourceItemKey": "Q8370850.A36431975", "operator":"DOES_NOT_CONTAIN", "operand":{ "value":"qwe" } } ] }
Single Line	IN	Get all responses where Q2.A2 (general format) has one of the value in the list ("qwe", "abc") { "items":[ { "sourceItemKey":"Q8370850.A36431975", "operator":"IN", "operand":{ "selected":[ "qwe", "abc" ] } } ] }
Single Line	IN	Get all responses where Q2.A2 (numeric format) has one of the value in the list (42, 43) { "items":[ { "sourceItemKey":"Q8370850.A36431976", "operator":"IN", "operand":{ "selected":[ "42", "43" ] } } ] }
Single Line	IN	Get all responses where Q2.A2 (date format) has one of the value in the list (03-09-2022, 11-11-2022) { "items":[ { "sourceItemKey":"Q8370850.A36431976", "operator":"IN", "operand":{ "selected":[ "03-09-2022", "11-11-2022" ] } } ] }
Single Line	NOT_IN	Get all responses where Q2.A2 (general format) does not have one of the value in the list ("qwe", "abc") { "items":[ { "sourceItemKey":"Q8370850.A36431975", "operator":"NOT_IN", "operand":{ "selected":[ "qwe", "abc" ] } } ] }
Single Line	NOT_IN	Get all responses where Q2.A2 (numeric format) does not have one of the value in the list (42, 43) { "items":[ { "sourceItemKey":"Q8370850.A36431976", "operator":"NOT_IN", "operand":{ "selected":[ "42", "43" ] } } ] }
Single Line	NOT_IN	Get all responses where Q2.A2 (date format) does not have one of the value in the list (03-09-2022, 11-11-2022) { "items":[ { "sourceItemKey":"Q8370850.A36431976", "operator":"NOT_IN", "operand":{ "selected":[ "03-09-2022", "11-11-2022" ] } } ] }
Single Line	BETWEEN	Get responses where Q1.A1 (numeric format) has values between 15 and 30: { "items": [ { "sourceItemKey": "Q8370850.A36431976", "operator":"BETWEEN", "operand":{ "from":"15", "to": "30" } } ] }
Single Line	BETWEEN	Get responses where Q1.A1 (date format) has values between 15-02-2021 and 30-07-2022: { "items": [ { "sourceItemKey": "Q8370850.A36431976", "operator":"BETWEEN", "operand":{ "from":"15-02-2021", "to": "30-07-2022" } } ] }
Single Line	NOT_BETWEEN	Get responses where Q1.A1 (numeric format) has values before 15 and after 30: { "items": [ { "sourceItemKey": "Q8370850.A36431976", "operator":"NOT_BETWEEN", "operand":{ "from":"15", "to": "30" } } ] }
Single Line	NOT_BETWEEN	Get responses where Q1.A1 (date format) has values before 15-02-2021 and after 30-07-2022: { "items": [ { "sourceItemKey": "Q8370850.A36431976", "operator":"NOT_BETWEEN", "operand":{ "from":"15-02-2021", "to": "30-07-2022" } } ] }
Single Line	GREATER_THAN_OR_EQUAL	Get responses where Q1.A1 (numeric format) value >= "67" { "items": [ { "sourceItemKey": "Q8370850.A36431976", "operator":"GREATER_THAN_OR_EQUAL", "operand": { "value":"67" } } ] }
Single Line	GREATER_THAN_OR_EQUAL	Get responses where Q1.A1 (date format MM/dd/yyyy) value >= "11/18/2022" { "items": [ { "sourceItemKey": "Q8370850.A36431977", "operator":"GREATER_THAN_OR_EQUAL", "operand":{ "value":"11/18/2022" } } ] }
Single Line	LESS_THAN_OR_EQUAL	Get responses where Q1.A1 (numeric format) value <= "35" { "items": [ { "sourceItemKey": "Q8370850.A36431976", "operator":"LESS_THAN_OR_EQUAL", "operand":{ "value":"35" } } ] }
Single Line	LESS_THAN_OR_EQUAL	Get responses where Q1.A1 (date format MM/dd/yyyy) value <= "11/18/2022" { "items": [ { "sourceItemKey": "Q8370850.A36431977", "operator":"LESS_THAN_OR_EQUAL", "operand":{ "value":"11/18/2022" } } ] }
Single Line	GREATER_THAN	Get responses where Q1.A1 (numeric format) value > "59" { "items": [ { "sourceItemKey": "Q8370850.A36431976", "operator":"GREATER_THAN", "operand":{ "value":"59" } } ] }
Single Line	GREATER_THAN	Get responses where Q1.A1 (date format MM/dd/yyyy) value > "11/18/2022" { "items": [ { "sourceItemKey": "Q8370850.A36431977", "operator":"GREATER_THAN", "operand":{ "value":"11/18/2022" } } ] }
Single Line	LESS_THAN	Get responses where Q1.A1 (numeric format) value < "54" { "items": [ { "sourceItemKey": "Q8370850.A36431976", "operator":"LESS_THAN", "operand":{ "value":"54" } } ] }
Single Line	LESS_THAN	Get responses where Q1.A1 (date format MM/dd/yyyy) value < "11/18/2022" { "items": [ { "sourceItemKey": "Q8370850.A36431977", "operator":"LESS_THAN", "operand":{ "value":"11/18/2022" } } ] }
Numeric Allocation	EQUAL	Get responses where Q1.A1has value "123" { "items": [ { "sourceItemKey": "Q8370850.A36431975", "operator":"EQUAL", "operand":{ "value":"123" } } ] }
Numeric Allocation	NOT_EQUAL	Get responses where Q8370850.A36431975 does not have value "345" { "items": [ { "sourceItemKey": "Q8370850.A36431975", "operator":"NOT_EQUAL", "operand":{ "value":"345" } } ] }
Numeric Allocation	IN	Get all responses where Q2.A2 has one of the value in the list (42, 43) { "items":[ { "sourceItemKey":"Q8370850.A36431976", "operator":"IN", "operand":{ "selected":[ "42", "43" ] } } ] }
Numeric Allocation	NOT_IN	Get all responses where Q2.A2 does not have one of the value in the list (42, 43) { "items":[ { "sourceItemKey":"Q8370850.A36431976", "operator":"NOT_IN", "operand":{ "selected":[ "42", "43" ] } } ] }
Numeric Allocation	BETWEEN	Get responses where Q1.A1 has values between 15 and 30: { "items": [ { "sourceItemKey": "Q8370850.A36431976", "operator":"BETWEEN", "operand":{ "from":"15", "to": "30" } } ] }
Numeric Allocation	NOT_BETWEEN	Get responses where Q1.A1 has values before 15 and after 30: { "items": [ { "sourceItemKey": "Q8370850.A36431976", "operator":"NOT_BETWEEN", "operand":{ "from":"15", "to": "30" } } ] }
Numeric Allocation	GREATER_THAN_OR_EQUAL	Get responses where Q1.A1 value >= "67" { "items": [ { "sourceItemKey": "Q8370850.A36431977", "operator":"GREATER_THAN_OR_EQUAL", "operand": { "value":"67" } } ] }
Numeric Allocation	LESS_THAN_OR_EQUAL	Get responses where Q1.A1 value <= "35" { "items": [ { "sourceItemKey": "Q8370850.A36431977", "operator":"LESS_THAN_OR_EQUAL", "operand": { "value":"35" } } ] }
Numeric Allocation	GREATER_THAN	Get responses where Q1.A1 value > "59" { "items": [ { "sourceItemKey": "Q8370850.A36431977", "operator":"GREATER_THAN", "operand":{ "value":"59" } } ] }
Numeric Allocation	LESS_THAN	Get responses where Q1.A1 value < "54" { "items": [ { "sourceItemKey": "Q8370850.A36431977", "operator":"LESS_THAN", "operand":{ "value":"54" } } ] }
Multi Line	EQUAL	Get responses where Q1.A1 (general format) has value "qwe" { "items": [ { "sourceItemKey": "Q8370850", "operator":"EQUAL", "operand":{ "value":"qwe" } } ] }
Multi Line	NOT_EQUAL	Get responses where Q8370850.A36431975 does not have value "qwe" { "items": [ { "sourceItemKey": "Q8370850", "operator":"NOT_EQUAL", "operand":{ "value":"qwe" } } ] }
Multi Line	CONTAINS	Get responses where Q1 value contains "qwe" { "items": [ { "sourceItemKey": "Q8370863", "operator":"CONTAINS", "operand":{ "value":"qwe" } } ] }
Multi Line	DOES_NOT_CONTAIN	Get responses where Q1 value does not contain "qwe" { "items": [ { "sourceItemKey": "Q8370863", "operator":"DOES_NOT_CONTAIN", "operand":{ "value":"qwe" } } ] }
Multi Line	IN	Get all responses where Q1 has one of the value in the list (text1, text2) { "items":[ { "sourceItemKey":"Q8370850", "operator":"IN", "operand":{ "selected":[ "text1", "text2" ] } } ] }
Multi Line	NOT_IN	Get all responses where Q1 does not have one of the value in the list (text1, text2) { "items":[ { "sourceItemKey":"Q8370850", "operator":"NOT_IN", "operand":{ "selected":[ "text1", "text2" ] } } ] }
File Upload	EQUAL	Get responses where Q1.A1 has value "IMG1231241.PNG" { "items": [ { "sourceItemKey": "Q8370850.A36431975", "operator":"EQUAL", "operand":{ "value":"IMG1231241.PNG" } } ] }
File Upload	NOT_EQUAL	Get responses where Q1.A1 does not have value "IMG1231241.PNG" { "items": [ { "sourceItemKey": "Q8370850.A36431975", "operator":"NOT_EQUAL", "operand":{ "value":"IMG1231241.PNG" } } ] }
File Upload	CONTAINS	Get responses where Q1.A1 contains value ".xls" { "items": [ { "sourceItemKey": "Q8370850.A36431975", "operator":"CONTAINS", "operand":{ "value":".xls" } } ] }
File Upload	DOES_NOT_CONTAIN	Get responses where Q1.A1 does not contain value ".doc" { "items": [ { "sourceItemKey": "Q8370850.A36431975", "operator":"DOES_NOT_CONTAIN", "operand":{ "value":".doc" } } ] }
File Upload	IN	Get all responses where Q2.A2 has one of the value in the list (image1.png, image2.png) { "items":[ { "sourceItemKey":"Q8370850.A36431976", "operator":"IN", "operand":{ "selected":[ "image1.png", "image2.png" ] } } ] }
File Upload	NOT_IN	Get all responses where Q2.A2 does not have one of the value in the list (image1.png, image2.png) { "items":[ { "sourceItemKey":"Q8370850.A36431976", "operator":"NOT_IN", "operand":{ "selected":[ "image1.png", "image2.png" ] } } ] }
Rate Different	IN	Get responses where for answer A1 columns C1, C3, or C4 selected: { "items":[ { "operator":"IN", "sourceItemKey":"Q8376240.A36449729", "operand":{ "selected":[ "Q8376240.A36449729.C304786", "Q8376240.A36449729.C304789", "Q8376240.A36449729.C304792" ] } } ] }
Rate Different	IN	Get responses where answer A1 is voted (any column selected): { "items":[ { "operator":"IN", "sourceItemKey":"Q8376240.A", "operand":{ "selected":[ "Q8376240.A36449729" ] } } ] }
Rate Different	IN	Get responses where columns C1 or C3 voted (any answer selected) { "items":[ { "operator":"IN", "sourceItemKey":"Q8376240.C", "operand":{ "selected":[ "Q8376240.C304786", "Q8376240.C304789" ] } } ] }
Rate Different	NOT_IN	Get responses where for answer A1 columns C1, C3, or C4 not selected: { "items":[ { "operator":"NOT_IN", "sourceItemKey":"Q8376240.A36449729", "operand":{ "selected":[ "Q8376240.A36449729.C304786", "Q8376240.A36449729.C304789", "Q8376240.A36449729.C304792" ] } } ] }
Rate Different	NOT_IN	Get responses where answer A1 is not voted (any column not selected): { "items":[ { "operator":"NOT_IN", "sourceItemKey":"Q8376240.A", "operand":{ "selected":[ "Q8376240.A36449729" ] } } ] }
Rate Different	NOT_IN	Get responses where columns C1 or C3 not voted (any answer not selected) { "items":[ { "operator":"NOT_IN", "sourceItemKey":"Q8376240.C", "operand":{ "selected":[ "Q8376240.C304786", "Q8376240.C304789" ] } } ] }
3D Matrix	IN	Get responses where for answer A1 columns C1, C2 have some value { "items":[ { "operator":"IN", "sourceItemKey":"Q8376248.A36449754", "operand":{ "selected":[ "Q8376248.A36449754.C827055", "Q8376248.A36449754.C827056" ] } } ] }
3D Matrix	NOT_IN	Get responses where for answer A1 columns C1, C2 not have some value { "items":[ { "operator":"NOT_IN", "sourceItemKey":"Q8376248.A36449754", "operand":{ "selected":[ "Q8376248.A36449754.C827055", "Q8376248.A36449754.C827056" ] } } ] }
3D Matrix	IN	Get responses where answers A1, A3 have some value (in any column) { "items":[ { "operator":"IN", "sourceItemKey":"Q8376248.A", "operand":{ "selected":[ "Q8376248.A36449754", "Q8376248.A36449756" ] } } ] }
3D Matrix	NOT_IN	Get responses where answers A1, A3 no have some value (in any column) { "items":[ { "operator":"NOT_IN", "sourceItemKey":"Q8376248.A", "operand":{ "selected":[ "Q8376248.A36449754", "Q8376248.A36449756" ] } } ] }
3D Matrix	IN	Get responses where columns C1, C2 have some value (any answer) { "items":[ { "operator":"IN", "sourceItemKey":"Q8376248.C", "operand":{ "selected":[ "Q8376248.C827055", "Q8376248.C827056" ] } } ] }
3D Matrix	NOT_IN	Get responses where columns C1, C2 have some value (any answer) { "items":[ { "operator":"NOT_IN", "sourceItemKey":"Q8376248.C", "operand":{ "selected":[ "Q8376248.C827055", "Q8376248.C827056" ] } } ] }
3D Matrix	IN	With Dropdown type of column: Get responses where dropdown options #1 or #2 selected for A1.C3 { "items":[ { "operator":"IN", "sourceItemKey":"Q8376248.A36449754.C827057", "operand":{ "selected":[ "Q8376248.A36449754.C827057.O0", "Q8376248.A36449754.C827057.O1" ] } } ] }
3D Matrix	NOT_IN	With Dropdown type of column: Get responses where dropdown options #1 or #2 not selected for A1.C3 { "items":[ { "operator":"NOT_IN", "sourceItemKey":"Q8376248.A36449754.C827057", "operand":{ "selected":[ "Q8376248.A36449754.C827057.O0", "Q8376248.A36449754.C827057.O1" ] } } ] }
3D Matrix	EQUAL	Get responses where value in A1.C1 is equal to "qwe" (Column is formatted as text) { "items":[ { "operator":"EQUAL", "sourceItemKey":"Q8370888.A36432057.C826503", "operand":{ "value":"qwe" } } ] }
3D Matrix	EQUAL	Get responses where value in A1.C2 is equal to "15" (Column is formatted as numeric) { "items":[ { "operator":"EQUAL", "sourceItemKey":"Q8370888.A36432057.C826504", "operand":{ "value":"15" } } ] }
3D Matrix	EQUAL	Get responses where value in A1.C3 is equal to "10-15-2022" (Column is formatted as date MM-dd-yyyy) { "items":[ { "operator":"EQUAL", "sourceItemKey":"Q8370888.A36432057.C826505", "operand":{ "value":"10-15-2022" } } ] }
3D Matrix	NOT_EQUAL	Get responses where value in A1.C1 is not equal to "qwe" (Column is formatted as text) { "items":[ { "operator":"NOT_EQUAL", "sourceItemKey":"Q8370888.A36432057.C826503", "operand":{ "value":"qwe" } } ] }
3D Matrix	NOT_EQUAL	Get responses where value in A1.C2 is not equal to "15" (Column is formatted as numeric) { "items":[ { "operator":"NOT_EQUAL", "sourceItemKey":"Q8370888.A36432057.C826504", "operand":{ "value":"15" } } ] }
3D Matrix	NOT_EQUAL	Get responses where value in A1.C3 is not equal to "10-15-2022" (Column is formatted as date MM-dd-yyyy) { "items":[ { "operator":"NOT_EQUAL", "sourceItemKey":"Q8370888.A36432057.C826505", "operand":{ "value":"10-15-2022" } } ] }
3D Matrix	CONTAINS	Get responses where value in A1.C1 contains substring "qwe" (Column formatted as text) { "items":[ { "operator":"CONTAINS", "sourceItemKey":"Q8370888.A36432057.C826503", "operand":{ "value":"qwe" } } ] }
3D Matrix	DOES_NOT_CONTAIN	Get responses where value in A1.C1 does not contain substring "qwe" (Column formatted as text) { "items":[ { "operator":"DOES_NOT_CONTAIN", "sourceItemKey":"Q8370888.A36432057.C826503", "operand":{ "value":"qwe" } } ] }
3D Matrix	IN	Get responses where value in A1.C1 is one of in list ["qwe","rty"] (Column formatted as text) { "items":[ { "operator":"IN", "sourceItemKey":"Q8370888.A36432057.C826503", "operand":{ "selected": ["qwe","rty"] } } ] }
3D Matrix	IN	Get responses where value in A1.C2 is one of in list ["42","43"] (Column formatted as numeric) { "items":[ { "operator":"IN", "sourceItemKey":"Q8370888.A36432057.C826504", "operand":{ "selected": ["42","43"] } } ] }
3D Matrix	IN	Get responses where value in A1.C3 is one of in list ["03-09-2022", "11-11-2022"] (Column formatted as date) { "items":[ { "operator":"IN", "sourceItemKey":"Q8370888.A36432057.C826505", "operand":{ "selected": ["03-09-2022", "11-11-2022"] } } ] }
3D Matrix	NOT_IN	Get responses where value in A1.C1 does not in ["qwe","rty"] (Column formatted as text, numeric and date) { "items":[ { "operator":"NOT_IN", "sourceItemKey":"Q8370888.A36432057.C826503", "operand":{ "selected": ["qwe","rty"] } } ] }
3D Matrix	NOT_IN	Get responses where value in A1.C2 is not in list ["42","43"] (Column formatted as numeric) { "items":[ { "operator":"NOT_IN", "sourceItemKey":"Q8370888.A36432057.C826504", "operand":{ "selected": ["42","43"] } } ] }
3D Matrix	NOT_IN	Get responses where value in A1.C3 is not in list ["03-09-2022", "11-11-2022"] (Column formatted as date) { "items":[ { "operator":"NOT_IN", "sourceItemKey":"Q8370888.A36432057.C826505", "operand":{ "selected": ["03-09-2022", "11-11-2022"] } } ] }
3D Matrix	GREATER_THAN	Get responses where value in A1.C2 is greater than 42 (C2 is formatted as number) { "items":[ { "operator":"GREATER_THAN", "sourceItemKey":"Q8370888.A36432057.C826504", "operand":{ "value":"42" } } ] }
3D Matrix	GREATER_THAN	Get responses where value in A1.C2 is greater than "10/25/2021" (C2 is formatted as date MM/dd/yyyy) { "items":[ { "operator":"GREATER_THAN", "sourceItemKey":"Q8370888.A36432057.C826504", "operand":{ "value":"10/25/2021" } } ] }
3D Matrix	LESS_THAN	Get responses where value in A1.C2 is less than to 42 (C2 is formatted as number) { "items":[ { "operator":"LESS_THAN", "sourceItemKey":"Q8370888.A36432057.C826504", "operand":{ "value":"42" } } ] }
3D Matrix	LESS_THAN	Get responses where value in A1.C2 is less than "08/13/2022" (C2 is formatted as date MM/dd/yyyy) { "items":[ { "operator":"GREATER_THAN", "sourceItemKey":"Q8370888.A36432057.C826504", "operand":{ "value":"08/13/2022" } } ] }
3D Matrix	GREATER_THAN_OR_EQUAL	Get responses where value in A1.C2 is greater than or equal to 42 (C2 is formatted as number) { "items":[ { "operator":"GREATER_THAN_OR_EQUAL", "sourceItemKey":"Q8370888.A36432057.C826504", "operand":{ "value":"42" } } ] }
3D Matrix	GREATER_THAN_OR_EQUAL	Get responses where value in A1.C2 is greater than or equal to "10/25/2021" (C2 is formatted as date MM/dd/yyyy) { "items":[ { "operator":"GREATER_THAN_OR_EQUAL", "sourceItemKey":"Q8370888.A36432057.C826504", "operand":{ "value":"10/25/2021" } } ] }
3D Matrix	LESS_THAN_OR_EQUAL	Get responses where value in A1.C2 is less than or equal to 42 (C2 is formatted as number) { "items":[ { "operator":"LESS_THAN_OR_EQUAL", "sourceItemKey":"Q8370888.A36432057.C826504", "operand":{ "value":"42" } } ] }
3D Matrix	LESS_THAN_OR_EQUAL	Get responses where value in A1.C2 is less than or equal to "08/13/2022" (C2 is formatted as date MM/dd/yyyy) { "items":[ { "operator":"GREATER_THAN_OR_EQUAL", "sourceItemKey":"Q8370888.A36432057.C826504", "operand":{ "value":"08/13/2022" } } ] }
3D Matrix	BETWEEN	Get responses where value in A1.C2 is between 100 and 200 (C2 is formatted as number) { "items":[ { "operator":"BETWEEN", "sourceItemKey":"Q8370888.A36432057.C826504", "operand":{ "from":"100", "to": "200" } } ] }
3D Matrix	BETWEEN	Get responses where value in A1.C2 is between "10/25/2021" and "08/13/2022" (C2 is formatted as date MM/dd/yyyy ) { "items":[ { "operator":"BETWEEN", "sourceItemKey":"Q8370888.A36432057.C826504", "operand":{ "from":"10/25/2021, "to": "08/13/2022" } } ] }
3D Matrix	NOT_BETWEEN	Get responses where value in A1.C2 is not between 100 and 200 (C2 is formatted as number) { "items":[ { "operator":"NOT_BETWEEN", "sourceItemKey":"Q8370888.A36432057.C826504", "operand":{ "from":"100", "to": "200" } } ] }
3D Matrix	NOT_BETWEEN	Get responses where value in A1.C2 is not between "10/25/2021" and "08/13/2022" (C2 is formatted as date MM/dd/yyyy ) { "items":[ { "operator":"NOT_BETWEEN", "sourceItemKey":"Q8370888.A36432057.C826504", "operand":{ "from":"10/25/2021, "to": "08/13/2022" } } ] }
Object Lookup	EQUAL	Get responses where value is equal to "abc" (CM/DM column formatted as text) { "items":[ { "operator":"EQUAL", "sourceItemKey":"Q8370853.A36431966", "operand":{ "value":"abc" } } ] }
Object Lookup	EQUAL	Get responses where value is equal to 42 (CM/DM column formatted as numeric) { "items":[ { "operator":"EQUAL", "sourceItemKey":"Q8370853.A36431966", "operand":{ "value":"42" } } ] }
Object Lookup	EQUAL	Get responses where value is equal to"10/25/2021" (CM/DM column formatted as date MM/dd/yyyy) { "items":[ { "operator":"EQUAL", "sourceItemKey":"Q8370853.A36431966", "operand":{ "value":"10/25/2021" } } ] }
Object Lookup	NOT_EQUAL	Get responses where value is not equal to "abc" (CM/DM column formatted as text) { "items":[ { "operator":"NOT_EQUAL", "sourceItemKey":"Q8370853.A36431966", "operand":{ "value":"abc" } } ] }
Object Lookup	NOT_EQUAL	Get responses where value is not equal to 42 (CM/DM column formatted as numeric) { "items":[ { "operator":"NOT_EQUAL", "sourceItemKey":"Q8370853.A36431966", "operand":{ "value":"42" } } ] }
Object Lookup	NOT_EQUAL	Get responses where value is not equal to"10/25/2021" (CM/DM column formatted as date MM/dd/yyyy) { "items":[ { "operator":"NOT_EQUAL", "sourceItemKey":"Q8370853.A36431966", "operand":{ "value":"10/25/2021" } } ] }
Object Lookup	CONTAINS	CM/DM column formatted as text { "items":[ { "operator":"CONTAINS", "sourceItemKey":"Q8370853.A36431966", "operand":{ "value":"abc" } } ] }
Object Lookup	DOES_NOT_CONTAIN	CM/DM column formatted as text { "items":[ { "operator":"DOES_NOT_CONTAIN", "sourceItemKey":"Q8370853.A36431966", "operand":{ "value":"abc" } } ] }
Object Lookup	IN	Get responses where value is in list ["abc", "xyz"]. CM/DM column formatted as text { "items":[ { "operator":"IN", "sourceItemKey":"Q8370853.A36431966", "operand":{ "selected": ["abc", "xyz"] } } ] }
Object Lookup	IN	Get responses where value is in list ["42", "43"]. CM/DM column formatted as numeric { "items":[ { "operator":"IN", "sourceItemKey":"Q8370853.A36431966", "operand":{ "selected": ["42", "43"] } } ] }
Object Lookup	IN	Get responses where value is in list ["12/20/2022", "12/25/2022"]. CM/DM column formatted as date MM/dd/yyyy { "items":[ { "operator":"IN", "sourceItemKey":"Q8370853.A36431966", "operand":{ "selected": ["12/20/2022", "12/25/2022"] } } ] }
Object Lookup	NOT_IN	Get responses where value is not in list ["abc", "xyz"]. CM/DM column formatted as text { "items":[ { "operator":"NOT_IN", "sourceItemKey":"Q8370853.A36431966", "operand":{ "selected": ["abc", "xyz"] } } ] }
Object Lookup	NOT_IN	Get responses where value is not in list ["42", "43"]. CM/DM column formatted as numeric { "items":[ { "operator":"NOT_IN", "sourceItemKey":"Q8370853.A36431966", "operand":{ "selected": ["42", "43"] } } ] }
Object Lookup	NOT_IN	Get responses where value is not in list ["12/20/2022", "12/25/2022"]. CM/DM column formatted as date MM/dd/yyyy { "items":[ { "operator":"NOT_IN", "sourceItemKey":"Q8370853.A36431966", "operand":{ "selected": ["12/20/2022", "12/25/2022"] } } ] }
Object Lookup	GREATER_THAN	CM/DM column formatted as numeric: { "items":[ { "operator":"GREATER_THAN", "sourceItemKey":"Q8370888.A36432057", "operand":{ "value":"42" } } ] }
Object Lookup	GREATER_THAN	CM/DM column formatted as date (MM/dd/yyyy): { "items":[ { "operator":"GREATER_THAN", "sourceItemKey":"Q8370888.A36432057", "operand":{ "value":"12/25/2022" } } ] }
Object Lookup	LESS_THAN	CM/DM column formatted as numeric: { "items":[ { "operator":"LESS_THAN", "sourceItemKey":"Q8370888.A36432057", "operand":{ "value":"42" } } ] }
Object Lookup	LESS_THAN	CM/DM column formatted as date (MM/dd/yyyy): { "items":[ { "operator":"LESS_THAN", "sourceItemKey":"Q8370888.A36432057", "operand":{ "value":"12/25/2022" } } ] }
Object Lookup	GREATER_THAN_OR_EQUAL	CM/DM column formatted as numeric: { "items":[ { "operator":"GREATER_THAN_OR_EQUAL", "sourceItemKey":"Q8370888.A36432057.C826504", "operand":{ "value":"42" } } ] }
Object Lookup	GREATER_THAN_OR_EQUAL	CM/DM column formatted as date (MM/dd/yyyy): { "items":[ { "operator":"GREATER_THAN_OR_EQUAL", "sourceItemKey":"Q8370888.A36432057.C826504", "operand":{ "value":"12/25/2022" } } ] }
Object Lookup	LESS_THAN_OR_EQUAL	CM/DM column formatted as numeric: { "items":[ { "operator":"LESS_THAN_OR_EQUAL", "sourceItemKey":"Q8370888.A36432057.C826504", "operand":{ "value":"42" } } ] }
Object Lookup	LESS_THAN_OR_EQUAL	CM/DM column formatted as date (MM/dd/yyyy): { "items":[ { "operator":"LESS_THAN_OR_EQUAL", "sourceItemKey":"Q8370888.A36432057.C826504", "operand":{ "value":"12/25/2022" } } ] }
Object Lookup	BETWEEN	CM/DM column formatted as numeric: { "items":[ { "operator":"BETWEEN", "sourceItemKey":"Q8370853.A36431967", "operand":{ "from":"100", "to": "200" } } ] }
Object Lookup	BETWEEN	CM/DM column formatted as date (MM/dd/yyyy): { "items":[ { "operator":"BETWEEN", "sourceItemKey":"Q8370853.A36431967", "operand":{ "from":"02/24/2022", "to": "02/27/2022" } } ] }
Object Lookup	NOT_BETWEEN	CM/DM column formatted as numeric: { "items":[ { "operator":"NOT_BETWEEN", "sourceItemKey":"Q8370853.A36431967", "operand":{ "from":"100", "to": "200" } } ] }
Object Lookup	NOT_BETWEEN	CM/DM column formatted as numeric and date (MM/dd/yyyy): { "items":[ { "operator":"NOT_BETWEEN", "sourceItemKey":"Q8370853.A36431967", "operand":{ "from":"02/24/2022", "to": "02/27/2022" } } ] }
Multiple Object Lookup	IN	CM/DM column formatted as text { "items":[ { "operator":"IN", "sourceItemKey":"Q8370858.A36431998", "operand":{ "selected": ["user1", "user2"] } } ] }
Multiple Object Lookup	NOT_IN	CM/DM column formatted as text { "items":[ { "operator":"NOT_IN", "sourceItemKey":"Q8370858.A36431998", "operand":{ "selected": ["user1", "user2"] } } ] }

Filtering options

You can filter the responses based on any system field like, for example, ‘Create’ or ‘Submit date' or 'Status'.

If you use the API for Dashboards, pay attention that you can use only ‘completed’ and ‘in progress’ statuses for filtering, the 'auto created' one is ignored.

Parameter	Operator	Examples
CREATE_DATE_TIME	GREATER_THAN	Get responses where create date is greater than "2024-01-01" (value is formatted as date yyyy-MM-dd) { "items": [ { "sourceItemKey": "CREATE_DATE_TIME", "operator": "GREATER_THAN", "operand": { "value": "2024-01-01" } } ] }
LAST_SUBMIT_DATE_TIME	BETWEEN	Get responses where submit date is between "2024-01-01" and "2025-01-01" (value is formatted as date yyyy-MM-dd) { "items": [ { "sourceItemKey": "LAST_SUBMIT_DATE_TIME", "operator": "BETWEEN", "operand": { "from": "2024-01-01", "to": "2025-01-01" } } ] }