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'.

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" } } ] }