Breadcrumbs

REST API Results list examples

info 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

  • Response ID

  • Response label

  • Status

  • Code

  • Create date

  • Submit date.

Parameter

Operator

Examples

RESPONSE_ID

EQUAL

NOT_EQUAL

GREATER_THAN

GREATER_THAN_OR_EQUAL

LESS_THAN

LESS_THAN_OR_EQUAL

BETWEEN

NOT_BETWEEN

IN

NOT_IN

{
"items": [
{
"sourceItemKey": "RESPONSE_ID",
"operator": "EQUAL",
"operand": {
"value": "1527002149"
}
}
]
}


{
"items": [
{
"sourceItemKey": "RESPONSE_ID",
"operator": "BETWEEN",
"operand": {
"from": "1527001376",
"to": "1527002149"
}
}
]
}

RESPONSE_LABEL

EQUAL

NOT_EQUAL

CONTAINS

DOES_NOT_CONTAIN

IN

NOT_IN

{
"items": [
{
"sourceItemKey": "RESPONSE_LABEL",
"operator": "DOES_NOT_CONTAIN",
"operand": {
"value": "some_text"
}
}
]
}

STATUS

IN

NOT_IN

{
"items": [
{
"sourceItemKey": "STATUS",
"operator": "IN",
"operand": {
"selected": [
"STATUS.COMPLETED",
"STATUS.IN_PROGRESS"
]
}
}
]
}

CODE

EQUAL

NOT_EQUAL

CONTAINS

DOES_NOT_CONTAIN

IN

NOT_IN

{
"items": [
{
"sourceItemKey": "CODE",
"operator": "NOT_EQUAL",
"operand": {
"value": "some_text"
}
}
]
}

CREATE_DATE_TIME

EQUAL

NOT_EQUAL

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
EQUAL
NOT_EQUAL
GRATER_THAN

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-10-13",
"to": "2024-10-15"
}
}
]
}